Single value in entire array check

[TobyMac]

Hi!

I've got an array with a load of dates that might be the same. I need to check if they are all the same, and return a true/false or similar.

Is there a single cell command that will let me do this, or will i have to have to use nested IFs? (Editing the dimensions of the array beeing checked needs to be easy, so this isn't really an alternative).

VB is also an option, but the sheet needs to be editable by people who are not familiar with VB. It's a last case solution.

Thanks for all the help I've found so far on these message boards!

/TobyMac

 

[Mike Blackman]

Hi,

Are there always set number of dates or in the same format? Can you post some samples?

 

[mikerickson]

If your array is in A1:A10

=(COUNTIF(A1:A10,"="&A1) = COUNTA(A1:A10))

=(COUNTIF(A1:A10,"="&A1) = ROWS(A1:A10)*COLUMNS(A1:A10))

are a couple of options. With a namedRange

=(COUNTIF(NamedRange,"="&INDEX(NamedRange,1,1)) = COUNTA(NamedRange)), etc.

 

[TobyMac]

           A
1   30.06.2010
2   30.06.2010
3   30.06.2010
4   30.06.2010
5   30.06.2010
6   =ArrayEqualCheck(A1:A5)

In the above case, i would like a function to return the date that appears in all the above cells.

           A
1   30.06.2010
2   12.03.2010
3   30.06.2010
4   30.10.2009
5   30.06.2010
6   =ArrayEqualCheck(A1:A5)

In the above case, i would like a function to return a blank "".

Come to think of it, it shouldn't be a problem to implement a function that does exactly this. I might do just that.

What is the command to declarate a method to use in a sheet?

 

[TobyMac]

That solved it mikerickson, thanks a lot =)