| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find max value in column and return offset of that value
I have a set of sales data with the items listed in column A and columns B
through M are headed by month and contain the total value of each item sold that month. I want to know which product sold best each month. Does anyone know how to get Excel to find the maximum value in a column and the text in the corresponding row of column A? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find max value in column and return offset of that value
Something like this in N2 and dragged down:
=index($b$1:$m$1,match(max($b2:$m2),$b2:$m2,0)) deborah wrote: I have a set of sales data with the items listed in column A and columns B through M are headed by month and contain the total value of each item sold that month. I want to know which product sold best each month. Does anyone know how to get Excel to find the maximum value in a column and the text in the corresponding row of column A? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find max value in column and return offset of that value
Thank You!!!
"Dave Peterson" wrote: Something like this in N2 and dragged down: =index($b$1:$m$1,match(max($b2:$m2),$b2:$m2,0)) deborah wrote: I have a set of sales data with the items listed in column A and columns B through M are headed by month and contain the total value of each item sold that month. I want to know which product sold best each month. Does anyone know how to get Excel to find the maximum value in a column and the text in the corresponding row of column A? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find max value in a row and return column title | Excel Worksheet Functions | |||
| offset 1 row and return to first column | Excel Discussion (Misc queries) | |||
| Find Largest and Return Column Name | Excel Worksheet Functions | |||
| Find certain text in a column and return statement | Excel Worksheet Functions | |||
| find Max value in row--return value in same column, different row | Excel Worksheet Functions | |||
Hybrid Mode
