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?

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

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