Aligning data according to 2 columns

[rellum]

Hi everyone,

I just need some help aligning some data. Cupno has more entries than seqno and there are duplicate entries. I cannot think of a way to get seqno+results to align with cups. If it's possible to delete rows the don't have a corresponding seqno thats ok too. I've attached the example workbook. Sheet1 is the data and Sheet2 contains what ideally the results should look like

Thanks in advance for any help.

[rylo]

Hi

Have a look at the 2 macros below. aaa matches most of the output shown in sheet2 columns A:C, while bbb matches most of E:G. To me the manual output seems to have changed the logic used, so can you please provide the rules for obtaining the output that you have produced.

Please Login or Register  to view this content.

rylo

[rellum]

Thanks heaps! aaa does exactly what I needed to get done!