I would like to compare three cells and have the most frequently appearing value appear in a fourth cell, such as;
A1=7, B1= 9, C1=7 THEN; D1 WOULD TAKE THE VALUE OF 7.
Thank you for any help you can offer.
I would like to compare three cells and have the most frequently appearing value appear in a fourth cell, such as;
A1=7, B1= 9, C1=7 THEN; D1 WOULD TAKE THE VALUE OF 7.
Thank you for any help you can offer.
Last edited by Cutthroat; 03-02-2011 at 12:20 PM. Reason: Solved
You may want =MODE(A1:C1)
HTH
Regards, Jeff
Thank you Jeff, this is exactly what I need. SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks