Formula to find majority value with Excel/VBA

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.

Hi Pete_UK,

Thanks for your reply and help.

Forgot to mention there are only 2 values for Column D, either Returned or Hold.

Possible to simplify the formula into 1 single line? It'll be easier to maintain.

Thanks again.

Hi Pete_UK,

Thanks for your reply and help.

I've tested the formula and noticed some issues.

Maybe I need to highlight that the formula should check for the following case, see below:
If all raws in "Column D" of Student6 has a status indicated as "Returned", then the formula should return "Returned".
If all raws in "Column D" of Student6 has a status indicated as "Hold", then the formula should return "Hold".
However, if all raws in "Column D" of Student6 has a status as mixture of "Returned" and "Hold", then the formula should not return anything.

I've attached the updated sample for your reference.

Appreciate if could help to check.

Thanks.

Hi Pete,

Thanks so much, it's working as expected now.

Will close the thread when it's been finalized.

Have a nice day.