sequence formula

kelvin_9

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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,415
Messages
5,837,110
Members
430,477
Latest member
roseinsydney

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