Thread: Loop through a range of cells to find unique entries
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
zoot zoot is offline
external usenet poster
  
Posts: 11
Default Loop through a range of cells to find unique entries
Hello All,
I am trying to loop through a column of cells for all unique entries. I
know how to loop but i don't know how to specify the results of being unique
and adding them to a seperate column can anyone help?

Column A

Test
Test 1
Test 2
Test
Test 1

I want this to appear in column B

Column B
Test
Test 1
Test 2

Thanks everyone


Reply With QuoteReply With Quote