I am having 8 columns and around 3000 rows in a single sheet.I want to find or highlight the identical rows.Identical means a whole row is duplicate.Thanks in advance.
I am having 8 columns and around 3000 rows in a single sheet.I want to find or highlight the identical rows.Identical means a whole row is duplicate.Thanks in advance.
Use the Data/Filter/Advanced Filter. Select "Unique records Only".
Hope that helps!
One way:
Select entire range and go to Format|Conditional Formatting
Select Formula Is from 1st Drop down and enter formula:
which assumes you have selected A1:H3000 adjust as necessary...Please Login or Register to view this content.
then click format and select your highlight colour.
click Ok.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks