Hi,
I have a set of data with a non-unique numerical ID. However, the column "Name" can be considered unique. Please see below. The cell reference of "Order ID" is B1 and the bottom right cell is G15.
I need to filter this table to sort by the size of the ID column. I need to do this using an active formula. I do not have access to the filter() function as I am using an old version of excel.
I have ordered the Order ID column using the formula large(). I now need to pull through each name associated with each ID into this table. For example, in the table above both Liam and Harry have an ID of 675.666. If I used a standard vlookup in the table below, Harry would be returned for both instances. I need both Harry and Liam to show in subsequent cells. i.e. conduct a vlookup but ignore any names already returned in the rows above? I'm a bit lost on how to do this, so any help would be greatly appreciated.
For further context, the cell reference of the cell containing "Helper" is I1, and the bottom right cell is K15.
I have a set of data with a non-unique numerical ID. However, the column "Name" can be considered unique. Please see below. The cell reference of "Order ID" is B1 and the bottom right cell is G15.
| Order ID | Name | Poule Number | Victories | Prop | Indicator |
845.3333333 | James | 1 | 5 | 0.83 | 12 |
497 | Peter | 1 | 3 | 0.50 | -3 |
328.3333333 | Charlie | 1 | 2 | 0.33 | -5 |
328.3333333 | Alex | 1 | 2 | 0.33 | -5 |
675.6666667 | Harry | 1 | 4 | 0.67 | 9 |
-17 | Benjamin | 1 | 0 | 0.00 | -17 |
1015 | David | 1 | 6 | 1.00 | 15 |
670.6666667 | Tom | 2 | 4 | 0.67 | 4 |
-9 | Emily | 2 | 0 | 0.00 | -9 |
502 | Emma | 2 | 3 | 0.50 | 2 |
664.6666667 | Amy | 2 | 4 | 0.67 | -2 |
675.6666667 | Liam | 2 | 4 | 0.67 | 9 |
325.3333333 | George | 2 | 2 | 0.33 | -8 |
502 | Anthony | 2 | 3 | 0.50 | 2 |
I need to filter this table to sort by the size of the ID column. I need to do this using an active formula. I do not have access to the filter() function as I am using an old version of excel.
I have ordered the Order ID column using the formula large(). I now need to pull through each name associated with each ID into this table. For example, in the table above both Liam and Harry have an ID of 675.666. If I used a standard vlookup in the table below, Harry would be returned for both instances. I need both Harry and Liam to show in subsequent cells. i.e. conduct a vlookup but ignore any names already returned in the rows above? I'm a bit lost on how to do this, so any help would be greatly appreciated.
For further context, the cell reference of the cell containing "Helper" is I1, and the bottom right cell is K15.
| Helper | Ordered ID | Ordered Name |
1 | 1015 | James |
2 | 845.3333333 | |
3 | 675.6666667 | |
4 | 675.6666667 | |
5 | 670.6666667 | |
6 | 664.6666667 | |
7 | 502 | |
8 | 502 | |
9 | 497 | |
10 | 328.3333333 | |
11 | 328.3333333 | |
12 | 325.3333333 | |
13 | -9 |
