part of string
 

it's just that First Word Matches are considered duplicates. Could you
tell me, is the formula finding words left of the space between dundee
united. Also can this be entered as a conditional format to highlight
the cells.
Regards Robert

part of string
 

On 14 Nov 2005 23:13:53 -0800, wrote:

it's just that First Word Matches are considered duplicates. Could you
tell me, is the formula finding words left of the space between dundee
united.

Yes. That's what I mean by "First Word". It's the first sequence of
characters in the string that is terminated by a <space.

Also can this be entered as a conditional format to highlight
the cells.

Not directly. I don't think you can use array formulas in the Conditional
Format dialog box.

However, here are two, simpler, NON-Array formulas that can be used in both
instances.

To count the number of "First Word" matches:

=COUNTIF(Teams,IF(ISERROR(FIND(" ",A3)),A3,LEFT(A3,FIND(" ",A3)-1))&"*")

and copy/drag down.

To use in Condtional Formatting:

=COUNTIF(Teams,IF(ISERROR(FIND(" ",$A3)),$A3,LEFT($A3,FIND(" ",$A3)-1))&"*")1


--ron

part of string
 

Ron, Thankyou for your reply, these are ideal. Sorry didnt reply
sooner, been busy.
Regards Robert

part of string
 

On 17 Nov 2005 00:57:44 -0800, wrote:

Ron, Thankyou for your reply, these are ideal. Sorry didnt reply
sooner, been busy.
Regards Robert

No problem. It gave me time to think of a simpler, and more applicable, method
:-))

Glad it's working for you. Thanks for the feedback.


--ron