How do I create a VBA that will compare the list of numbers in EV70:EV79
for the 3 highest and the 3 lowest values in the column.
But in either case, if the highest numbers nor the lowest numbers cannot
exceed more than 5 numbers when values are equal.
If EV70, then add to EX71=0
If EV71, then add to EX71=1
If EV72, then add to EX71=2
If EV73, then add to EX71=3
If EV74, then add to EX71=4
If EV75, then add to EX71=5
If EV76, then add to EX71=6
If EV77, then add to EX71=7
If EV78, then add to EX71=8
If EV79, then add to EX71=9
Example
EU.....EV.................EX71.......EW71.......EX71
0...... 2
1...... 3................2865........................370
2...... 6
3...... 1
4...... 4
5...... 3
6...... 5
7...... 1
8...... 6
9...... 5
for the 3 highest and the 3 lowest values in the column.
But in either case, if the highest numbers nor the lowest numbers cannot
exceed more than 5 numbers when values are equal.
If EV70, then add to EX71=0
If EV71, then add to EX71=1
If EV72, then add to EX71=2
If EV73, then add to EX71=3
If EV74, then add to EX71=4
If EV75, then add to EX71=5
If EV76, then add to EX71=6
If EV77, then add to EX71=7
If EV78, then add to EX71=8
If EV79, then add to EX71=9
Example
EU.....EV.................EX71.......EW71.......EX71
0...... 2
1...... 3................2865........................370
2...... 6
3...... 1
4...... 4
5...... 3
6...... 5
7...... 1
8...... 6
9...... 5