CODEWITHSUNDEEP
excelvba
Dora
Dora

Reputation: 63

Extract top 10% of column values in Excel and place in another column

I have an excel spreadsheets with values in one column. What i need is a VBA code that will identify top 10% of column values, and place them in a adjacent column.

Upvotes: 2

Views: 15509

Answers (1)

Totero
Totero

Reputation: 2574

Why not ignore VBA and use the percentile function to create a true false column and filter on that.

EG. Is the Value in B2 in the top 10% of values in Column B?

=B2>=PERCENTILE($B$2:$B$17,0.90)

Upvotes: 9

Related Questions