Excel VB - Find the 2 highest values and the 2 lowest in column range
Posted on 2013-01-20
Once I again I need to turn to you for assistance.
I have data in columns that I need to find the 2 highest numbers and the 2 lowest numbers in each column range. (Max & Min).
My columns used are "B" to "W" with rows "3:13" being the consistent range.
Once I have found these 4 cells (the 2 max and 2 min) - I will copy them to another worksheet. In addition to this, I need to transfer the corresponding cell from column "A" (same Row) to the other worksheet, as well. For example: checking Column "D" - the max is in Row 8, Then value of "D8" is Max1 and "A8" is the relating cell.
If the routine put the 4 cells in the corresponding column on lines 15:19, with the offset from column "A" for each entry, then I can copy from there then clear the cells.
Any assistance would be greatly appreciated,