Jan 25 2021 03:29 PM
Hi All - Running into a roadblock trying to solve the following issue:
- I have a filtered list of data that I needed to count visible cells with specific text, I was able to do that with a SUMPRODUCT function.
- Now that I have these totals I need to show a list of text associated with the rows of data that have been counted through the SUMPRODUCT function.
How can I do this? I've tried a few different things and nothing has worked. Thanks in advance!
Jan 26 2021 12:56 PM
You may add helper column with formula as
=AGGREGATE(3,5,[@anyColumn])
which returns 1 for visible columns and zero instead. Use it in SUMPRODUCT()
I used structured reference, will be cell reference if that's not a Table.