| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula falling over in more than one cell
Hi, hope you can help me. I'm trying to import information from one worksheet into a calendar - if the date value fits, then info from cells on the same line should be imported to the calendar page. This formula =IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ", Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ") works brilliantly, but only as that one function, if I change the date to a previous or later one, I don't get a return value. The formula isn't coming up with an error, but there's obviously something going on that Excel doesn't like. Any ideas? -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula falling over in more than one cell
Are you sure that the other date actually exists within the data?
-- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "moviegrrl" wrote in message ... Hi, hope you can help me. I'm trying to import information from one worksheet into a calendar - if the date value fits, then info from cells on the same line should be imported to the calendar page. This formula =IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ", Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ") works brilliantly, but only as that one function, if I change the date to a previous or later one, I don't get a return value. The formula isn't coming up with an error, but there's obviously something going on that Excel doesn't like. Any ideas? -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula falling over in more than one cell
Absolutely! For each month I have a set of specific dates - they are all listed on the Sheet that I'm trying to work with, they are all in correct date formula and all I'm doing is copying the formula and changing the date but with no luck. Bob Phillips Wrote: Are you sure that the other date actually exists within the data? -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "moviegrrl" wrote in message ... Hi, hope you can help me. I'm trying to import information from one worksheet into a calendar - if the date value fits, then info from cells on the same line should be imported to the calendar page. This formula =IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ", Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ") works brilliantly, but only as that one function, if I change the date to a previous or later one, I don't get a return value. The formula isn't coming up with an error, but there's obviously something going on that Excel doesn't like. Any ideas? -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula falling over in more than one cell
Any chance that some of your dates may be text that looks like a date?
I'd one of the cells that looks like it should work (but doesn't) as a date. Then reenter that date. == Any chance your dates include time? moviegrrl wrote: Absolutely! For each month I have a set of specific dates - they are all listed on the Sheet that I'm trying to work with, they are all in correct date formula and all I'm doing is copying the formula and changing the date but with no luck. Bob Phillips Wrote: Are you sure that the other date actually exists within the data? -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "moviegrrl" wrote in message ... Hi, hope you can help me. I'm trying to import information from one worksheet into a calendar - if the date value fits, then info from cells on the same line should be imported to the calendar page. This formula =IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ", Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ") works brilliantly, but only as that one function, if I change the date to a previous or later one, I don't get a return value. The formula isn't coming up with an error, but there's obviously something going on that Excel doesn't like. Any ideas? -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula falling over in more than one cell
Nope, the dates are definately dates, and don't include time. What is particularly weird is that it is only the one date (30th May) that works, any other date doesn't. But they are all entered in the same fashion and the formula in each cell is identical but for the date change. Frustrating isn't the word for it! Dave Peterson Wrote: Any chance that some of your dates may be text that looks like a date? I'd one of the cells that looks like it should work (but doesn't) as a date. Then reenter that date. == Any chance your dates include time? moviegrrl wrote: Absolutely! For each month I have a set of specific dates - they are all listed on the Sheet that I'm trying to work with, they are all in correct date formula and all I'm doing is copying the formula and changing the date but with no luck. Bob Phillips Wrote: Are you sure that the other date actually exists within the data? -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "moviegrrl" wrote in message ... Hi, hope you can help me. I'm trying to import information from one worksheet into a calendar - if the date value fits, then info from cells on the same line should be imported to the calendar page. This formula =IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ", Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ") works brilliantly, but only as that one function, if I change the date to a previous or later one, I don't get a return value. The formula isn't coming up with an error, but there's obviously something going on that Excel doesn't like. Any ideas? -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 -- Dave Peterson -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula falling over in more than one cell
Send me your workbook.
-- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "moviegrrl" wrote in message ... Nope, the dates are definately dates, and don't include time. What is particularly weird is that it is only the one date (30th May) that works, any other date doesn't. But they are all entered in the same fashion and the formula in each cell is identical but for the date change. Frustrating isn't the word for it! Dave Peterson Wrote: Any chance that some of your dates may be text that looks like a date? I'd one of the cells that looks like it should work (but doesn't) as a date. Then reenter that date. == Any chance your dates include time? moviegrrl wrote: Absolutely! For each month I have a set of specific dates - they are all listed on the Sheet that I'm trying to work with, they are all in correct date formula and all I'm doing is copying the formula and changing the date but with no luck. Bob Phillips Wrote: Are you sure that the other date actually exists within the data? -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "moviegrrl" wrote in message ... Hi, hope you can help me. I'm trying to import information from one worksheet into a calendar - if the date value fits, then info from cells on the same line should be imported to the calendar page. This formula =IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ", Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ") works brilliantly, but only as that one function, if I change the date to a previous or later one, I don't get a return value. The formula isn't coming up with an error, but there's obviously something going on that Excel doesn't like. Any ideas? -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 -- Dave Peterson -- moviegrrl ------------------------------------------------------------------------ moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790 View this thread: http://www.excelforum.com/showthread...hreadid=545462 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
