I have a value say in Cell A1.
I want to compare the value in Cell A1 with all the values in the cells in Column B (which may have thousands).
I am interested in all the values in Column B which are lower than the value in cell A1.
If a cell value in Column B is lower than the value in A1, then I want to go to the adjacent column, Column C, and see the value of that cell, the one adjacent to the one in Column B.
Now I want to compare the values in Column C and pick the 10 or 15 highest and be put in cells A2, A3, A4, etc..
Can this be done?
(This is my first post here. I followed Rick Rothstein here.)
Bookmarks