I've got a list of sales data with a few different groupings I'm using to differentiate by region, product type, etc.

I have an Xlookup(Large(If formula that I use to pull the top 5 selling products in each group for each time period. Works great.

But I also want to find the rank of one specific product in each group that won't always be in the top 5.

Is there anyway for me to start with the product name and then look up it's rank within a set without having to generate ranks for the entire set?

Between time period and the other conditions, it results in dozens of unique sets with ~150 products each, so I'd like to avoid having to rank them all, though I could add a helper column if it's the only way.