Sorting Large Data Set with Mixed Data

Originally Posted by xlbiznes

Welcome to the forum,

posting a sample file with data and the desired output would help members to understand your requirement.

Thanks, I just edited my initial post to include an attachment.

I'm still confused...

who ordered the items in rows 9-20. Your post implies it was customer 2 (1213457), but the sheet implies it was customer 1 (123456). Who was it?

Also, how come cutomer 3 has the same number (123456) as customer 1?

Exactly what do you want to see in the "new column" that you refer to?

Originally Posted by Glenn Kennedy

I'm still confused...

who ordered the items in rows 9-20. Your post implies it was customer 2 (1213457), but the sheet implies it was customer 1 (123456). Who was it?

Also, how come cutomer 3 has the same number (123456) as customer 1?

Exactly what do you want to see in the "new column" that you refer to?

1. Rows 9-20 are related to the customer listed in A8.
2. That was a mistake. It should have been customers 3 and 4 with unique customer numbers. That should be fixed now.
3. I'd like the new column to look for the six digit number immediately above the order number and plug it into the order row.

Thanks.

Originally Posted by xlbiznes

This is my solution.

WOW! Thank you so much!This is amazing and it worked great.