I need a formula to determine the most common data in a row.

F

flatlander094

I created a spreadsheet that has thousands of entries and hundreds o
rows on it. I am trying to write a formula that will look at a part o
a row and tell me the most common entry. Example, if the cells in th
row had entries of 2,3,2,2,3,2,6,2, the formaula would tell me that
is the most common entry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top