May 13 2021 08:10 PM
Hi All,
Wondering if this is possible.
The items in Column J and L are a list lookup (auto sorted alphabetically) from another sheet and is updated constantly, so a hard link in the COUNTIF statement to Column L will be inaccurate when the list is updated (and reorganized when resorted alphabetically).
I'd like COUNTIF to pickup whatever item is in the adjacent Column L.
Thanks guys.
May 13 2021 08:35 PM
Solution
do a power query against that list for column J and column L then after you load the query to the worksheet, click the refresh down arrow:
And uncheck the background refresh setting:
So now you can use the data with the countif without worrying about it being resorted or whatever
May 13 2021 09:09 PM
May 13 2021 09:33 PM
May 13 2021 08:35 PM
Solution
do a power query against that list for column J and column L then after you load the query to the worksheet, click the refresh down arrow:
And uncheck the background refresh setting:
So now you can use the data with the countif without worrying about it being resorted or whatever