Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup best case based on varying input???? | Excel Worksheet Functions | |||
Find a value Using a lookup table multiple columns and rows | Excel Worksheet Functions | |||
Lookup value then return result from other column, varying row num | Excel Worksheet Functions | |||
lookup needed for names in varying order | Excel Worksheet Functions | |||
Summation of columns of varying heights? | Excel Discussion (Misc queries) |