View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NRath NRath is offline
external usenet poster
 
Posts: 4
Default 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.