If you could help me tweak this.
I am using this formula: =If(COUNTIF(C$1:C$7,A1),"",A1) and I want it to put
in Col B the amounts from col a that do not have a match in col c. My
problem is it matches both of the $25.00 amounts from col a when there was
only one $25.00 amount in column c. I would want it to show 1 $25.00 in col
b as not being a match.
A B C
$ 50.00 $ 25.00
$ 3.00 $ 75.00
$ 467.00 $ 467.00 $ 95.00
$ 30.00 $ 30.00 $ 3.00
$ 25.00 $ 50.00
$ 25.00 $ 90.00
$ 50.00 $ 60.00
$ 99.00
Thanks