Create a PivotTable (Data | PivotTable and Chart...)* and filter as
desired. Use the Publisher and Software Names as row fields and the
software name as the data field. To filter, click the drop down
heading cells above the publisher and software names.

(*) The name of the menu item has changed slightly with different
versions of XL

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have 15000 records into my Sheet1.
in column A, i have all publisher name.
in column B, i have all software name.

i have a sheet2 on which are :
column C : publisher name
column D : software name

I want to place in column E, the amount of couple Publisher+software name
for the same software name.

something like

Microsoft Excel2000
Microsoft Excel2000
Microsoft Excel2000
Microsoft Word2000
Microsoft Outlook2000
Microsoft Outlook2000

in E column, i should get result
3 for Microsoft Excel2000
1 for Microsoft Word2000
2 for Microsoft Outlook2000

I would like to do it like that:

1. based on sheet2 publisher name, sheet 1 (column A) refine a region/filter
2. based on sheet2 software name, sheet 1 (column B) refine a region/filter
3. count the number of record found and write it to sheet 2 in column E.

thanks for help,

Maileen