View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JeanPierre Charron JeanPierre Charron is offline
external usenet poster
 
Posts: 24
Default Need to flag the lead ID of any contiguous ID's from a sortedlist of ID's.

Thank you Claus. You definitely put me on the right track.
Unfortunately I will have more alphanumeric convoluted cases that will require testing other fields to determine whether we are dealing with a lead ID or not.
I will just take one case at a time.
Have a good day,
J.P.