1. L

    duplicated rows formula

    Hi I want to highlight duplicated rows. Thanks for your help, I know the formula now but I have had hard time to interpret it. Conditional Formatting --> Formula =countif($A$2,$A$200,A2)>1 what exactly this formula is doing? thank you so much

Some videos you may like

This Week's Hot Topics