June 27, 2016
I have a filtered block of data, and I filter on items in column L, say. I've picked up a formula from an Excel website, which shows in a cell which item in that column I'm filtering on :
It works fine, but I'd be grateful, if someone could explain to me in simple terms, what the formula actually does - I particularly lose the plot when it comes to the array brackets.
July 16, 2010
The curly braces are inserted by Excel automatically when you press CTRL+SHIFT+ENTER to complete the formula.
This tutorial on arrays might help you understand how your formula is evaluating: https://www.myonlinetraininghu.....ay-formula