Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to count text entries and return text with most entries
Hi all
I need to create a formula that will look down a column of text (e.g. apple, apple, apple, pear, orange) and not just count but return the actual entry that has been entered most -above would obviously be "apple" I believe i would not to create an array formula but most formulas seem to relate to numbers or want to convert text to numbers. I just want the formula to display the word entered most in the relevant column. Regards to all Reppy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Multiple Text Entries | Excel Worksheet Functions | |||
Count instances of text in date entries | Excel Worksheet Functions | |||
count text entries | Excel Worksheet Functions | |||
Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
count cells that contain text entries | Excel Worksheet Functions |