Dynamic Lookup for COUNTIF

[HasanSheriff]

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.

[#2 · Accepted solution]

@HasanSheriff 

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

[#3]

@Yea_So 

I'll have to learn the Power Query. Wish my luck!

Thanks!

[#4]

@Yea_So 

You're a life saver!

[#5]

It wasn't so painful to learn power query was it? and now you learned something new and an added hammer in your toolbox