Hi all, sorry about the long winded title but i guess if knew what to call what i wanted to do i may have had more luck finding an answer using Uncle Google.
I have been trying to use Excel to sort data in this particular way for quite few years and never had any luck. I do have a work around using Microsoft Access but it is pretty long winded and involves a lot of imorting and exporting and recombiming data sets and spreadsheets.
In the example below, i'd like to match the second set of data to the first set of data based on the contents of G compared to B.
I have worked out ways to report repeats and colour cells that are repeated but i'd like the data to sort itself as per the lower data set. So, matched where there is agreement between columns but inserting blank lines in either data range where there is no match.
This may well be a step too far for Excel but it has been a thorn in my side for quite a few years now. Potential problem, i'm no VB script writer. Having said that though, i have had some success in the past adapting code that i have found on various forums to suit my needs.
Any help would be much appreciated, even if it is to say "sorry fella, you ain't gonna be doing that without a degree in computer programming". At least i can put it to bed then.
Thanks in advance for any and all help.
Smiffy
original data
A B C D E F G H
point 1 abc 215 point 1 sjh 195
point 2 sjh 652 point 2 dek 555
point 3 njd 549 point 3 igd 645
point 4 ksi 562 point 4 mo 726
point 5 igd 147 point 5 ako 822
point 6 bad 562 point 6 sae 471
point 7 mo 361 point 7 ubb 14
point 8 ako 622
point 9 qok 514
point 10 lna 698
point 11 ubb 477
required output
A B C D E F G H
point 1 abc 215
point 2 sjh 652 point 1 sjh 195
point 2 dek 555
point 3 njd 549
point 4 ksi 562
point 5 igd 147 point 3 igd 645
point 6 bad 562
point 7 mo 361 point 4 mo 726
point 8 ako 622 point 5 ako 822
point 6 sae 471
point 9 qok 514
point 10 lna 698
point 11 ubb 477 point 7 ubb 14
Bookmarks