try this
On Thu, Aug 18, 2011 at 6:32 PM, Sundarvelan N wrote:
> Hi Friends,
>
> I applied this formula it doesn't work for me.
>
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan <
> haseeb.avarak...@gmail.com> wrote:
>
>> Hi Sundarvelan,
>>
>> S
Hi Friends,
I applied this formula it doesn't work for me.
Thanks
N.Sundarvelan
9600160150
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hi Sundarvelan,
>
> Since you are dealing with valid numbers use SMALL function.
>
> in G3 enter,
>
> =MIN(B:D)
Hi Friends,
It doesn't work for me. I Need to get the unique values consolidating the
two columns. Please help me.
Thanks
N.Sundarvelan
9600160150
On Thu, Aug 18, 2011 at 12:04 AM, XLS S wrote:
> that's Great Haseeb.
>
> thnx
>
> On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan
> wrot
that's Great Haseeb.
thnx
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan
wrote:
> Hi Sundarvelan,
>
> Since you are dealing with valid numbers use SMALL function.
>
> in G3 enter,
>
> =MIN(B:D)
>
> G4, copy down.
>
> =IFERROR(SMALL(B:D,COUNTIF(B:D,"<="&G3)+1),"")
>
> HTH
> Haseeb
>
> For
Hi Sundarvelan,
Since you are dealing with valid numbers use SMALL function.
in G3 enter,
=MIN(B:D)
G4, copy down.
=IFERROR(SMALL(B:D,COUNTIF(B:D,"<="&G3)+1),"")
HTH
Haseeb
For free help visit;
http://www.excelfox.com/forum/
--
--
Hi Sundarvelan,
In 2007 or 2010 Excel ...Try Advanced filter and use option Unique
records...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Wed, Aug 17, 2011 at 4:20 PM, Sundarvelan N wrote:
> Hi Freinds,
>
> Please help me to get the uniques values.
> Thanks
> N.Sundarvelan
> 9600160150
>
> -
Hey Sundarvelan,
please try to use multiple range pivot.
On Wed, Aug 17, 2011 at 4:20 PM, Sundarvelan N wrote:
> Hi Freinds,
>
> Please help me to get the uniques values.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> -
Hi Freinds,
Please help me to get the uniques values.
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
