View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Count Unique Entries

Possibly this code will be helpful:

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"JL" wrote:

I have a sheet sorted on columns C & D. Starting with "C1:D1", I need code
to store each row to myArray that has data in columns C & D matching "C1:D1"
so I can process the rows, then find the next unique combinatioin of "C1:D1",
store all of those rows to an myArray for processing. As I mentioned the
sheet is already sorted so that may make things a little easier.

-JL-