View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dekowal3 dekowal3 is offline
external usenet poster
 
Posts: 1
Default find and insert missing values

Here is a portion of my data set.
A B
244 2
243 2
241 2
240 3
239 1
238 1
235 4
233 5
232 5
226 3
225 3
224 3
223 2


How can I find the missing values in the serial list in Column A an
insert a row (and the missing value) where appropriate?

Thanks
Debbi

--
Message posted from http://www.ExcelForum.com