Hi there,
For Z10:Z59, if there is a value, rather than "", l want to list the corresponding cell in the same row in Column Y, put next to the corresponding cell in the same row for Column AA .
There's a twist though: I want it all in one cell.
I mean, l want the formula in one cell, such that it produces a list for me, within that one cell.
A list of everything in the range Row 10 to Row 59 , that fits the condition.
Bookmarks