Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I want to return the column heading based on the highest value in a range of
rows. I want to return the week that had the most units sold. I have the units sold for each week by item and the total for that week. I used the large() and found the largest amount but I don't know where to begin on returning the week that this number occurs. I have 1218 items over a 23 week period that I want to compare. Any help is greatly appreciated. Thank, Lee Coleman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup value,return column heading | Excel Worksheet Functions | |||
Return the value of a column heading | Excel Discussion (Misc queries) | |||
Return column heading | Excel Worksheet Functions | |||
Return Column Heading after lookup | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) |