Fool,

Use a column of formulas

=LEFT(A2,2)

and use that column as your row field.

HTH,
Bernie
MS Excel MVP


"The Fool on the Hill" wrote in message
...
I want to know the number of issues with a certain status, of which the first
two digits of that issue starts with two digits. I have tried pivot table,
but that does not seem to work. Let me give an example:


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:
Column X Column Y Column Z
(sort of issue) (Status) (Total)
---------------------------------------------
T1 Closed 1
T1 Open 1
T2 New 1
T2 Open 1
T3 Closed 1

Can you please help me