@googlegroups.com
*Sent:* Wed, August 18, 2010 7:34:17 PM
*Subject:* RE: $$Excel-Macros$$ Unique id to name
Hi,
You can use COUNTIF, which will return 1 if the id has been used only once,
or greater than 1 if used multiple times.
Regards - Dave.
--
Date: Wed, 18 Aug 2010 15:54
Oops. Did I say COUNTIF? I meant SUMPRODUCT... And 0 (zero) means id associated
with only one name. Greater than zero means multiple associations.
Sorry.
Regards - Dave.
Date: Fri, 20 Aug 2010 14:14:58 +0530
Subject: Re: $$Excel-Macros$$ Unique id to name
From: aftab.ala...@gmail.com
, August 18, 2010 8:13:21 PM
Subject: Re: $$Excel-Macros$$ Unique id to name
Hi
I would suggest you to use pivot for this type of data analysis. You
can take the count of name in pivot which is what you want.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 7:34 am, Dave Bonallack davebonall
suggestion would be a great one.
--
*From:* Soni.Rajender soni.rajen...@gmail.com
*To:* MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
*Sent:* Wed, August 18, 2010 8:13:21 PM
*Subject:* Re: $$Excel-Macros$$ Unique id to name
Hi
I would suggest you to use
Subject: Re: $$Excel-Macros$$ Unique id to name
This should help.
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey Company
http://www.facebook.com/Harmeeet
On Thu, Aug 19, 2010 at 7:18 PM, None n8dine4ma...@yahoo.com wrote:
Unfortunately a pivot table won't work here as I need the formula
I have a file that has 2 columns. The first contains an alpha numeric id and
the
second contains the name. Is there a way to find out if the id is associated
to
more than one name? Thank you.
--
--
Hi,
You can use COUNTIF, which will return 1 if the id has been used only once, or
greater than 1 if used multiple times.
Regards - Dave.
Date: Wed, 18 Aug 2010 15:54:49 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Unique id to name
To: excel-macros@googlegroups.com
I
has been used only once,
or greater than 1 if used multiple times.
Regards - Dave.
Date: Wed, 18 Aug 2010 15:54:49 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Unique id to name
To: excel-macros@googlegroups.com
I have a file that has 2 columns. The first contains