Extract top 10% of column values in Excel and place in another column
excel, vba
Solution
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)
Problem
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.