Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted

See a formula that will Conditionally Format The Row with nth Duplicate, Column Sorted or Not Sorted:
1. MATCH and ROWS functions in a logical formula for a sorted column
2. COUNTIF and AND functions with an expandable range in a logical formula for a non-sorted column.

[excelisfun]

You are welcome!

It is amazing how something as seemingly simple as keyboards can make things much quicker, and more fun!

[excelisfun]

Thanks, hamy72! Just a guy having fun with Excel!!

[ExcelStrategy]

These custom conditional formating formulas are incredible !

[straighttovideo]

Hey Mike,

Great formula; love those clever uses of expanding range.

I always thought it was odd the number of keystrokes it took to get to Conditional Format by Formula then today after using the new Alt+H+L+N rather than my normal "Tab & series of Down Arrows" I hit End and sure enough if it jumped me straight to "Use a Formula..." still had to hit Alt+O to actually enter the formula box, but considering how often I use CF by Formula this really speeds things up for me.

Thanks again!

[lisianab]

Thanks a lot for these videos ! I have one question: My everyday work is all about Excel..calculating salaries.My datas are in some different workbooks and in the end of the month, I have to join all the data i one excel sheet. But it takes me a lot of time to do this. Please do you have a video about this? thank you

[excelisfun]

I do not, but, for back and forth dialog to get Excel solutions try THE best Excel question site:

mrexcel [dot] com/forum

[jeremymargallo]

THEY DONT MATCH
6:18 OF VIDEO
HIGHLIGHTED YELLOW IS SIOUX 0.58
WHILE TABLE IS SIOUX 0.27