Hi All
I have only just worked out how to set up calculated fields in a table but this one is beyond me..
I have 5 columns |T1|T2|T3|T4|GROUP|
T1 = SHA/BAR
T2 = FUE
T3 = COM
T4 = CAL
If value in the field is > 0 Then GROUP should display the text equivalents of the Field headers and if more than one field > 0 Then GROUP should display MIX
Any pointers appreciated
how about
=IF(COUNTA(A2:D2)>1,"MIX",INDEX(A$1:D$1,MATCH(MAX(A2:D2),A2:D2,0)))
I suspect much better ways to do the header lookup - but that was my first idea
see attached
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks