View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ CJ is offline
external usenet poster
 
Posts: 102
Default Show Cell Reference

Hi Groupies

I would like to be able to see which cell the Max function is referring to.

For example: I have a list of values in B1 - B250. The Max function returns
the highest value in that range, but I would also like to find out which cell
contains that value. Is this possible?
--
Thanks for the brainwaves!