I have a column 'A' that contains numeric and non-numeric data. I want to
count the number of numeric data in column 'A' when the adjacent cell in
column B is equal to a certain value. For example:
A B
12 Paul
13A Paul
3 Diane
5 Paul
In the example above the numeric values for Paul = 2.
How do i do that?!
Using Excel 2003.
Thank you in advance - Tendresse