| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
Please help:
I have a table Basically I just need to return from list E1 When Dates are =D1 and <=F1 so 2/23 Tim 2/26 Tim.... 3/2 Tom.. 3/9 Mike A1=(TODAY) D1 E1 F1 23-Feb TIM 7-Jan 2-Mar TOM 14-Jan 9-Mar MIKE 21-Jan The formula will be in A2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF
If($A$1=Median($A$1,D2,F2),E2,"")
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF
On Saturday, February 24, 2018 at 5:07:48 AM UTC-6, Roger Govier wrote:
If($A$1=Median($A$1,D2,F2),E2,"") thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
