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

flatlander094 · Oct 4, 2004

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

Frank Kabel · Oct 4, 2004

Hi
normally MODE should just do this. It should ignore text values

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

flatlander094

Frank Kabel