Dear JP,
The sample output would be like, when i select 17.10.08 in another sheet it
should show

AA-2
BB-1
CC-1
DD-1

If i select 18.10.08 then it should show

AA-3
CC-1

Hope this is clear

Thank you


"JP" wrote:

Can you show a sample of the output you expect?

--JP

On Oct 16, 5:08 am, Niju David
wrote:
Kindly Help!!!

In Sheet 1 I have the following data

Clmn A 1 2 3 4 5
16.10.08 AA BB CC BB AA
17.10.08 CC DD AA AA BB
18.10.08 BB AA CC AA AA

In Sheet 2 I have a drop down list of dates. When I choose a certain date I
want excel to display the items in that particular date (without duplicates)
and the number of times that item is present.