Adjacent Cell Value Theorem Help

F

FastOneBaz

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Macro to find the value of adjacent cell from a range of values 2
Generating an RGB color spectrum based on cell values (XL03) 10
Excel Help with dates 2
help with code and array calcs 2
Storing Multiple Selected Pivot Table Report Filter Values 2
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Combine two ranges with different numbers of rows and columns 2

Top