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 xlst...@gmail.com wrote:
that's Great Haseeb.
thnx
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb
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)
G4,
try this
On Thu, Aug 18, 2011 at 6:32 PM, Sundarvelan N nsund...@gmail.com 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,
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
Hey Sundarvelan,
please try to use multiple range pivot.
On Wed, Aug 17, 2011 at 4:20 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Freinds,
Please help me to get the uniques values.
Thanks
N.Sundarvelan
9600160150
--
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/
--
that's Great Haseeb.
thnx
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)
G4, copy down.
=IFERROR(SMALL(B:D,COUNTIF(B:D,=G3)+1),)
HTH
Haseeb