Top 10 most common TEXT

[Cooki]

Hi all i want to be able to find the 10 top most common cells.

I can find the top most common with this
=INDEX($D$3:$D$35,MODE(IF($D$3:$D$35<>"",MATCH($D$3:$D$35,$D$3:$D$35,0))))

Second most common with this
=INDEX($D$3:$D$35,MATCH(LARGE(COUNTIF($D$3:$D$35,$D$3:$D$35),MAX(COUNTIF($D$3:$D$35,$D$3:$D$35))+1),COUNTIF($D$3:$D$35,$D$3:$D$35),0))

but can find the rest.

Would someone be able to help and if possible to have a formula that you only increase a number to find the next most common?

TIA

 

[Bo_Ry]

Please try at F3
=INDEX($D$3:$D$35,MODE(IF(ISNA(MATCH($D$3:$D$35,F2:F2,)),MATCH($D$3:$D$35,$D$3:$D$35,0))))

Confirm by Ctrl+Shift+Enter

 

[Cooki]

Please try at F3
=INDEX($D$3:$D$35,MODE(IF(ISNA(MATCH($D$3:$D$35,F2:F2,)),MATCH($D$3:$D$35,$D$3:$D$35,0))))

Confirm by Ctrl+Shift+Enter

Im getting N/A

Is anything meant to be in F2, as you have used it as an array?

I have pushed ctrl+shift+enter

 

[Bo_Ry]

There are blank cells

=INDEX($D$3:$D$35,MODE(IF($D$3:$D$35<>"",IF(ISNA(MATCH($D$3:$D$35,F$2:F2,)),MATCH($D$3:$D$35,$D$3:$D$35,0)))))

 

[Cooki]

There are blank cells

=INDEX($D$3:$D$35,MODE(IF($D$3:$D$35<>"",IF(ISNA(MATCH($D$3:$D$35,F$2:F2,)),MATCH($D$3:$D$35,$D$3:$D$35,0)))))

Works spot on.

As an added extra is there a wanted to get the corresponding column if i curround it with Offset that should work