apgmin
Board Regular
- Joined
- Mar 1, 2010
- Messages
- 151
- Office Version
- 2013
- Platform
- Windows
In the above I am filling through google forms the marks obtained for a specific sector out of 30. The idea is to give the student an idea as to which sector he is best suited for.
Now in the remarks column, I want the name of the sector to appear based on the maximum marks of the individual column. This I did with Max and if!!
However if there are 2 or more same results, I want the student to know that he is equally good for both or all three or all four sectors.
Please help me with the formulaThank you