Hi!
I tried to find a descriptive title for a problem that has been nagging me for a while.
If I use an array formula of the type
If I have 2 columns a and B with
A B
1 X
2 X
3 Z
4 Y
5 X
and I want to make a table with
X,Y,Z with the results being the...
Good evening!
I have been trying to understand why the following formula does not work as I have used it successfully for named ranges, and it is the only way I know to refer to a range name where teh name is in another cell.
in A, B, C, I have ranges that are dynamic and are called AA, BB...