Searching

[stamateandreiv]

Can someone help me with the following scenarion in VBA?

I have 2 columns: A & B with correlated info - as shown bellow.

column A columb B

Andrew ok
Andrew ok
Marta not ok
Andrew not ok
Marta ok


For Andrei I have a total of 3 records. I want for Andrei to show me
2ok & 1 not ok.
For Marta I have a total of 2 record. I want for Marta to show me 1ok
& 1 not ok.

Thanks,
Andrei

 

[Paul Robinson]

Hi
Use a Pivot Table. It is part of the Data menu. Select all your data
(I'll assume the headings are Name and Status) and click the Pivot
Table button. Now drag the Name field to the row area and the Status
field to the Data area.
You may need to play with it after that to get it looking like you
want.
regards
Paul

 

[Don Guillett]

Can someone help me with the following scenarion in VBA?

I have 2 columns: A & B with correlated info - as shown bellow.

column A        columb B

Andrew  ok
Andrew  ok
Marta   not ok
Andrew  not ok
Marta   ok

For Andrei I have a total of 3 records. I want for Andrei to show me
2ok & 1 not ok.
For Marta I have a total of 2 record. I want for Marta to show me 1ok
& 1 not ok.

Thanks,
Andrei

set up
name OK NOT OK
andrew> =sumproduct(($f$2:$f$22=$a2)*($b$2:$b$22=b$1)>sumproduct(($f
$2:$f$22=$a2)*($b$2:$b$22=c$1)
copy dn