Solved

Unique

Posted on 2004-03-25
3
317 Views
Last Modified: 2010-05-01
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
Comment
Question by:sri_hari1986
  • 2
3 Comments
 
LVL 48

Expert Comment

by:Mikal613
ID: 10683933
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
 
LVL 48

Expert Comment

by:Mikal613
ID: 10683942
0
 
LVL 8

Accepted Solution

by:
ampapa earned 500 total points
ID: 10684133
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question