Sorting and extracting data without losing information.

[JTatBodyHealth]

Hello all,

The answer to my questions is probably here somewhere but I'm not really sure what I'm looking for.

I have a spreadsheet that was exported from Quickbooks. Since 1998 the system in place was to input all the of the customer data into QB via "quick add." This put's all the customer info into the shipping field.

Now we need to extract that info and put them into individual fields. My boss has exported a xls. doc and handed this task to me.

I need to know how I can extract certain data, like an email address and put it in it's own column but retain the username it's associated with.

I then need to organize the list with the transactions in order from newest to oldest and keep only the two most recent and delete the rest for each customer.

Any help is greatly appreciated.

 

[JTatBodyHealth]

Okay, so I figured some things out. I was able to find and highlight all my email addresses and sort them. I only need to know how to keep just the two most recent orders. So how do I select the two most recent and delete the rest of the invoices for each customer?