Thread: simple: Identify a cell that is out of number sequence in a list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
bprice bprice is offline
external usenet poster
  
Posts: 5
Default simple: Identify a cell that is out of number sequence in a list
In Excel
How do I ID the specific cell that has fallen out of sequence in a list?
Example:

A1= 1
A2= 2
A3= 3
A4= 5 (flag this cell because the number "4" is missing)
A5= 6

Do I use a formula or is there a menu option I can use?
Reply With QuoteReply With Quote