I have 2 spread sheets. 1 sheet has codes in each cell, Like "BV09n" (there
are about 40 different codes) and they change daily. The other sheet has all
the codes that need to be in the first sheet each day. What formula would I
use to check the first sheet (using the 2nd sheet) for missed or duplicate
codes which are manually changed and screwed up regularly?

Thanks
Dave
--
David L