Fridays Excel teaser

Just a little teaser to see who's awake.

You have an Excel spreadsheet with a range of cells that hold numerical values. Let's call the range DATA.

Using a formula, how can you tell if all the values in DATA are the same?

Just a little teaser to see who's awake.

 

You have an Excel spreadsheet with a range of cells that hold numerical values. Let's call the range DATA.

 

Using a formula, how can you tell if all the values in DATA are the same?

The standard deviation (STDEV function) of them will be zero.

Not wrong but not what I had in mind.

Not wrong but not what I had in mind.

Hmmm... OK here's my guess then...

if MAX(DATA1 : DATAn) = MIN(DATA1 : DATAn) then all values in DATA are equal.

Well done Mr Bloke! That's what I had in mind.

As DATA fully qualifies the range, the formula is much simpler:

IF MIN(DATA) = MAX(DATA) ........

I've not 'excelled' for about 20 years!

I've not 'excelled' for about 20 years!

I never did !! ???

And once again, but this time in English ?

A friend coined a phrase that pretty much sums it all up that is wrong with the modern working environment.

Excel twatery!

A friend coined a phrase that pretty much sums it all up that is wrong with the modern working environment.

 

Excel twatery!

I see. If you don't understand it, knock it.

It's not Excel that wears the two hats mate!!