- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Have a value be shown as the referneced cell

Subject: | Have a value be shown as the referneced cell |

Posted by: | Marc |

Date: | Tue, 22 Jul 2008 |

I am running a formula =Max($a$1:$B$55,1) to find the largest number in a set

of data. The answer was found in cell A36.

The formula was fine but I was wondering if there is a formula that will

display the answer's cell location.

The value of A36 is 10.

With my formula =Max($a$1:$B$55,1) the answer is 10.

But I would need another formula to display A36 (or the cell's location)

The find function isn't working

- Re: Have a value be shown as the referneced cell posted by MAX on Tue, 22 Jul 2008