Insert Alphabatically

[ManUBlueJay]

I am stumped on a work around on this.
I have 15000 lines of data 6 columns wide. called Roster Table


Col 3 has all the names Family name in bold followed by all members of family in the same Col. I would like to be able to have excel insert a new family in the alpha roster. Col 2 does define if it is a family or a name. I would like to do this without adding another col of data that has broken out the last names to avoid another 15k cells of data.

 

[FDibbins]

1. formulas cannot see formatting, like bold etc
2. if you don't want to insert a new (helper) column, you wont be able to do this with formulas
3. because, once the data is extracted, a helper formula would no longer be needed, you could easily use a helper column, then copy/paste values to remove the formulas

 

[ManUBlueJay]

It does have the unique "Family" place holder in Col 2

 

[FDibbins]

Can you show some sample data please?