ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   selection of name (https://www.excelbanter.com/excel-discussion-misc-queries/158494-selection-name.html)

ekkeindoha

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.




All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com