sequence formula

kelvin_9

Active Member
Joined
Mar 6, 2015
Messages
258
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

PETER12:00-21:30
Lead
12:00-21:30
Photo
DAVID09:00-18:30
Lead
12:00-21:30
Photo
ELSA09:00-18:30
Photo
09:00-18:30
Lead
CHARLIE12:00-21:30
Photo
09:00-18:30
Lead
KEN12:00-21:30
MSS/HH - Photo
10:30-20:00
Stroller
ROY10:30-20:00
Stroller
09:00-18:30
Lead
YOYO09:00-18:30
Lead
12:00-21:30
Lead
DAVIDELSA
ELSACHARLIE
YOYOROY
ROYKEN
PETERYOYO
CHARLIEDAVID
KENPETER
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,129,553
Messages
5,636,982
Members
416,953
Latest member
broexc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top