# Sorting Large Data Set with Mixed Data

1. ## Sorting Large Data Set with Mixed Data

Does anyone have any good ideas on how to sort mixed data set? I've pulled a 70+ page that I will need to rerun about 60 times over the next few months. I'm hoping I can build a macro or template that will get me to the meat of the data faster.

Cell A2 includes the customer number (6 digits) and A3-A7 includes their last several order numbers (8 digits), A8 includes the next customer number and A9-A20 includes their last several orders... Each customer will have a different number of orders. I'm hoping that I can create a new column that will associate the correct customer number with the correct order number. Then I can apply a number of if statements that will give me the data that should be reviewed by people.

I appreciate any insights! Thank you.

2. ## Re: Sorting Large Data Set with Mixed Data

Welcome to the forum,

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

3. ## Re: 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.

4. ## Re: Sorting Large Data Set with Mixed Data

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?

5. ## Re: Sorting Large Data Set with Mixed Data

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.

6. ## Re: Sorting Large Data Set with Mixed Data

This is my solution.

7. ## Re: Sorting Large Data Set with Mixed Data

Originally Posted by xlbiznes
This is my solution.
WOW! Thank you so much!This is amazing and it worked great.

8. ## Re: Sorting Large Data Set with Mixed Data

You are welcome, glad i could help.

Please, mark this thread as solved if you are satisfied with the solution provided.

There are currently 1 users browsing this thread. (0 members and 1 guests)