Try This
=dcount(database,field,criteria)
database = all the data (everything)
field = the Product
criteria = the sales figures
but if you want as you say only need to see them in the list if they have a sale, check out the help on MS Excel related to database functions - DCOUNT
Miracles we do immediately ...
imposibilities take a little longer.