Thread: Select data from list without duplicates on a certain criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Niju David Niju David is offline
external usenet poster
  
Posts: 7
Default Select data from list without duplicates on a certain criteria
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.


Reply With QuoteReply With Quote