L
linyinow
Hi, Could anyone help me with this problem? Here is th
table:
Apple Banana Orange Pear
15 45 20 335
85 65 44 77
11 787 88 936
I want to either to be able to 1)use a function to return the name o
the fruit containing the lowest level in each raw, so for first row i
would return "Apple", sedond row would return "Orange", etc. Can an
of you help me writing this function? 2) or if possible, i'd like t
highlight the cell in each row that contains the lowest value, so fo
first row, cell containing 15 will be highlighted. Can anybody help m
with that? Thanks very much
table:
Apple Banana Orange Pear
15 45 20 335
85 65 44 77
11 787 88 936
I want to either to be able to 1)use a function to return the name o
the fruit containing the lowest level in each raw, so for first row i
would return "Apple", sedond row would return "Orange", etc. Can an
of you help me writing this function? 2) or if possible, i'd like t
highlight the cell in each row that contains the lowest value, so fo
first row, cell containing 15 will be highlighted. Can anybody help m
with that? Thanks very much