Second & Third most frequent text with criteria

I have been able to successfully input the most frequently occurring text in a range based on criteria by using an array formula based on the INDEX, MATCH, MODE, and IF functions.

I also need to find the 2nd most frequent occuring text in a range based on criteria as well as the 3rd most frequent using a variation of the formula but don't know how to go about editing the formula to accomplish this.

Here is the formula I created to get most frequent state based on ID: =INDEX(State,MODE(IF(ID =D3,MATCH(State,State,0)))) where ID = A2:A22 and State = B2:B22. I am unable to share a screenshot but will add as a table below.

I agree attaching a sample would be more helpful

I can be done with formulas but they would be complicated and probably need helper columns. the below is just 1 column not 2
https://www.mrexcel.com/forum/excel-...ues-range.html

I would pivot the data with ID and state as rows, count of state as the value, and sort by the values descending

this should be fairly easy to pick from to complete your table, but if you attach a sheet would be quick to do

I believe I have attached the source file. Let me know if you have any issues!

I'm impressed, a bit of exercising the old grey matter to understand it. Will file it away for future use!