There are four groups, but for simplicity I will use three as it will give the same output
Now, below all this, I have this:
|The following groups are dragging the average down and needs attention:
Now, below "Group 2", which is cell N62 btw, I want the next below average group listed, which in this example would be "Group 3".
However, if "Group 1" was a problem as well, it would have been in N62, and "Group 2" would have been in N63 instead.
Basicly I want N63 to do the same as N62, but exclude whatever is in N62, so it will jump to the next group instead and list that, so I get a complete cell by cell list of what group is a problem...
This is because I have colors for each group to identify them more easily, so I'd want to keep that through the whole sheet.
This question generated 14 answers. To proceed to the answers, click here.
This thread is current as of October 05, 2014.
For more resources for Microsoft Excel