Second Post - Similar to my first but not quite!

I have a spreadsheet with around 1000 rows. Each row details a product, date created, contact, and much more.
Every row has a "T" Number - but the number is in TEXT format
NOT every row has a Referrer - they just crop up now and then - an this is where my problem lies...

I want to dynamically create a list that contains only rows that have a referrer - and I need to be able to select various other values from each referrer row, such as the T number and start date, but I don’t need all the other "stuff"

I would like the list to be sorted in name (Referrer) order, then by Date Created.


Post2.png



Number Stuff Stuff Product Stuff Stuff CategoryStuff Date Created Stuff Stuff Stuff Contact Referrer
================================================================================================================================
T1 Stuff Stuff Product 1 Stuff Stuff Cat 1 Stuff 01/01/2012 Stuff Stuff Stuff Bob
T2 Stuff Stuff Product 2 Stuff Stuff Cat 2 Stuff 01/01/2012 Stuff Stuff Stuff Jim Chris
T3 Stuff Stuff Product 3 Stuff Stuff Cat 1 Stuff 02/01/2012 Stuff Stuff Stuff Phil
T4 Stuff Stuff Product 3 Stuff Stuff Cat3 Stuff 03/01/2012 Stuff Stuff Stuff Graham
T5 Stuff Stuff Product 2 Stuff Stuff Cat3 Stuff 03/01/2012 Stuff Stuff Stuff Vicki Doug
T6 Stuff Stuff Product 1 Stuff Stuff Cat 1 Stuff 03/01/2012 Stuff Stuff Stuff Jo
T7 Stuff Stuff Product 2 Stuff Stuff Cat 2 Stuff 04/01/2012 Stuff Stuff Stuff Andrew
T8 Stuff Stuff Product 2 Stuff Stuff Cat 2 Stuff 04/01/2012 Stuff Stuff Stuff Ali Doug
T9 Stuff Stuff Product 3 Stuff Stuff Cat 1 Stuff 05/01/2012 Stuff Stuff Stuff Kat
T10 Stuff Stuff Product 3 Stuff Stuff Cat3 Stuff 06/01/2012 Stuff Stuff Stuff Emily Bob




Only rows with a referrer are sorted by name and date order:




ReferrerNumber Product Categry Date Created Contact
=======================================================================
Bob T10 Product 3 Cat3 06/01/2012 Emily
Chris T2 Product 2 Cat 2 01/01/2012 Jim
Doug T5 Product 2 Cat3 03/01/2012 Vicki
Doug T8 Product 2 Cat 2 04/01/2012 Ali