View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Array instead of loop I'm sure

Hi Howard,

Am Sun, 29 Mar 2015 03:36:27 -0700 (PDT) schrieb L. Howard:

1858 index numbers listed in column A.


are the numbers in A1:A1858 unique?

In range C1 to EJ95 I need to find them and move them down 1 row and left 1 column. Each index number appears only once in this range.


Do all numbers from column A occur in C1:EJ950?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional