ChemistB
Forum Guru

Thanks for the scales tap!

Yep, it's difficult to get the "Column" part of the formula to match up because you have so many merged cells. Any of the gurus online will tell you to not merge cells for reasons like this. I'll work on it tomorrow.

You helped me on this a while ago, any reason why the green and blue isnt auto sorting with its corresponding colored table at the bottom? I keep getting REF! errors

http://www.excelforum.com/attachment...ason3test2.xls

Thanks for your appreciation

Regards

Thanks for the scales click!

You should see the PM's he sends me. OMG! And where do I sign up to get 1% DAILY return on my investment????

Thanks for the rep+

I spent 30years in the metal bashing business designing and making the b****y stuff among other things.
I found out that drawing pictures was easier than trying to explain to the client how it worked, thankfully bar-codes were rarer in those days.

Cheers
Alistair

are you any good with excel??