CascadeDiver
Board Regular
- Joined
- Apr 10, 2020
- Messages
- 62
- Office Version
- 2016
- Platform
- Windows
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]))))
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]))))