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
To
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.
>
> --
> Dat
Otherwise your suggestion would be a great one.
>
>
>
>
From: Soni.Rajender
>To: MS EXCEL AND VBA MACROS
>Sent: Wed, August 18, 2010 8:13:21 PM
>Subject: Re: $$Excel-Macros$$ Unique id to name
>
>
>Hi
>
>I would suggest you to use p
estion would be a great one.
>
> --
> *From:* Soni.Rajender
> *To:* MS EXCEL AND VBA MACROS
> *Sent:* Wed, August 18, 2010 8:13:21 PM
> *Subject:* Re: $$Excel-Macros$$ Unique id to name
>
> Hi
>
> I would suggest you to use pivot for t
rn 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
>
&
Dave,
Can I trouble you for an example? I'm not sure how the COUNTIF would work
here. Thanks.
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Wed, August 18, 2010 7:34:17 PM
Subject: RE: $$Excel-Macros$$ Unique id to name
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.
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
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.
--
--
Some
