If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|