| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| how do I create a Date field format for mm/dd/yyyy (10 digits) | Excel Worksheet Functions | |||
| Limit the amount of digits displayed in a field in Excel or Access | Excel Discussion (Misc queries) | |||
| number changing digits on paste from web apx file field | Excel Discussion (Misc queries) | |||
Linear Mode
