Searching

  • Thread starter Thread starter stamateandreiv
  • Start date Start date
S

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
 
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
 
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
Click to expand...

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
 
Back
Top