Re: Looking for Unique values, Excel
Re: Looking for Unique values, Excel
- Subject: Re: Looking for Unique values, Excel
- From: Peter Baxter <email@hidden>
- Date: Tue, 27 Jan 2009 05:57:34 +1100
Hi Justin,
set the_list to {1, 2, 3, 3, "3", "3", "3", 4, 5, 4, 5, 4, 1, 1, 2}
my remove_duplicates(the_list)
on remove_duplicates(the_list)
set return_list to {}
repeat with an_item in the_list
if return_list does not contain an_item then set end of return_list
to (contents of an_item)
end repeat
return return_list
end remove_duplicates
You would set the_list to your excel list
On 27/01/2009, at 1:52 AM, Justin Laden wrote:
Can anyone suggest a way to return, from a list of many values, only
the unique ones?
I will use this to go through a range (a column) in excel and create
another range consisting of only the unique values from the original
range.
Thanks!
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (applescript-
email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
Applescript syntax is like English spelling:
Roughly, though not thoroughly, thought through.
Peter Baxter
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden