search text

[cybermilky]

I'm using Excel 2003. I have a file with columns as below:

(below diagram, the cells are separated with '|' and '-')

_|_A__|__B__|__C__|__D__|
1| 1-Jan | A,B,C | 1-Feb|C,D|
-----------------------------------------
2|2-Jan | B,D | 2-Feb|C,D,E|
-----------------------------------------
3| 3-Jan | A,C,D | 3-Feb|B,C,D|
-----------------------------------------
4|4-Jan | A,C | 4-Feb|C,D,E|
-----------------------------------------
5|5-Jan | C,D,E | 5-Feb|A,B,E|
-----------------------------------------
6|6-Jan | D,E | 6-Feb|C,E|

It's a whole year calender with options A to Z.

So, I want to find out which dates contains A, which dates contains B.
Which formula can I use?

 

[milesUK]

hi cybermilky,

This is cetainly possible but what do you really want to do? I presume that you don't actually want to find which dates contain A and/or B but which cells adjacent the dates contain A and/or B.

Conditional Formatting can FORMAT the cells that match your criteria.

Auto Filter or Advanced Filter could list the rows your interested in.

Formulas in adjacent cells could return values (e.g. TRUE/FALSE) to show cells that contain A AND B (or A OR B).

Or you could simply COUNT the relavant cells.