Perhaps:
191(click to view image)
The formulae in red are just textual representations of the formulae in
the cells to the right. The upper one should be array-entered (ie.
commited with the key combination of Shft+Ctrl+Enter which will show the
curly braces).
Those formulae in copyable text:
=MIN(IF(B4:D40,B4:D4))
=INDEX(B1:D1,MATCH(B7,B4:D4,0))
but what happens if there are 2 or more vendors, all with the lowest
value - I think only the first will be shown.
+-------------------------------------------------------------------+
|Filename: 2009-07-24_192123.jpg |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=191|
+-------------------------------------------------------------------+
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile:
http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=119304