| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| row matching using IF | Excel Discussion (Misc queries) | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
| Matching | Excel Worksheet Functions | |||
Threaded Mode
