Checking on first two digits of field
 

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 !

Checking on first two digits of field
 

Try this...

=COUNTIF(A1:A8,"=T1:*")

Rick


"The Fool on the Hill" wrote in
message ...
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 !

Checking on first two digits of field
 

Hi,

For T1 Codes..

=COUNTIF(A1:A5,"T1*")

Replace T1 with T2 or T3

Hope this helps,

Gav.

"The Fool on the Hill" wrote:

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 !

Checking on first two digits of field
 

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 ?





"Rick Rothstein (MVP - VB)" wrote:

Try this...

=COUNTIF(A1:A8,"=T1:*")

Rick


"The Fool on the Hill" wrote in
message ...
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 !

Checking on first two digits of field
 

On Feb 21, 11:25*am, The Fool on the Hill
wrote:
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 ?

"Rick Rothstein (MVP - VB)" wrote:



Try this...

=COUNTIF(A1:A8,"=T1:*")

Rick

"The Fool on the Hill" wrote in
...
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 !- Hide quoted text -

- Show quoted text -

Just run a pivot table on the new table.

Checking on first two digits of field
 

How does that work with a pivot table if you are only looking for the first
two digits of a field?

"HKaplan" wrote:

On Feb 21, 11:25 am, The Fool on the Hill
wrote:
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 ?

"Rick Rothstein (MVP - VB)" wrote:



Try this...

=COUNTIF(A1:A8,"=T1:*")

Rick

"The Fool on the Hill" wrote in
...
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 !- Hide quoted text -

- Show quoted text -

Just run a pivot table on the new table.