Visit my Excel playlist with over 200 videos kzread.info/head/PLsYjn_fAfG42S1JmTFr7B5eTQRvm5w3sF

I've been looking for a way to highlight rows and not just cells...THANK YOU!

@ChrisMenardTraining

Жыл бұрын

No problem 😊

Thank you so much. I was looking for this.

Thank you so much ❤👍

@ChrisMenardTraining

Күн бұрын

Glad to help

you're a genius! thanks for this incredible tutorial. you just saved hours and hours of tedious work

@ChrisMenardTraining

2 жыл бұрын

You're welcome!

Was super helpful!!!! Had a spreadsheet with 200+ data elements. Developer said it was good go. Checked in Excel for duplicates and came back with 500+. He actually said "send me a duplicate." I color coded them :).

@ChrisMenardTraining

Жыл бұрын

Great to hear. You need a new developer. JK :-)

Thank you. I am a real estate agent pulling data and this helped save so much time

@ChrisMenardTraining

2 жыл бұрын

Glad it was helpful!

@TheAlexanderReid

2 жыл бұрын

@@ChrisMenardTraining Hey Chris, Do you have a video on how to delete all the highlighted data after sorting them through your method? I am trying to sort and filter and it doesn't recognize any of the data being highlighted.

I enjoyed your video a lot, it was direct to the matter, your explanation was clear, and you presented really good ideas. Thank you!

@ChrisMenardTraining

2 жыл бұрын

You're very welcome!

Your textjoin formula, give me new idea, new helper column with the help of Vlookup formula solved my problem to some extent..great. No doubt some tricks give new idea..like it, Regards

Very well explained. Thank you!

Thank you so much for this, I was looking for this everywhere!!!

absolutely loved it, cant thank enough!!!

@ChrisMenardTraining

2 жыл бұрын

Thank you.

Thank you Sir, bless your heart. I like the method join. I saw other videos methods out there and I got confused.

@ChrisMenardTraining

Жыл бұрын

You are very welcome

Awesome! Thanks Chris.

@ChrisMenardTraining

2 жыл бұрын

Any time!

This person is a master in excel

@ChrisMenardTraining

Жыл бұрын

Thank you! I appreciate the compliment.

Thank you so much Chris

@ChrisMenardTraining

Жыл бұрын

You are very welcome

THANKS A LOT FOR YOUR HELP!!!!!!!!!!

@ChrisMenardTraining

4 ай бұрын

welcome!

Brilliant!!Thanks so much.

@ChrisMenardTraining

Жыл бұрын

You're very welcome!

Genius! Thank you!

@ChrisMenardTraining

Жыл бұрын

You're welcome!

awesome video Thanks!!!

@ChrisMenardTraining

2 жыл бұрын

You're welcome!

very good video..can you please do a video on how to highlight duplicates in each row and not across entire row? Thanks

Thank you!

@ChrisMenardTraining

Жыл бұрын

You're welcome!

Great video. I agree with Jacob's comment. Using method 2, the TEXTJOIN has a limit of 255 characters which is disappointing as I have 49 columns in my dataset which exceeds the 255 limit

Great video

Subbed, Sir. Thank you!

@ChrisMenardTraining

Жыл бұрын

Appreciate it. Thanks, Cary!

Very helpful

@ChrisMenardTraining

Жыл бұрын

Thanks, David.

Nice Video 👍

@ChrisMenardTraining

2 жыл бұрын

Thank you 👍

What if in column has the word transferred and other texts. So bow it would highlight entire rows. Should I do ="transferred" instead of >1 it's not about to highlight duplicates, it's about to highlight all the rows and columns. When the column Comments contains the word "transferred nurse Mary to Lisa" because the rows with transferred will be appended or copy and pasted to a database. I love your videos. This one is one of my favorite.

This helps! How do i delete the duplicate rows and keep one instance of that row. I have 1000 such cases in my dataset. Please help.

Note to all: This does not work if the cell you built using concatenate or textjoun is too many characters. You will need to use a formula for cells with lots of characters.

@alonesoul6292

10 ай бұрын

I tried similar thing with concatenate and textjoin as well but when I tried to highlight duplicates with help of conditional formatting, Excel was not able to highlight the duplicate rows I was trying for a dataset of 25 columns and 5000 rows Could you please suggest some feasible way for huge higher datasets In this scenario I shall try with the lengthier formula shown at the end, where for each of the columns we have to mention criteria etc.

It's cool. I noticed that when I delete the duplicates and start putting duplicates for other names, the formula does not work. I have to go to the formula and adjust the number rows/range. So to avoid this, do I have to convert range rows into table format to prevent this?

Can we find duplicate text lines somehow? In Google Docs or on your chrome browser tab where you have text on a webpage, etc.

I must be doing something wrong. I wanted to highlight all rows that had duplicate first and last names (column C and D) so a made a helpercolumn U using =C2&D2 applied and incrumented for the column (C158:D158)this works fine. I set a new conditional formating rule using the formula ="countifs($U$2:$U$158,$U2)>1" select format/fill orange and hit ok. Nothing happens. Using Excel 2016. What did I do wrong?

Let's say you only want to find duplicates of numbers in a column that contains letters and numbers. How do you prevent the duplicate feature from looking at text, and only at numbers?

Art Vandelay :D

Hi Chris, how do we highlight values which duplicate but not highlighting one value among the duplicates considering one to be unique. For example Consider A1:A10 have same values and I only want A2:A10 to be highlighted, thereby making A1 a unique value

@rafi1937

11 ай бұрын

Hi, late answer but when you select a range, I have chnged the second value to (INDIRECT(ADRESS(ROW(P6);16))) Where P6 is the first the concat cell and 16 is the column number. Insted of checking full range it looks for values in range from the first cell to the current one so first iteration will always be left unchanged. Example of full formula: =countifs($P$6:(INDIRECT(ADRESS(ROW(P6);16)));$P6)>1

Hi sir, your video helped me :) i have 1 question, please help. I highlighted duplicate content, now 1. i want to sort rows which are not highlighted. 2. i want to match highlighted content from column A to B Thank you

What if, we only have one column and need to highlight those with the first 5 matching characters on the same column?

Disregard my question below, it's working now the rule to show new duplicates, before was not showing because I thought the duplicate row I pasted was duplicate, but it was not duplicate, only the name of the person was duplicate but with different values: example: Maria has avocados, and Maria in another row has orange. So it's not duplicate.

Hello Chris. I'm having a hard time typing a certain formula. Are you able to help me out?

How to do this highlight duplicate rows for multiple sheets?

It worked the text join and the rule, but when I add new duplicate row data, it does not highlight the new duplicates. Do I have to edit the rule again to show the new duplicates on the h2:h16, H17 and so forth

Hi, how to highlight duplicate values that are more than 15 characters in a single column?

@ChrisMenardTraining

2 жыл бұрын

Add a helper columns and use the LEN function. LEN counts the number of characters in a text string. Sort by the helper columns. Screenshot drive.google.com/file/d/1xk3p0jkhaHTqINWkdRQiYunKi2J0wOtU/view?usp=drivesdk

@joshtodice

2 жыл бұрын

@@ChrisMenardTraining wow thanks, keep up the good work creating awesome tutorials 🌟🌟🌟🌟🌟

Nothing worked