|
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. |