Hi Gurus,
Would need your kind expertise to help on this request.
Assuming I’ve the following sample data (see attached) and wishing if the expected output can be generated using some kind of excel/vba formulas.
Sample output data in Column E:
Student2 -> Found majority values in Column D -> Returned
Student3 -> Found majority values in Column D -> Hold
Student5 -> Found majority values in Column D -> Returned
If no majority values present when checked, nothing will be returned.
The sample data could be long and a lot, so it's best if the formula can be made flexible to cater for this situation.
Appreciate for any of your help and advice.
Thank you a lot in advance.
Bookmarks