| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how findout max data like text, any word in excel
sir,
i have list like rajesh kishor narendra rajesh rajesh kishor kishor rajesh and i want to find above maximum name with reslut rejesh is max time i.e 4 time plese help me |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how findout max data like text, any word in excel
Hi,
Try this. there mustn't be any blanks in the range =INDEX(A1:A20,MODE(MATCH(A1:A20,A1:A20,0))) This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array Mike "how findout max data like text, any word" wrote: sir, i have list like rajesh kishor narendra rajesh rajesh kishor kishor rajesh and i want to find above maximum name with reslut rejesh is max time i.e 4 time plese help me |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how findout max data like text, any word in excel
Hi,
You can try with subtotals also and you would get the results exactly like you have desired. -- Thanks Suleman Peerzade "how findout max data like text, any word" wrote: sir, i have list like rajesh kishor narendra rajesh rajesh kishor kishor rajesh and i want to find above maximum name with reslut rejesh is max time i.e 4 time plese help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| findout the difference between to time; not date | Excel Discussion (Misc queries) | |||
| Transfer Excel data into Word, including text box data | Excel Discussion (Misc queries) | |||
| How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
| Name Findout From a interval range | Excel Worksheet Functions | |||
| Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Linear Mode
