Re: Is there an Excel formula
Posted 4/26/2007 11:47:57 AM by Waste06

Countif is actually easier.

In Column C, type

=COUNTIF($B$1:$B$5,$A1)

If the numbers match, you'll get a 1
If the numbers don't match, you'll get a 0

Again, the range will change based on the length of your list.

Print Post      Close Window