View Single Post
  #5   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

Thanks to all for the responces. I'll get busy and try them. Let you know the
results.
Thanks again
DobieG

"Gary''s Student" wrote:

Say in column G we have:

1
4
2
5
7
6
8
3

In A1 enter:
=MAX(G:G) gives the max value (in this case 8)

In A2 enter:
=MATCH(MAX(G:G),G:G,0) gives the row in which the max can be found (in this
case 7)

--
Gary''s Student - gsnu200790


"BarDoomed" wrote:

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?????????