Matching Issue

[punter]

I have a matching issue that I hope someone would know the answer to:

I have thousands of lines of data a week (transfers between variou
stores) that I am dealing with. I have left an example below:

From To Total Units
10 (10.00)
455 (14.00)
459 (14.00)
611 (6.00)
600 10.00
15 14.00
544 14.00
600 6.00

There are many more columns but these are the ones that I would need t
confirm a match or not. What I would like to do is run a column nex
to Total Units and put a formula in there that will show me if an
numbers have matched. I have been trying for a while and I just can
seem to get it to work.

Any help would be great.

I hope you all had a great Thanksgiving

 

[Guest]

Dear Punter

Try putting the following expression in the "Check" column:
=IF(COUNTIF($B$1:$C$9999,B1)>1,"Matching Entry","")
And then fill down the expression

Hope this helps you

Kind regards

Paul