Checking on first two digits of field

  • Thread starter Thread starter The Fool on the Hill
  • Start date Start date
T

The Fool on the Hill

Dear All,

I have a list of issues. All issues are indicated by a code a : and the
issueremark.

Now I want to know how many issues are registered with a special code:
T2: CC-009 (FI-item list) runs over 5 hours
T2: CC-002 (Hash tables): bad performance of ZEXTR_KEYS_HASH1
T1: Issue on FAD_Counting_Control_V10.doc
T1: Berekening HASHTOTAL CC002 - berekening meterstanden klopt niet
T3: Incorrect text in outcome AL11 and ZEXTR_ZEXTR for CC016

I want some kind of formula that gives me the number of issues starting with
T1 (=2), T2 (=2) and T3 (=1).

Something like:
Countif(A1:A5), where first two digits = T1

Can you help me, please?

Thank you !
 
Thanks Gav and Rick,

Exactly what I am looking for !!!

Now I have a new column with status in B.
Column A Column B
------------------------------------------------------
T2: CC-009 Open
T2: CC-002 New
T1: Issue on FAD Closed
T1: Berekening HASHTOTAL Open
T3: Incorrect text Closed

Now I am looking for a formula which gives me the following result:
T1 Closed 1
T1 Open 1
T2 New 1
T2 Open 1
T3 Closed 1

Can you please help me again ?
 
Thanks Gav and Rick,  

Exactly what I am looking for !!!

Now I have a new column with status in B.
Column A                                 Column B
------------------------------------------------------
T2: CC-009                               Open
T2: CC-002                               New
T1: Issue on FAD                       Closed
T1: Berekening HASHTOTAL       Open
T3: Incorrect text                       Closed

Now I am looking for a formula which gives me the following result:
T1 Closed 1
T1 Open   1
T2 New    1
T2 Open   1
T3 Closed 1

Can you please help me again ?

:




- Show quoted text -
Click to expand...

Just run a pivot table on the new table.
 
How does that work with a pivot table if you are only looking for the first
two digits of a field?
 
Back
Top