Hello All, i have some difficulties in a name list format with formula(index+match?) to sort & fill.
can someone here to help me out?
i need to return with priority "Lead" first, Name sequence in order, and final with others position.
i hope you guys would understand what i'm trying to present.
thanks so much for your great help
can someone here to help me out?
i need to return with priority "Lead" first, Name sequence in order, and final with others position.
i hope you guys would understand what i'm trying to present.
thanks so much for your great help
| PETER | 12:00-21:30 Lead | 12:00-21:30 Photo |
| DAVID | 09:00-18:30 Lead | 12:00-21:30 Photo |
| ELSA | 09:00-18:30 Photo | 09:00-18:30 Lead |
| CHARLIE | 12:00-21:30 Photo | 09:00-18:30 Lead |
| KEN | 12:00-21:30 MSS/HH - Photo | 10:30-20:00 Stroller |
| ROY | 10:30-20:00 Stroller | 09:00-18:30 Lead |
| YOYO | 09:00-18:30 Lead | 12:00-21:30 Lead |
| DAVID | ELSA | |
| ELSA | CHARLIE | |
| YOYO | ROY | |
| ROY | KEN | |
| PETER | YOYO | |
| CHARLIE | DAVID | |
| KEN | PETER |
