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.