Macro or formula for each change in value

[x077695]

Hi Excel Experts,
I have a formula that needs to be applied to each change in zip code(column A). I understand that the formula would need to be modified.
Basically, I need to find the minimum value of the top 10%. for each zip.

=MIN(CHOOSEROWS(SORT(A$XXXX:A$XXXXX,1,-1),SEQUENCE(COUNTA(A$XXXXX:A$XXXXX)/10,1,1,1)))


Any help would be appreciated!

 

[Anfinsen]

Hello,
I think a pivot table would be best for what you are asking.

 

[x077695]

Hello,
I think a pivot table would be best for what you are asking.

Thanks for the advise!