JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 785
- Office Version
- 365
- Platform
- Windows
Hi,
if i have the following data (columns A-C):
and column F
i want to allocate the closest available and then remove it from list
e.g if DefaultNo is 51
look through Available closest to 51 and take it from the list
repeat down
expected result:
any help appreciated
if i have the following data (columns A-C):
Name | DefaultNo | Allocated |
John | 51 | |
Jim | 88 | |
Tom | 33 | |
Luke | 56 | |
Paul | 56 | |
Frank | 49 | |
Bob | 49 | |
James | 38 | |
Trevor | 56 |
and column F
Available No |
29-A |
29-B |
30-A |
30-B |
30-C |
32-D |
35-A |
41-A |
42-A |
43-B |
44-A |
48-A |
49-A |
49-B |
49-C |
49-D |
51-D |
57-E |
57-G |
58-A |
60-A |
71-B |
i want to allocate the closest available and then remove it from list
e.g if DefaultNo is 51
look through Available closest to 51 and take it from the list
repeat down
expected result:
Name | DefaultNo | Allocated |
John | 51 | 51-D |
Jim | 88 | 71-B |
Tom | 33 | 32-D |
Luke | 56 | 57-E |
Paul | 56 | 57-G |
Frank | 49 | 49-A |
Bob | 49 | 49-B |
James | 38 | 41-A |
Trevor | 56 | 58-A |
any help appreciated