Database Manipulation Sample for Forum.xlsm

Hi all,

I have a very very large list that I need edited, and I don't think IF statements are going to cut it!

I have attached an example spreadsheet to show you possibly better than I can explain it.

Column B has account #s, they are always different, sometimes the same but then a dash number would be different. Example below
012345-000
012345-001

Column C has company names, generally all the same. Example below
ABC Shop
ABC shop

Column D has address 1 - this is where I need help. This can be different or be the same. Example below
012345-000 ABC Shop 123 Fake Street
012345-001 ABC Shop 123 Fake Street

OR

012345-000 ABC Shop 123 Fake Street
012345-001 ABC Shop 456 Fake Street

Column E has Address 2 - generally used for PO boxes or suite/rooms
STE 204
STE 204

or

STE 204
STE 402

I would like Column F, G, H, become "extra account #'s", but they would only be used if the name, address 1 and address 2 were the exact same.

However, each column F,G,H would have to be organized based on Column J.

Column J has different price classes
0000 = normal pricing
0004 = discount pricing
5001 = government pricing

So if Row 3 were the same as Row 2, the spreadsheet would put Row 3's account # into column G because it gets discount pricing, based on the comparison of column J.

It would be extremely helpful and basically required, that if after matching between Row 2 and Row 3, Row 3 would be deleted.

Is this even possible, or should i do everything manually?

Appreciate your comments and suggestions