Re: Looking for Unique values, Excel
Re: Looking for Unique values, Excel
- Subject: Re: Looking for Unique values, Excel
- From: Thomas Maffucci <email@hidden>
- Date: Tue, 27 Jan 2009 14:08:46 -0500
- Thread-topic: Looking for Unique values, Excel
Hi Justin,
I believe this is the solution you were looking for:
set Orig_list to {1, 2, 3, 8, "3", "3", "3", 4, 5, 4, 5, 4, 6, 7, 2}
my Find_Non_duplicates(Orig_list)
on Find_Non_duplicates(Orig_list)
set uniq_list to {}
set dup_list to {}
repeat with an_item in Orig_list
if uniq_list does not contain an_item then
set end of uniq_list to (contents of an_item)
else
set end of dup_list to (contents of an_item)
end if
end repeat
log Orig_list
log uniq_list
log dup_list
set Fin_list to {}
repeat with an_item in uniq_list
if dup_list does not contain an_item then
set end of Fin_list to (contents of an_item)
end if
end repeat
return Fin_list
end Find_Non_duplicates
Set Orig_list to your column A range and set Fin_list to your unique range
column
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden