Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet with a list of desk numbers in col A, then across row 3 I have dates.
I want to be able to type a date into a cell and return the desk numbers which are free that day (an unoccupied desk is denoted by the letters "NA") Desk# Name Last Name Sun 01-Jan Mon 02-Jan 15 Billy Smith NA 3 Jane Jones BH NA 21 Bob Spoggs NA 48 Mary Christmas BH NA 33 Bendor Grosvenor BH BH For example, if I type in 1/1/2017 I would get 15 and 21 returned; if I Entered 2/1/2017 I'd get 3 and 48 returned. Any help appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Before I jump off my desk... | Excel Discussion (Misc queries) | |||
where do i find the 10 free sessions | New Users to Excel | |||
Where can I find a free widget to ... | Charts and Charting in Excel | |||
where can I find a free excel download to use | Setting up and Configuration of Excel | |||
Macro to find the next free line | Excel Programming |