View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lee Lee is offline
external usenet poster
 
Posts: 38
Default Return Column Heading based on value in row

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