View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BarDoomed BarDoomed is offline
external usenet poster
 
Posts: 3
Default Identify the row in which a MAX number in a column resides

I am building a worksheet that collects data from a network on a daily basis.
One of the data categories has 9 columns and 8 rows. I am finding the MAX of
each column but need to identify the row in which a MAX number in a column
resides at the same time. Probably pretty simple but for some reason I can't
put it together.

Thanks
DobieG

Why my display named shows up as BarDoomed I don't know?????????