Thread: Conditional Counting, then displaying data in new sheet.

Hi,

I have a spreadsheet which contains many values under different headings eg.

Job# Type Value1 Value2 Value3
111 A 1 0 1
112 B 1 1 1
113 A 0 . 0
114 C . 0 1
115 B 1 0 1
116 A 1 1 1
117 A 1 1 1


The above is stored and added to on a weekly basis on Sheet1. (Sometimes data in the "Value" Columns are blank, for this example I have put an "." as blanks don't show here too well.)

I need a macro that is able to sort out this info in a new sheet, for eg.

......... Column1
Row1 Count1 (where Type=A & Value1=1 ) (eg using data above =3)
Row2 Count2 (where Type=A & Value2=1 ) (eg using data above =2)
Row3 Count3 (where Type=A & Value2=1 & Value3=1) (eg using data above =2)

Row4 Value of Type (where Type=A & Value1=1) (eg using data above = 111, 116, 117) however i need these values placed on seperate rows directly underneith each other.


I hope that somebody is able to help me with this somwhat unusual request.

Your assistance is appreciated in advance.