Hi all, I am hoping someone has a good formula for me
I have data in 2 columns, labelled "value 1" and "value 2". Each row shows a range of data, however sometimes the maximum value of the two appears in the "value 1" column and sometimes in "value 2". Sometimes only one value is given (which may be either end of the expected range) therefore it appears in "value 1" and "value 2" is blank. It would usually be easy to determine the max and min, except that I want it to ignore outliers. I also can't use the "mode" function given that the missing data in the "value 2" column mean it is possible to end up with only the minimum value (for example) being the mode in both columns. I know that sounds a bit complicated so here is an example of data:
Value 1 Value 2
52 56
52 56
56 52
52
52
56 52
61 52
48
52 56
56
So I want it to show MIN=52 and MAX=56. I will have an unknown number of outliers. Is is possible to calculate more than one mode then take both as the min and max because that might actually work?
Thank you in advance for any suggestions
Lucy
Bookmarks