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

  • Thread starter Thread starter flatlander094
  • Start date Start date
F

flatlander094

Actually I do have cells that do not contain a number. If I did no
have any data to enter in the cell I entered "No Info" so the formul
would need to omit any cells that contain the word "No Info".

Thanks for the reply
 
Hi
normally MODE should just do this. It should ignore text values
 
You must log in or register to reply here.

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

Similar Threads

Excel How to find the most common pairs and triplets numbers? 5
Need help with Date/ and find most common denominator. 3
determine a range using a formula 2
Determine if time is within a windoww 2
using the =page! feature to transpose a row to column 0
Hiding Formulas 9
Excel Help to copy information from one row at a time to another sheet 1
one cell in a row contains a number 7

Back
Top