-
Help - Selective look up needed
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules