Forum Discussion
You probably don't know this Excel function: =CELL( )
I recently came across a function I have never used before and you've probably not heard about it either. The function I'm talking about is CELL(info_type, [reference]), I think it's quite neat. It ...
Also, I like how handy it comes when using CELL("address"). It can be useful when combined with nested INDEX/MATCH functions and then apply an INDIRECT to that cell address in order to perform further calculations.