Unique

Hi,

Can anybody tell me how to do this..

I have a excel sheet.I need to search a column and get the unique values of the column into an array..

After getting them into the array...i have to display the values of the array in msgbox and then i have to search inside the array if 192.168.1.1 is found or not..if it is found i have to remove it from the array...

Can anybody help me..

Regards
Hari
sri_hari1986Asked:
Who is Participating?
 
ampapaCommented:
Well you could do this 2 ways, pure coding or a hybrid.

Use the Advanced filter and you can copy your range of data to a new location with "unique" records selected and then use VBA to creat an array of those items.

or

try this link: http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_20800399.html?query=unique+array&searchType=topic

0
 
Mikal613Commented:
Well i would use ado to select the distinct values from the excel ss and then loop through the recordset to see if the ip is there
0
 
Mikal613Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.