We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Unique

sri_hari1986
sri_hari1986 asked
on
Medium Priority
343 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
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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
CERTIFIED EXPERT

Commented:
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.