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