Problem with excel formula (Novice)

**Dave Smith** · 08-19-2023, 12:42 PM

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

**AliGW** · 08-19-2023, 12:49 PM

Welcome to the forum.

Are you really using Excel 2007?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.