Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the location of a group of cells
I have 50,000 rows of 12 values in each column. I am looking for low
outliers, so I use MIN across each row and get the lowest value in each group of 12 values. From there I calculate the mean, then the SD, and get a Z score for each row. My problem is that if cell d4 is the MIN of the 12 values in that row, I need to know what the values were in C4 and E4, because if C4 is approximately equal to E4, and the Z score is high, then D4 is an outlier. In a clinical setting though, it's important that the previous and subsequent values are approximately equal. Right now I do this manually. I find the MIN in the group of 12 data points and copy the three values into seperate rows so That I can apply formulas to the data. But I know that anytime I have to do that much manual minipulation of data, I'm doing something wrong. Any assistance would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding 1 formula result in a group of cells | New Users to Excel | |||
Finding a cell location | New Users to Excel | |||
Finding non zero value in a group of cells | Excel Worksheet Functions | |||
Finding the location of MAX value in column | Excel Discussion (Misc queries) | |||
Finding the latest date represented in a group of cells | Excel Discussion (Misc queries) |