studentlearner
New Member
- Joined
- Oct 7, 2021
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
So currently am working for a queue system that which reset the queue to number 1 once fulfilled the value
This is what i'm working with:
Once data entry is completed, there will be a button that triggers a formula and should look something like the bottom table:
Question is if there is a formula which can have the queue extract the first table data onto something like the second table.
Any help would be great thank you!!
This is what i'm working with:
Username ID | Buyers ID | Buyers Total Order |
T03 | 99 | 02 |
T01 | 98 | 03 |
T02 | 97 | 04 |
Once data entry is completed, there will be a button that triggers a formula and should look something like the bottom table:
Queue ID |
Q99-T03-01 |
Q99-T03-02 |
Q98-T01-01 |
Q98-T01-02 |
Q98-T01-03 |
Q97-T02-01 |
Q97-T02-02 |
Q97-T02-03 |
Q97-T02-04 |
Question is if there is a formula which can have the queue extract the first table data onto something like the second table.
Any help would be great thank you!!