View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meeru Meeru is offline
external usenet poster
 
Posts: 16
Default how to auto extract item# upon entering a date

i have the following data:-

Items # Date
ABC 2/4/09
DEF 4/5/09
AEG 2/4/09

I want to auto extract items# when you enter a date, but i do have a
duplicate date how do i auto extract when there is a duplicate date:-

Date Items
2/4/09 ABC
2/4/09 AEG
thanks for your help
meeru