Hello,
I have a column/range (over 200,000) presumably of identical values.
1. I would like to write a formula that returns the value "FALSE" if there is at least one cell containing a different value than the rest of the cells.
2. I would like to write a formula that indicates how many values are different from the comparison parameter.
example below:

A1: 30
A2: 30
A3: 30
A4: 31
....
A151000: 30
A151001:30
A151002:28

Formula 1: FALSE for the range A1:A151002
Formula 2: 2 (the number of cells that contain a number that is not equal to "30")

Thank you very much


George