Assuming that the MIN value is in column M, use

=IF(MATCH($M2,$A2:$L2,0)=1,"None
left",INDEX($A2:$L2,MATCH($M2,$A2:$L2,0)-1))

and

=IF(MATCH($M2,$A2:$L2,0)=12,"None
right",INDEX($A2:$L2,MATCH($M2,$A2:$L2,0)+1))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"jimbo" wrote in message
ps.com...
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.