Cell address with array

[CascadeDiver]

Hello all,

I have an array formula that I would like to find the cell address, unfortunately when I add CELL("address", in front of it the formula doesn't work. Any thouhgts?

{=MAX(IF(ISNUMBER(Dive_Ledger[Max Depth]),IF(Dive_Ledger[Diver''s Name]=Rep_Name,Dive_Ledger[Date])))}
=CELL("address",MAX(IF(ISNUMBER(Dive_Ledger[Max Depth]),IF(Dive_Ledger[Diver''s Name]=Rep_Name,Dive_Ledger[Date]))))

 

[mabbutt]

Have a look here and specifically example 3.

 

[CascadeDiver]

Have a look here and specifically example 3.

I still seem to be having difficulties achieving the cell reference.

 

[mabbutt]

I still seem to be having difficulties achieving the cell reference.

Can you provide a little more information or even better a working example of the spreadsheet?

 

[Marcelo Branco]

Do you really need the cell address? Do you intend to use it in another formula or for some other reason?

M.

 

[CascadeDiver]

Can you provide a little more information or even better a working example of the spreadsheet?

I can provide a screenshot of an example. Unfortunately with my work PC I will be unable to install XL2BB. If requested I will upload this test file.

I've used named ranges for Name (B14) and Date (B15)

 

[CascadeDiver]

Do you really need the cell address? Do you intend to use it in another formula or for some other reason?

M.

Both, I was trying to utilize the cell address to catch errors and use as a quick reference.

 

[CascadeDiver]

I wanted to mention that I did find a workaround. However, if there is an answer, for someone else who runs into this issue or if I run into it again I am still interested.

Thanks