FanofExcel18
Board Regular
- Joined
- Jun 7, 2018
- Messages
- 65
Struggling, might be a Friday thing.
Trying to come up with a function that provides me an answer to this
Example cell 1: my environment 1.0
Example cell 2: my environment v1.0
Example cell 3: my environment 1
Example cell 4: my environment v1
Example cell 5: my environment version1
Example cell 6: my environment version 1
Need a formula that would say scan through a cell on each row to pull if it is one of those items. Answer can be anything a 1, true, Yes, anything.
Trying to come up with a function that provides me an answer to this
Example cell 1: my environment 1.0
Example cell 2: my environment v1.0
Example cell 3: my environment 1
Example cell 4: my environment v1
Example cell 5: my environment version1
Example cell 6: my environment version 1
Need a formula that would say scan through a cell on each row to pull if it is one of those items. Answer can be anything a 1, true, Yes, anything.