Hello,
In column A I have employee ID numbers.
In column B i have an event list.
I would like column C to distinguish when...
...the word "Create" is in column B...
...whilst the number beside it is less than 20 in column A...
...whilst EITHER of the following two incidents occur:
1) the next cell down in column A is also less than 20 (it can be the same number as the cell above)
OR
2) The next word down in column B is either "Work", "People" or "Team".
so in the following example,
2 Create [POSTIVE RESULT]
6 Apple
will give a positive outcome.
also:
2 Create [POSITIVE RESULT]
35 People
will give a positibe outcome because of the "people" word
however,
2 Create
35 Apple
will not give a result
Thank you
Bookmarks