Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN and IF functions return no value if there is no date
Hello,
I am using this array formula to give me the smallest date if two ciretira are matched. It works really well, but for some reason if there is no date in the list it returns the 00-Jan-00 value. Is there a way that it does not return any values at all and the cell remains empty? =MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20," "))) Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN and IF functions return no value if there is no date
Try this (array entered):
=IF(SUM((H9:H20=B5)*(I9:I20=B9)),MIN(IF((H9:$H20=B 5)*(I9:I20=B9),Timesheet!G9:G20)),"") -- Biff Microsoft Excel MVP wrote in message ... Hello, I am using this array formula to give me the smallest date if two ciretira are matched. It works really well, but for some reason if there is no date in the list it returns the 00-Jan-00 value. Is there a way that it does not return any values at all and the cell remains empty? =MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20," "))) Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN and IF functions return no value if there is no date
On Apr 25, 11:46*am, "T. Valko" wrote:
Try this (array entered): =IF(SUM((H9:H20=B5)*(I9:I20=B9)),MIN(IF((H9:$H20=B 5)*(I9:I20=B9),Timesheet!*G9:G20)),"") -- Biff Microsoft Excel MVP wrote in message ... Hello, I am using this array formula to give me the smallest date if two ciretira are matched. It works really well, but for some reason if there is no date in the list it returns the 00-Jan-00 value. Is there a way that it does not return any values at all and the cell remains empty? =MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20," "))) Thanks!- Hide quoted text - - Show quoted text - Hi Biff, Thanks for this formula, does this work if my values in B5 and B9 are actually text? I have managed to make it work yet? Thanks again. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN and IF functions return no value if there is no date
On Apr 25, 12:02*pm, wrote:
On Apr 25, 11:46*am, "T. Valko" wrote: Try this (array entered): =IF(SUM((H9:H20=B5)*(I9:I20=B9)),MIN(IF((H9:$H20=B 5)*(I9:I20=B9),Timesheet!**G9:G20)),"") -- Biff Microsoft Excel MVP wrote in message ... Hello, I am using this array formula to give me the smallest date if two ciretira are matched. It works really well, but for some reason if there is no date in the list it returns the 00-Jan-00 value. Is there a way that it does not return any values at all and the cell remains empty? =MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20," "))) Thanks!- Hide quoted text - - Show quoted text - Hi Biff, Thanks for this formula, does this work if my values in B5 and B9 are actually text? I have managed to make it work yet? Thanks again.- Hide quoted text - - Show quoted text - Hi Biff, Ignore my question! I got it to work! Thanks for your help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN and IF functions return no value if there is no date
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP wrote in message ... On Apr 25, 12:02 pm, wrote: On Apr 25, 11:46 am, "T. Valko" wrote: Try this (array entered): =IF(SUM((H9:H20=B5)*(I9:I20=B9)),MIN(IF((H9:$H20=B 5)*(I9:I20=B9),Timesheet!**G9:G20)),"") -- Biff Microsoft Excel MVP wrote in message ... Hello, I am using this array formula to give me the smallest date if two ciretira are matched. It works really well, but for some reason if there is no date in the list it returns the 00-Jan-00 value. Is there a way that it does not return any values at all and the cell remains empty? =MIN(IF(H9:$H20=B5,IF(I9:I20=B9,Timesheet!G9:G20," "))) Thanks!- Hide quoted text - - Show quoted text - Hi Biff, Thanks for this formula, does this work if my values in B5 and B9 are actually text? I have managed to make it work yet? Thanks again.- Hide quoted text - - Show quoted text - Hi Biff, Ignore my question! I got it to work! Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Most functions do not work and return #Name? | Excel Worksheet Functions | |||
When save as another file, EDATE and XIRR functions return #N/A | Excel Worksheet Functions | |||
How to return value from functions in other sheets? | Excel Worksheet Functions | |||
All arithmetic functions return Zero as result | Setting up and Configuration of Excel | |||
using muliple functions to return one result | Excel Worksheet Functions |