View Single Post
  #9   Report Post  
Sam via OfficeKB.com
 
Posts: n/a
Default

Hi Domenic,

Yes, those are the results I'm looking for. However, I'm not sure why it is
not returning all the consecutive values on the 2nd Sheet for the first two
columns. I should see 9 values in columns "B" and "C"
that are consecutive.

Also as suggested, would appreciate it if you could eliminate the N/A
values by modyfying the formula.

Thanks
Sam

--
Message posted via http://www.officekb.com