Return Min & Cell address

  • Thread starter Thread starter L. Howard
  • Start date Start date
L

L. Howard

Can this be done to return the MIN of F2, G2 or H2 and and "F", "G" or "H" which ever is the MIN?

Where F2=1, G2=2, F2=3.

This returns 1 FALSE.

=MIN(F2:H2)&" "&IF(ADDRESS(2,6)=MIN(F2:H2),"F",IF(ADDRESS(2,7)=MIN(F2:H2),"G",IF(ADDRESS(2,8)=MIN(F2:H2),"H")))

Thanks.
Howard
 
Hi Howard,

Am Tue, 29 Jul 2014 00:18:53 -0700 (PDT) schrieb L. Howard:
Can this be done to return the MIN of F2, G2 or H2 and and "F", "G" or "H" which ever is the MIN?

Where F2=1, G2=2, F2=3.
Click to expand...

try:
=MIN(F2:G2)&" in "&ADDRESS(2,MATCH(MIN(F2:G2),A2:G2,0),4)


Regards
Claus B.
 
Hi again,

Am Tue, 29 Jul 2014 09:27:53 +0200 schrieb Claus Busch:
=MIN(F2:G2)&" in "&ADDRESS(2,MATCH(MIN(F2:G2),A2:G2,0),4)
Click to expand...

sorry, typo.

Try:
=MIN(F2:H2)&" in "&ADDRESS(2,MATCH(MIN(F2:H2),A2:H2,0),4)


Regards
Claus B.
 
Hi Howard,

Am Tue, 29 Jul 2014 00:50:56 -0700 (PDT) schrieb L. Howard:
Never ceases to amaze me
Click to expand...

always glad to help.

If the minimum can also occur in A2:E2 you will get a wrong cell
address.
In this case you better do the MATCH into the range for minimum:
=MIN(F2:H2)&" in "&ADDRESS(ROW(F2),MATCH(MIN(F2:H2),F2:H2,0)+COLUMN(F2)-1,4)

The formula is more versatile. You also can copy down the formula.


Regards
Claus B.
 
If the minimum can also occur in A2:E2 you will get a wrong cell

address.

In this case you better do the MATCH into the range for minimum:

=MIN(F2:H2)&" in "&ADDRESS(ROW(F2),MATCH(MIN(F2:H2),F2:H2,0)+COLUMN(F2)-1,4)



The formula is more versatile. You also can copy down the formula.





Regards

Claus B.
Click to expand...

I can't make that error occur with the first formula.

With 1 to 8 in A - H both seem to work fine, each returns "6 in F2".

I'll go with the latter on your advice anyway.

Thanks again.
Howard
 
Back
Top