Find unique duplicate values in rows
I need to locate and highlight duplicate values in several rows. I can use the =countif function, but it takes too much time to use it for 30 different rows!
Sample data:
1 2 3 4 5 6 7 8 1
2 3 4 5 6 1 7 8 3
1 2 3 4 8 5 6 7 8
I need to flag "1" in the first row; "3" in the second row & "8" in the third row.
Last edited by Bay; 06-03-2011 at 11:24 AM. Reason: Solved
Could you use...
=MODE(A1:I1)
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Thanks for the reply Jeff, but as a new user, I need more detail please,
Regards Peter
If your data for row one extends from A1:I1 then in J1 you place this formula and then copy down.
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Thanks Jeff! Beats macros & =countif
Peter
Glad it works for you Peter
Please don't forget to mark the thread as solved if satisfied with reponse.
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks