• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

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
0
sri_hari1986
Asked:
sri_hari1986
  • 2
1 Solution
 
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
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now