Arup Dutta Chowdhury
Member
I have got a date wise text file. Where date wise PO,Flexi and NPO is given. Now I want to find which one text is highest. PO, Flexi or NPO.
Find maximum text value
- Thread starter Arup Dutta Chowdhury
- Start date
Khalid NGO
Excel Ninja
Hi,
If you want to know the most repeated entry, use MODE function which works with Numbers only, for text we can use the MATCH function inside the MODE and wrap it with INDEX to return the most repeated entry:
=INDEX(A2:A6,MODE(MATCH(A2:A6,A2:A6,0)),)
Array formula needs to be entered with Ctrl+Shift+Enter
Regards,
If you want to know the most repeated entry, use MODE function which works with Numbers only, for text we can use the MATCH function inside the MODE and wrap it with INDEX to return the most repeated entry:
=INDEX(A2:A6,MODE(MATCH(A2:A6,A2:A6,0)),)
Array formula needs to be entered with Ctrl+Shift+Enter
Regards,