matching only once

D

Donna

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
 
T

Teethless mama

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

copy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using an IF function for a total 2
How to I sum data from one sheet based off mulitple variables? 7
returning a value in a table referencing ranges 2
Excel 2007 4
How to use Sumifs with vertically and horizontally criterias 1
How to use Sumifs with vertically and horizontally criterias 3
Sumproduct forumla for complex sum. 16
sumproduct to add total amounts for the month 6

Top