Hello everybody,
I have values in columns and would like to use conditional formatting to mark anomalies in the data.
The following formula provides good results:
=ABS(A5-AVERAGE(A5:A56)>STDEV.P(A5:A56)*2
But I have to use INDIRECT for conditional formatting with a formula (true/false), so in a first step I did this:
=ABS(INDIRECT(ADDRESS(ROW(); COLUMN()))-AVERAGE(A5:A56)>STDEV.P(A5:A56)*2
But how can I get the values of the rows 5 to 56 INDIRECTly?
Thanks in advance!
eyestorm
Bookmarks