Good afternoon everyone

I am a novice regarding excel formulas and I am looking for a formula to the following problem if possible

I have a spreadsheet with a list of members names in column B who scored a value in Column C and a different score in Column E

I need a formula, or formulas, that give me a cell with the names of each individual member named in column B scoring 100 in Colum C and then each individual named in column B scoring 100 in Column E going on the theory that there can be more than one member scoring 100.

I already have the formula for who scored the highest but also need to show all those individually scoring 100

For example

Column B Column C Column E Colum F

Members name Score 1 score 2 Total

A. Moore 97 100 197
B. Moore 86 76 162
C. Moore 100 98 198
D. Moore 78 89 167
E. Moore 96 100 196

F. Moore 0 78
G. Moore 99 100

Members scoring 100 A. Moore
C. Moore
E. Moore
G. Moore

Hope this makes sense

Regards
Dave