| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding n-th most frequently occuring word
I am trying to find the n-th most frequently occurring name is a database. I
have a formula that finds the top most frequently occurring name =INDEX(rng,MATCH(LARGE(UNIQUEVALUES(COUNTIF(rng,rn g)),2),COUNTIF(rng,rng),0)) this being entered as an array. How would I find the second, third, fourth, etc. most frequently occurring name? Example: George Ilysha Steven George Steven George Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a word in CSV files | Excel Discussion (Misc queries) | |||
| Return Frequently occuring Rows, based on COUNT | Excel Worksheet Functions | |||
| Extracting the most frequently occuring text from a range | Excel Worksheet Functions | |||
| Finding All but Last Word | Excel Worksheet Functions | |||
| Finding specific word in column | Excel Worksheet Functions | |||
Threaded Mode
