Hi,

I am trying to run a subTotal function on two columns of data.
Column 2 has our Techs names and Column 3 has status info.

First I subtotal the Techs and then the status. Everything works well
in Excel 2007.
However in Excel 2003, some of the Status subTotals show up above the
Tech count and some of them
are below the tech count. This of course makes my scripts produce
erroronius data.

Is this a problem with Excel 2003 or do I have to do some other magic
to make the results come out in a consistent mannner?

Notice Tech 5 and 6, the Service Restored Count shows up below Tech5
Count and Tech6 Count ;

Problem ID + Assignee Status D/T Reported + Severity
Tech1 None
None Count 0
PRB000007740911 Tech1 Service Restored 4/21/2007 4:45 5
Service Restored Count 1
Tech1 Count 3

Tech2 None
None Count 0
PRB000007747914 Tech2 On Hold 4/24/2007 15:58 4
On Hold Count 1
Tech2 Count 3

Tech3 None
Tech3 Count 1
None Count 0

Tech4 None
Tech4 Count 1
None Count 0

Tech5 None
None Count 0
PRB000007748287 Tech5 Service Restored 4/24/2007 17:43 3
Tech5 Count 3
Service Restored Count 1

Tech6 None
None Count 0
PRB000007751174 Tech6 Service Restored 4/25/2007 15:30 4
Tech6 Count 3
Service Restored Count 1