| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif, Maxa or other function?
Hi all,
I'm having a column with text items. I'm looking for a function which shows the text value that is most represented in the specific colomn. Can anyone help? Thanks, JacobK. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif, Maxa or other function?
If there are no blank cells in the range
=INDEX(A2:A50,MODE(MATCH(A2:A50,A2:A50,0))) if there can be blanks =INDEX(A2:A50,MATCH(MAX(COUNTIF(A2:A50,A2:A50)),CO UNTIF(A2:A50,A2:A50),0)) both entered with ctrl + shift & enter -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "jacobk" wrote in message ... Hi all, I'm having a column with text items. I'm looking for a function which shows the text value that is most represented in the specific colomn. Can anyone help? Thanks, JacobK. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif, Maxa or other function?
Peo,
This was what I looked for!!! Thanks for you great help! Greetings, JacobK. "Peo Sjoblom" wrote: If there are no blank cells in the range =INDEX(A2:A50,MODE(MATCH(A2:A50,A2:A50,0))) if there can be blanks =INDEX(A2:A50,MATCH(MAX(COUNTIF(A2:A50,A2:A50)),CO UNTIF(A2:A50,A2:A50),0)) both entered with ctrl + shift & enter -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "jacobk" wrote in message ... Hi all, I'm having a column with text items. I'm looking for a function which shows the text value that is most represented in the specific colomn. Can anyone help? Thanks, JacobK. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| CountIf function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| COUNTIF and then SUM in Same Function | Excel Worksheet Functions | |||
| hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
Hybrid Mode
