C
CasperGemini
Hello. I have a (hopefully) basic question on how to create a specific
function in Excel. Here is a rundown of the spreadsheet I'm working with:
It's a quality score tracker, so in column A there is a list of names.
Column B is where I want the function to go. Columns C through R contain the
data. Row 1 is all of the dates in November. In the cells that cross
between the names and the dates, they are either blank (meaning no quality
scores were entered for that employee for that date) or they contain a number
between 0 and 5. What I want column B to do is tell me when there are 3
consecutive numbers that are greater than three. They can have blanks
between them, but nothing at 2.75 or lower. My questions: 1) Is this
possible? 2) If so, what function do I use and how do I set it up? Thanks in
advance for the assitance.
function in Excel. Here is a rundown of the spreadsheet I'm working with:
It's a quality score tracker, so in column A there is a list of names.
Column B is where I want the function to go. Columns C through R contain the
data. Row 1 is all of the dates in November. In the cells that cross
between the names and the dates, they are either blank (meaning no quality
scores were entered for that employee for that date) or they contain a number
between 0 and 5. What I want column B to do is tell me when there are 3
consecutive numbers that are greater than three. They can have blanks
between them, but nothing at 2.75 or lower. My questions: 1) Is this
possible? 2) If so, what function do I use and how do I set it up? Thanks in
advance for the assitance.