View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default lowest number in a row that is greater than zero

If A1:S1 contained the month headers, and you also want (I'm not sure?) to
extract the month header which corresponds to the minimum sales value in each
row,
you could place this in say, U2, then array-enter it with CSE (press
CTRL+SHIFT+ENTER to confirm the formula) as mentioned in my first response:
=INDEX($A$1:$S$1,MATCH(MIN(IF(A2:S20,A2:S2)),IF(A 2:S20,A2:S2),0))
Then copy U2 down

Note that in the event of any ties in the minimum sales value in each row,
the expression will return only the leftmost month header, ie the first
header from the left
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---