4, 2009 at 10:51 AM, Dave Bonallack <
> davebonall...@hotmail.com> wrote:
>
>> Huh?
>>
>> ------
>> Date: Thu, 24 Dec 2009 10:24:02 +0530
>>
>> Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric
>> valu
---
> Date: Thu, 24 Dec 2009 10:24:02 +0530
>
> Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric
> values
> From: rfhyd1...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> :) at least say thanks who help u out in problem
>
> On Thu, D
----
> Date: Wed, 23 Dec 2009 21:21:00 +0530
> Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric
> values
>
> From: nvino...@gmail.com
> To: excel-macros@googlegroups.com
>
> Thanks Dave This works awesome ..
>
> Vinod
>
> O
Huh?
Date: Thu, 24 Dec 2009 10:24:02 +0530
Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values
From: rfhyd1...@gmail.com
To: excel-macros@googlegroups.com
:) at least say thanks who help u out in problem
On Thu, Dec 24, 2009 at 5:53 AM, Dave Bonallack
wrote
:) at least say thanks who help u out in problem
On Thu, Dec 24, 2009 at 5:53 AM, Dave Bonallack
wrote:
> You're welcome.
>
> --
> Date: Wed, 23 Dec 2009 21:21:00 +0530
> Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric
>
You're welcome.
Date: Wed, 23 Dec 2009 21:21:00 +0530
Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values
From: nvino...@gmail.com
To: excel-macros@googlegroups.com
Thanks Dave This works awesome ..
Vinod
On Wed, Dec 23, 2009 at 12:40 PM, Dave Bona
Thanks Dave This works awesome ..
Vinod
On Wed, Dec 23, 2009 at 12:40 PM, Dave Bonallack
wrote:
> Hi Vinod,
> The attached shows how to create an instantly updated unique list from a
> list with duplicates, using a single line ov VBA. It doesn't matter what
> kind of data is in the orig
after getting unique value u can select a unique list.
insert-->name-->define(now name and range of unique values)
data-->validation-->allow-->list(name of list which u define in insert name
define)
your unique data list is ready now to work.
On Wed, Dec 23, 2009 at 1:48 PM, rf1234 rf1234 w
'''distinct value string or numerical
example 1
suppose in sheet1 range c1 u have a value
January February March April May June January February March April May
June January February March April January February March April May June
output should be as follows
Febru
Thanks
From: harmeet.hew...@gmail.com
Date: Wed, 23 Dec 2009 12:44:12 +0530
Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values
To: excel-macros@googlegroups.com
Nice solution Dave.. :)
Vinod,I hope that would help you.
Thanks & Regards,
Har
*Nice solution Dave.. :)*
*
*
*Vinod,*
*I hope that would help you.
*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Dec 23, 2009 at 12:40 PM, Dave Bonallack
wrote:
> Hi Vinod,
> The attached shows how to create an instantly updated unique list from
Hi Vinod,
The attached shows how to create an instantly updated unique list from a list
with duplicates, using a single line ov VBA. It doesn't matter what kind of
data is in the original list, or how long it is, or whether data is added
later. The second line of code alphabetizes the unique l
12 matches
Mail list logo
