Quote:
Originally Posted by Spencer101
Have a look at the attachment. Is this what you need?
|
that did it, thank you very much. I looked at the formula and I see why your and formula worked. Basically when I tried doing it I was thinking of doing some IF statements, could never get it to work.