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.
Hi everyone! I would like to find out how many employees a company has in a certain department (IT, HR, etc.). Does anyone have any experience with this or any idea how to do this?