Hi All,
Another Problem i have, I have the data such as below:
GRAPH DETAILS
------------------------------------------DATE
ERROR NAME:----05/09/2006-06/09/2006-07/09/2006-08/09/2006
Error One
Error Two
Error Three
Error Four
Error Five
DATA (Stored on another Worksheet)
ERROR NAME-----Date Occurred-----Times Occured on Date
Error One-----05/09/2006-----10
Error Two-----06/09/2006-----0
Error Three-----07/09/2006-----10
Error Four-----08/09/2006-----1
Error Five-----05/09/2006-----12
Error One-----06/09/2006------13
Error Two-----05/09/2006------4
Error Three-----05/09/2006------0
Error Four-----06/09/2006------0
Error Five-----08/09/2006-----2
Error One-----06/09/2006-----3
Error Two-----05/09/2006-----5
Error Three-----06/09/2006-----8
Error Four-----09/09/2006-----4
Error Five-----08/09/2006-----5
My problem is that i need to populate my GRAPH details with the number of times each error has occured in total for the same date.
For example in my GRPAH DETAILS the value below 05/09/2006 and to the right of Error One... would display a value of 10 as it has occured ten times in total in my DATA on the 05/09/2006.
And another Example would be that below 05/09/2006 and to the right of Error Two... would display a value of 9 because it occured 4 times in 05/09/2006 and again another 5 times on the 05/09/2006.
Any Formulas to help me peform this... i have a huge amount of data and cant seem to figure out a simple way to perform the calculations.
I know this is a big post, sorry!.
Cheers all.
Another Problem i have, I have the data such as below:
GRAPH DETAILS
------------------------------------------DATE
ERROR NAME:----05/09/2006-06/09/2006-07/09/2006-08/09/2006
Error One
Error Two
Error Three
Error Four
Error Five
DATA (Stored on another Worksheet)
ERROR NAME-----Date Occurred-----Times Occured on Date
Error One-----05/09/2006-----10
Error Two-----06/09/2006-----0
Error Three-----07/09/2006-----10
Error Four-----08/09/2006-----1
Error Five-----05/09/2006-----12
Error One-----06/09/2006------13
Error Two-----05/09/2006------4
Error Three-----05/09/2006------0
Error Four-----06/09/2006------0
Error Five-----08/09/2006-----2
Error One-----06/09/2006-----3
Error Two-----05/09/2006-----5
Error Three-----06/09/2006-----8
Error Four-----09/09/2006-----4
Error Five-----08/09/2006-----5
My problem is that i need to populate my GRAPH details with the number of times each error has occured in total for the same date.
For example in my GRPAH DETAILS the value below 05/09/2006 and to the right of Error One... would display a value of 10 as it has occured ten times in total in my DATA on the 05/09/2006.
And another Example would be that below 05/09/2006 and to the right of Error Two... would display a value of 9 because it occured 4 times in 05/09/2006 and again another 5 times on the 05/09/2006.
Any Formulas to help me peform this... i have a huge amount of data and cant seem to figure out a simple way to perform the calculations.
I know this is a big post, sorry!.
Cheers all.