All the formulas I can find pertain to only checking one cell agains
another:
EXACT() - "Compares two text strings and returns TRUE if they are
exactly the same..."

Is there no formula to compare several strings? Seems silly.

2007 only has 5 new formulas? yikes.

Finny,

=IF(COUNTIF(A:A,A1)=COUNTA(A:A),"ALL are the same","NOT all are the same")

can be used to tell if all the entries in column A are all the same.

HTH,
Bernie
MS Excel MVP


"Finny388" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> All the formulas I can find pertain to only checking one cell agains
> another:
> EXACT() - "Compares two text strings and returns TRUE if they are
> exactly the same..."
>
> Is there no formula to compare several strings? Seems silly.
>
> 2007 only has 5 new formulas? yikes.
>

On Jul 11, 9:32 am, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:
> Finny,
>
> =IF(COUNTIF(A:A,A1)=COUNTA(A:A),"ALL are the same","NOT all are the same")
>
> can be used to tell if all the entries in column A are all the same.
>
> HTH,
> Bernie
> MS Excel MVP
>
> "Finny388" <finny...@yahoo.com> wrote in message
>
> news:(E-Mail Removed)...
>
> > All the formulas I can find pertain to only checking one cell agains
> > another:
> > EXACT() - "Compares two text strings and returns TRUE if they are
> > exactly the same..."
>
> > Is there no formula to compare several strings? Seems silly.
>
> > 2007 only has 5 new formulas? yikes.

thanks! nice work!