Extract top 10% of column values in Excel and plac

2019-09-12 05:44发布

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.

1条回答
倾城 Initia
2楼-- · 2019-09-12 05:55

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)
查看更多
登录 后发表回答