robertgallafent
New Member
- Joined
- Apr 25, 2020
- Messages
- 18
- Office Version
- 2019
Good Morning all
I have written a formula to identitify blank cells in a range. Based on an ID in a seperate column i would like to tell my formula that these cellare intentionally left blank
Can i use some kind of look up formula to rule out the cells that i intentiionaly want to leave blank. So in the esample below ID 1 and 2 should be excluded from the formula, ID 3-5 should show as not blank and 6-7 should be blank
I hope that makes sense.
Best wishes all
Robert
I have written a formula to identitify blank cells in a range. Based on an ID in a seperate column i would like to tell my formula that these cellare intentionally left blank
Can i use some kind of look up formula to rule out the cells that i intentiionaly want to leave blank. So in the esample below ID 1 and 2 should be excluded from the formula, ID 3-5 should show as not blank and 6-7 should be blank
I hope that makes sense.
Best wishes all
Robert
ID | Example |
1 | Intentonally blank |
2 | Intentonally blank |
3 | Not Blank |
4 | Not blank |
5 | Not blank |
6 | Should show up so i can correct |
7 | Should show up so i can correct |