I'm hoping someone can help me with a challenging equation / macro. I need to compare text in a row of 5 cells to determine if 3 of the 5 cells contain the same text. While each row will only contain 5 cells, I will need to run the equation / macro on upwards of 10,000 row. It would be great if the majority answer was copied to an empty cell at the end of each row.
I'm an intermediate Excel user that hasn't played with macros. However, I can follow instructions very well.
Thanks in advance for you help.
Andy
Say your range is A1:E1, try:
=COUNTIF(A1:E1,INDEX(A1:E1,MODE(MATCH(A1:E1,A1:E1,0))))>=3
this returns true, if at least 3 cells are the same.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks