I need to indicate a missing # in a series

  • Thread starter Thread starter A Sunfire
  • Start date Start date
A

A Sunfire

I have an inventory list with inventory tag #'s associated with it. I would
like Excel to indicate when a # in the sequence is missing.
 
It depends on what you define as "missing", and how you want this indicated.
What I do is use a conditional format like:
=a2<>a1+1
and choose a highlight color.

Regards,
Fred
 
Back
Top