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 11:20 AM. Reason: Solved
You may want =MODE(A1:C1)
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
Thank you Jeff, this is exactly what I need. SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks