PDA

View Full Version : Finding a cell



Tenspeed39355
03-17-2006, 01:26 PM
Good afternoog guys. I have the MIN of a row of numbers in A2. The number are in C2:IV2. How can I see the location of the MIN number.
I can put the result in B2. Example: If the lowest number is in G2 what formula do I use to see G2 in B2. Thanks for your help with this
Max

mdmackillop
03-17-2006, 01:37 PM
=ADDRESS(2,MATCH(A2,C2:IV2,0)+2,4)

Tenspeed39355
03-17-2006, 01:42 PM
Thanks for the super quick reply. I just hit enter and was sitting looking at the screen and the reply came thru. You guys are great.
That solved the problem. I will rate the reply
Max

mdmackillop
03-17-2006, 01:54 PM
Hi Max,
Always happy to help.
Regards
MD