View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
a-one-and-a-two a-one-and-a-two is offline
external usenet poster
 
Posts: 5
Default Use validation for (sometimes) sequential number list

We manually enter order numbers in one column of our spreadsheet, which are
usually, but not always sequential. Can I use validation to alert when the
next entered order number is NOTa sequential whole integer? Thanks for any
assistance!