Cell reference of result
 

The result of the following formula is 1,396,250; it is found in cell E44:
=LARGE($C$44:$F$44,COUNTIF($C$44:$F$44,"0"))

What function can I use to return the cell reference (i.e., E44) rather than
the amount?

FYI . . . The amounts in the array are as follows, if it matters:
C44 -1650000
D44 -436250
E44 1396250
F44 3575000

Thank you!
Elizabeth

Cell reference of result
 

Hi!

Try this:

=ADDRESS(ROW(C44:F44),MATCH(LARGE(C44:F44,COUNTIF( C44:F44,"0")),C44:F44,0)+COLUMNS($A44:B44),4)

Biff

"Elizabeth" wrote in message
...
The result of the following formula is 1,396,250; it is found in cell E44:
=LARGE($C$44:$F$44,COUNTIF($C$44:$F$44,"0"))

What function can I use to return the cell reference (i.e., E44) rather
than
the amount?

FYI . . . The amounts in the array are as follows, if it matters:
C44 -1650000
D44 -436250
E44 1396250
F44 3575000

Thank you!
Elizabeth

Cell reference of result
 

Biff:
PERFECT! I tried all sorts of combinations of functions before requesting
help, but didn't tried "Match". THANK YOU SO MUCH!
Elizabeth

"Biff" wrote:

Hi!

Try this:

=ADDRESS(ROW(C44:F44),MATCH(LARGE(C44:F44,COUNTIF( C44:F44,"0")),C44:F44,0)+COLUMNS($A44:B44),4)

Biff

"Elizabeth" wrote in message
...
The result of the following formula is 1,396,250; it is found in cell E44:
=LARGE($C$44:$F$44,COUNTIF($C$44:$F$44,"0"))

What function can I use to return the cell reference (i.e., E44) rather
than
the amount?

FYI . . . The amounts in the array are as follows, if it matters:
C44 -1650000
D44 -436250
E44 1396250
F44 3575000

Thank you!
Elizabeth

Cell reference of result
 

You're welcome. Thanks for the feedback!

Biff

"Elizabeth" wrote in message
...
Biff:
PERFECT! I tried all sorts of combinations of functions before requesting
help, but didn't tried "Match". THANK YOU SO MUCH!
Elizabeth

"Biff" wrote:

Hi!

Try this:

=ADDRESS(ROW(C44:F44),MATCH(LARGE(C44:F44,COUNTIF( C44:F44,"0")),C44:F44,0)+COLUMNS($A44:B44),4)

Biff

"Elizabeth" wrote in message
...
The result of the following formula is 1,396,250; it is found in cell
E44:
=LARGE($C$44:$F$44,COUNTIF($C$44:$F$44,"0"))

What function can I use to return the cell reference (i.e., E44) rather
than
the amount?

FYI . . . The amounts in the array are as follows, if it matters:
C44 -1650000
D44 -436250
E44 1396250
F44 3575000

Thank you!
Elizabeth