| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the location of what was summed
I'm using this formula to sum how many times a unique order number
appears in column A: =SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=N,1)) where N is the number of times it appears. There is one order that appears six times and I need to find out what that order number is. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the location of MAX value in column | Excel Discussion (Misc queries) | |||
| Finding Location of Maximum Value in 2D Array | Excel Discussion (Misc queries) | |||
| Finding Location of Maximum Value in 2D Array | New Users to Excel | |||
| finding cell location | Excel Discussion (Misc queries) | |||
| finding rightmost location of a character | Excel Worksheet Functions | |||
Threaded Mode
