Mathis E.

I've run this in a worksheet with 8000 rows without problems so It seems fairly waterproof!

One thing I forgot to mention in the video is that the ranking doesn't rerun automatically if new rows are added. This is a pretty easy workaround with a run if new rows are added formula. You would only have to rerun the lookup-rows for the people in the company of which new rows have been added.

This is how i've gotten it to work: https://www.loom.com/share/a0d9992abf5b44fb8904a30d94a3346a

I've gotten it to work very consistently but it ranks people sequentially. Not sure if that is what you want

That helped a lot thanks!

When searching for these in the add enrichment field I don't get any results. How do I find these enrichments?

Thanks! I'll do that for now

But both don't work for me!