Comparing 2 lists of data

**bd528** · 06-24-2009, 05:12 AM

Hi,

I'm sorry if this has been answered elsewhere. I've searched and not found something I can impliment.

Please see attached

Sheet 1 is the data
Sheet 2 is the comparison information

Each supplier account number (column A), must have the correct number of account numbers (column K), and those account numbers must be correct.

In the example, supplier account 03040149 doesnt have enough account numbers.

I'd like a formula or macro to run the check and display the results in column L.

Example is dumbed down. There will be hundreds of suppliers.

Thanks in advance.

**bd528** · 06-25-2009, 03:33 AM

Bump - any help would be great!

**DonkeyOte** · 06-25-2009, 03:40 AM

Without using VBA you really need to think about storing the Supplier AC No. adjacent to each transaction (in a separate column if nec.) ... not doing this is going to make things far more complex... are the results PT outputs per chance ? (ie why is the Supplier AC No not listed on each row ?)

**bd528** · 06-25-2009, 03:47 AM

The file I'm working on is software generated. Sorry, I dont know what PT stands for.

I'm happy to copy and paste information (by macro if possible) if that makes things easier.