Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding functions
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about functions | Excel Discussion (Misc queries) | |||
Question regarding Excel functions | Excel Worksheet Functions | |||
Add-In Functions Question | Excel Discussion (Misc queries) | |||
Question about Copy/Paste functions | Excel Discussion (Misc queries) | |||
if functions question | Excel Worksheet Functions |