in cell C1 put

=VLOOKUP(A1,B$1:B$99,1,FALSE)

and formula-copy this for the number of rows.

'B$1:B$99' should be the extent of the data in column B

The #N/A rows are the items you are looking for.

--

petevang Wrote:
I have two columns of data (A and B) whos cells consist of only numbers
in order from 1 to 50. Columns A's ranges from 1 to 50, and every
whole number is present. Column B is missing a few numbers. I want to
see what numbers are not in column B but are in column A. Is their a
formula that could highlight the missing cells?:)


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=530786