Have a spreadsheet with multiple columns where I want to sort using two columns of data as the sort criteria. I have an SKU column and a Customer ID column each with numbers. There are 12,000 combination of numbers that I want to sort for. For example, I may have an SKU number 1111 and a customer number 222 and want to identify and sort the data set for all occurrences of this combination. There are 12,000 of the combinations among 60,000 rows of data.
How can I sort these out with it being two columns of data? I've spent hours trying to figure this out. Please help if you have a solution.
Many thanks for your help in advance.
FordRacer
How can I sort these out with it being two columns of data? I've spent hours trying to figure this out. Please help if you have a solution.
Many thanks for your help in advance.
FordRacer