| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula (or code) return the largest number of duplicates in a list.
Without using an actual value, how can I return the largest number of repeats in column A.
So if there are 33 "abc"'s, 22 "def"'s, 9 "ghi"'s etc in a very long list, it would return the value 33. All the while I have no idea what all the values are in column A. Therefore =COUNTIF(A1:A200,"abc") would be out of the question. Plus one would have to have a formula for each value, right? Thanks, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I select the largest number in a list... | Excel Discussion (Misc queries) | |||
| Search multiple sheets and return largest number found | Excel Worksheet Functions | |||
| return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
| Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
