occurence rank

  1. P

    Return Nth instance of text string

    I have the following formula that returns the most frequently occuring string in a range. what I would like to do is return the 2nd, 3rd 4th and 5th most common occourance as well. I am not sure if I can do this by adjusting this formula or whether that would be a completely diffent formula or...

Some videos you may like

This Week's Hot Topics