Statistics Problem
In vba code, I need to go through several rows (with 75 cols each) and pick
out the top 6 values PER ROW.
Are there any vba methods that would help me do this?
First, I thought I would sort and then pull of the first 6 cells. Can you
sort by Row? If not, should I transform the rows into cols and then sort
the cols?
Next, I have tried to find a Percentile / Rank or a Top N type function.
Any suggestions?
Thanks in advance!
|