In C13 enter:
=IF(MIN($C$12:$F$12)=C12,C5,"")
In C14 enter:
=IF(MAX($C$12:$F$12)=C12,C5,"")
Select both cells and copy across to ColF.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Biggles Flies Undone !" <
[email protected]>
wrote in message Sorry about the date in my previous message, now corrected, i think
I have 4 columns starting at C5 toF5 and at the bottom of each of the
columns, C12 to F12 ,are the summed totals of the numbers in the columns
Below these totals i have 2 more rows for which i need formulas.
1 row needs to look at the totals and whichever column has the lowest number
return the column text label.
So if it turned out that D12 had the lowest number, in D13 it would return
the text label from D5 which in this case is "Home Study" and the row below
would be looking for the maximum and return that columns text label
I'm sure this is easy for most of you, but as i am pretty new to this , its
giving me a hard time, so any help greatly appreciated.
Many TIA
