PDA

View Full Version : Help - Selective look up needed



gritstone
04-14-2016, 01:28 AM
I have a workbook with multiple sheets - one for each team member. On each sheet the team member has to rank their project's risks and, when the risk score is high they have to give an explanation of that risk. I need the cells with explanations in copying to the front, summary, sheet of the workbook. How do I leave out the cells which do not have an explanation? At the moment the summary sheet looks like:

DEPARTMENT NAME
N/A
N/A
EXPLANATION
EXPLANATION
N/A

How do I get Excel to ignore the 'N/A's and just list the 'EXPLANATION' ones please?

Thanks