RE: Same text in column as one

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "inta251 via OfficeKB.com" <u30987@uwe>
Date: Thu, 22 Feb 2007 18:13:15 GMT

Thanks for respond.
This formula creating Circular: A2

Joel wrote:

This is pretty easy!

Put in A2
=A11

Put in A3 then copy to the rest of column A (not A1 or A2)

=IF(ISNUMBER(MATCH(W3,A$2:A2,0)),"",W3)

this will search for duplicates already in column A from A2 to A2

When copied to A5
=IF(ISNUMBER(MATCH(W5,A$2:A4,0)),"",W5)
which will check from a2 to A5 for a duplicate

I have sheet1 by name trips, where in column W I’ve companies’ names.
Same companies’ names can be infinity.

[quoted text clipped - 33 lines]

Thanks in advance.
Sincerely, Igor (inta251)

--
Message posted via http://www.officekb.com

.

References:
- Same text in column as one
  - From: inta251 via OfficeKB.com

Prev by Date: Re: Can someone tell me what this formula means?
Next by Date: Re: Pivot Table Special Summary
Previous by thread: Re: Same text in column as one
Next by thread: calculating back 4 years
Index(es):
- Date
- Thread