Lookup columns (varying qty), then find MIN
I need to find the min value in each row for all columns with a heading of a
specific format (TEMP 1, TEMP 2, TEMP 3, ...). It can't include other
formats like ATEMP 1, ATEMP 2, ZTEMP 1, etc. The qty of TEMP 1, TEMP 2 will
vary up to say TEMP 20, so I need to look for all that have
TEMP[space]NUMBER. The return would be in some column on the right side.
Below was created manually as an example.
Time TEMP 1 TEMP 2 TEMP 3 ATEMP 1 ATEMP 2 Min Temp
9:00:00 32.4 40.8 32.2 29.60 29.62 32.2
9:03:00 32.5 40.6 32.3 29.66 29.69 32.3
9:06:00 32.1 40.5 32.7 29.67 29.74 32.1
9:09:00 32.9 31.1 32.2 29.64 29.68 31.1
I've tried a couple things, but no luck.
Thanks in advance.
|