matching only once
 

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

matching only once
 

=IF(A1="","",IF((COUNTIF($C$1:$C$8,A1)*COUNTIF($A$ 1:A1,A1))<1,A1,""))

copy down


"Donna" wrote:

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

matching only once
 

It worked great. Thank you so much

"Teethless mama" wrote:

=IF(A1="","",IF((COUNTIF($C$1:$C$8,A1)*COUNTIF($A$ 1:A1,A1))<1,A1,""))

copy down


"Donna" wrote:

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

matching only once
 

You're Welcome!


"Donna" wrote:

It worked great. Thank you so much

"Teethless mama" wrote:

=IF(A1="","",IF((COUNTIF($C$1:$C$8,A1)*COUNTIF($A$ 1:A1,A1))<1,A1,""))

copy down


"Donna" wrote:

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