D
davidbrowne17
ok, here we go.
i have a list of random names in colum A5:A50
and in collum B5:B50 scores
i need a formular that will, for a given NAME , will return the NUMBE
of times that a score of over 100 is achieved. in the tabl
G5:H5.....i'm guessing some kind of conditional LOOKUP & CONTI
functions are needed?
As attached sample sheet.
Any answers apreciated
Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54337
i have a list of random names in colum A5:A50
and in collum B5:B50 scores
i need a formular that will, for a given NAME , will return the NUMBE
of times that a score of over 100 is achieved. in the tabl
G5:H5.....i'm guessing some kind of conditional LOOKUP & CONTI
functions are needed?
As attached sample sheet.
Any answers apreciated
Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54337