Sorting

[litlfrog]

It may well be easier than I realize; I'm not an experienced Excel user and don't often have to do more than examine things in a spreadsheet. I'm just the guy who has time to work on this.

I have a big csv file exported from our program and have saved it as an xls. Each line is a record of a stop somewhere along a route, along with information about the customer at that stop. If a customer appears on more than one route, each entry is a separate line. One of the columns is called Route Name. For organizational purposes, around 1,000 customers were assigned to a route called ALL AMERICAN. This is not an actual route that's run; it was a way to group those customers together for sales purposes. I need to figure out which customers have the Route Name ALL AMERICAN and also have at least one other Route Name, then either extract those customers to a new file or delete all the customers who don't meet those criteria from the existing file. I don't know if that should be accomplished by a function, sorting hoodoo, a pivot table, or some other method. Can anybody provide guidance on this? Thanks.

[stanleydgromjr]

litlfrog,

Welcome to the Excel Forum.


To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[litlfrog]

The file litlfrogsample1 contains a tiny portion of altered data with no sensitive information. It's got two account numbers, 11058 and 11059, who are on two routes: ALL AMERICAN and a different route. It also has one other account, 850, that is not assigned to ALL AMERICAN; the actual data has something like 13,000 such entries. I'd like to somehow get rid of those entries who are not on that route. The file litlfrogoutput2 contains what I'd ideally like to achieve--the extra accounts are gone, and the secondary routes the customer has been assigned to are appended to the end of the row.

[stanleydgromjr]

litlfrog,

I can not see the logic from the original raw data to the output you are looking for.

Click on the New Post button, then enter just the word BUMP, then click on the Submit Reply button, and someone else will assist you.

[litlfrog]

BUMPing in the hopes of additional help.