Thread: Convert a Find/Loop to an Array macro
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default Convert a Find/Loop to an Array macro

If you have duplicates post here in which column these duplicates can
occure. If they are in Column A you have to use FindNext. If they are in
column C then must be created unique values first.


Regards
Claus B.


There could duplicates in both column A and C.

Say something like six ADR09DR's in column A while column C has only three. So there would be three blanks in column B for that item number.

Howard
Reply With QuoteReply With Quote