bladeuk
Board Regular
- Joined
- Apr 6, 2005
- Messages
- 178
Hi All,
I know this has to be possible but simply can't think straight today........
I have two columns with text in.
I want to count up the instances wher the text is "Other" in one column and "MANOR" in the other.
Other and MANOR may appear a number of times but not together as it were.
eg
Other MANOR
Other ROAD
Other MANOR
None MANOR
I would want the count to return 2
Hope this makes sense and thanks for any help
Dave
I know this has to be possible but simply can't think straight today........
I have two columns with text in.
I want to count up the instances wher the text is "Other" in one column and "MANOR" in the other.
Other and MANOR may appear a number of times but not together as it were.
eg
Other MANOR
Other ROAD
Other MANOR
None MANOR
I would want the count to return 2
Hope this makes sense and thanks for any help
Dave