This is a fantastic forum and thanks in advance for the answer to my questions.
1. I want to get a result a summary w/sheet to this scenario.
If E7=3,Project!A19:Q236,13 or IF e7=5,Project!A19:Q236,15 or E7=7,Project!A19:Q236,15
How do I get this to work.
2. I wish to delete the first or second digit plus the minus from this data (10-14 or 1-14) to give the result of 14
Once again thanks
Mike
1. I want to get a result a summary w/sheet to this scenario.
If E7=3,Project!A19:Q236,13 or IF e7=5,Project!A19:Q236,15 or E7=7,Project!A19:Q236,15
How do I get this to work.
2. I wish to delete the first or second digit plus the minus from this data (10-14 or 1-14) to give the result of 14
Once again thanks
Mike