Adjacent Cell Value Theorem Help
 

My problem is this:

I have 12 values, one for each month of the year.

With in a worksheet (IE no VBA) I need to estalish whether any
adjacent values are identical.

IE

J F M A M J J A S O N D
1 2 2 2 4 4 3 6 2 4 6 3

IN this example the answer is "Yes" there does exist a situation wher
3 adjacent values are identical.

Any clues please? It's tricky to find a function or combination o
functions that wou;d it

--
FastOneBa
-----------------------------------------------------------------------
FastOneBaz's Profile: http://www.excelforum.com/member.php...nfo&userid=973
View this thread: http://www.excelforum.com/showthread.php?threadid=26205

Adjacent Cell Value Theorem Help
 

=SUMPRODUCT(--(A1:J1=B1:K1),--(B1:K1=C1:L1))0

if your data is in A1 to L1

--
Regards,
Tom Ogilvy



"FastOneBaz" wrote in message
...

My problem is this:

I have 12 values, one for each month of the year.

With in a worksheet (IE no VBA) I need to estalish whether any 3
adjacent values are identical.

IE

J F M A M J J A S O N D
1 2 2 2 4 4 3 6 2 4 6 3

IN this example the answer is "Yes" there does exist a situation where
3 adjacent values are identical.

Any clues please? It's tricky to find a function or combination of
functions that wou;d it.


--
FastOneBaz
------------------------------------------------------------------------
FastOneBaz's Profile:
http://www.excelforum.com/member.php...fo&userid=9737
View this thread: http://www.excelforum.com/showthread...hreadid=262054