comparison

This all may be a little over my head, but I'll throw it out there and see if anyone can help.

I have a need to do what I guess you would call a comparision on two columns in an excel spreadsheet and move the rows around to match up any duplicates. in other words, if 'Orlando' is found in cell A20 AND in B21, B35 and B40, move those rows so that all of the 'Orlando's end up in a grouping.

Is there a way to maybe there was a way to dump the excel into a SQL Server table, massage the data to match up the rows and then dump it back out to a spreadsheet (while preserving the rest of the data in the spreadsheet)???

are the 2 columns related, if you move b31 does a31 have to move with it (any other cells in row 31),

can you post an example of the data in the sheet

maybe you could sort the data in column 1, and in column 2 then move the data in the 2 colums to align

pete

Example of data attached. Basically, the Data in Columns A and B are related and D and E are related. I need to match up the data in Columns B and D
ie... group all the "Cullmans" together, all the "Anaheims" together, etc... but If data Column B moves to match up with a match in Column D, then the associated data in Column A must move with it. Does this sound do-able?

is this the result you are looking for (as far as 'F'), so i know if i am on the right track

pete

I'm not sure if I know what you mean when you say (as far as 'F') ??

as far as the places starting with letter f in the list

pete

Sorry, I completely missed the fact that you had sent back an attachment.. duh!!!!!

yes, that is what I'm looking for. ideally all of the 'matches' found for columns B and D would be grouped together and a blank row inserted to seperate them. I wasn't sure if this could be done programmatically...

haha neither am i, but i wanted to make sure that at least i was trying to do what you wanted

if a group is just 1 do you want a blank line before and after?

pete

I would think yes. Is there really a way to do this??

i am sure it is possible, though i haven't got it all working properly yet

pete

Thanx :)

i managed to loose your spreadsheet, which didn't matter, but all my code went with it, so i had to start again, anyway have a look at this and give me feed back

pete

Looks like it's on the right track.. how did you do it??