It didn't workTry
Excel Formula:=IF(B3="","",,IF(COUNTIF(C:C,B3)>=COUNTIF(B:3:B4,B3),"Match","No Match"))
Is it possible that the figure will show in column D instead of match. Means if Column B and C has same value that same figure should reflect in column DThere were a couple of typos in Jason's formula, tryExcel Formula:=IF(B3="","",IF(COUNTIF(C:C,B3)>=COUNTIF(B$3:B3,B3),"Match","No Match"))
Is it possible that the figure will show in column D instead of match. Means if Column B and C has same value that same figure should reflect in column D
Cell Formulas | ||
---|---|---|
Range | Formula | |
E3:E5 | E3 | =IFERROR(VLOOKUP($A3,C:C,1,0),"No Match") |
This is basic formula editing, you change what you don't want to what you do want.Is it possible that the figure will show in column D instead of match.
=IF(B3="","",IF(COUNTIF(C:C,B3)>=COUNTIF(B$3:B3,B3),B3,"No Match"))
Your method doesn't allow for unique matching of duplicate values.What Abt?
@Jason75..I would suggest , let her revert.Your method doesn't allow for unique matching of duplicate values.
Book3 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
2 | List1 | Output | Output | |||
3 | 500 | 500 | 500 | |||
4 | 100 | No Match | No Match | |||
5 | 1500 | 1500 | 1500 | |||
6 | 500 | List2 | No Match | 500 | ||
7 | 500 | No Match | ||||
8 | 147 | No Match | ||||
9 | 1500 | No Match | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3:D9 | D3 | =IF(B3="","",IF(COUNTIF(C:C,B3)>=COUNTIF(B$3:B3,B3),B3,"No Match")) |
E3:E9 | E3 | =IFERROR(VLOOKUP($B3,C:C,1,0),"No Match") |