View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ekkeindoha ekkeindoha is offline
external usenet poster
 
Posts: 46
Default selection of name

Good day,

A B C D E
F
IOU TRY FOR

09sep 1 try
09jan 09sep 09sep 2 iou

What I need to do are as follows. When I get a list to show me the top 2
names,and I enter a date "Lets say 09sep", I need to have the name thats
number one in the top 2 list only if the date that I enter are showing under
the specific name. IOW if I enter 09sep it should give me "TRY" because 09sep
appears under the name "TRY" and "TRY" are number one in the list.If 05 sep
appears under "TRY" it should show 0.