Pls help me

[Mahipal]

Sample A
Symptom not listed
Dim/Shadowed/Tinted Video
Error-No other symptom
Error-No other symptom
Assist installing OS
Specifications / Questions
Error-No other symptom
Performance Issue
Assist installing Application
Error-No other symptom
Error-No other symptom
Error-No other symptom
Error-BSOD/Dump/Serious Error
Error-Enter/Exit App
Performance Issue
Error-No other symptom
Not Required



Sample B
Assist installing Application 1
Assist installing OS 1
Dim/Shadowed/Tinted Video 1
Error-BSOD/Dump/Serious Error 1
Error-Enter/Exit App 1
Not Required 1
Performance Issue 2
Error-No other symptom 7
Specifications / Questions 1



Sample C
Error-No other symptom 7
Performance Issue 2
Assist installing Application 1


Sample A is the Raw Data
Sample B is the Filtered Data
Sample C is Final Report

If you see Sample A , the Error-No other symptom has
occurred 7 Times
Now I have a huge data where the data comes to 1030 Rows (
Roughly )
Sample B Gives the number 7 after I filter the data and
then Count it.
Copy the data and then paste it in other excel sheet as
Consolidated Data. ( sample C )

Please help me in making some macro where I can run this
macro and then Sample C report.

For any clarification you can mail me at
(e-mail address removed)

 

[Kieran]

Mahipal,

It seems that a macro may be overkill.

have you tried to summarise the date with a pivot table.

(Data menu, pivot table