Hello everybody,
There are four values in excel i-e 2.9,3.1,3.4,8.2. How to find out that 8.2 is an unpredicted value. I in fact need an average of these numbers but the average is ruined if there is an unexpected value in the row. Please help me out as i have to do it for thousands of rows and manual way is so frustrating.