On Wed, 2006-01-25 at 11:07 -0800, Dennis Marks wrote: > I have created a perpetual calendar spreadsheet. There is a list of holidays > generated on a separate sheet. Within each cell of the calendar I search to > see if it is a holiday using > > =VLOOKUP(DATE(CalYear;CalMonth;C11);HolidayArray;2;0) > > This works fine. I display a blank if nothing is found. > > I would like a refinement as follows. If there are two holidays on the same > date I would like the second one to appear on a separate line. My problem is > that the table is not in sequence (it can't be since many holidays move from > year-to-year) and I can only search for the first match. I need a way to > have the second search begin after the location found for the first search. > > Any idea of how I can do this? It seems that I must dynamically change the > addresses in the formula based on the first search. Instead of using the > named HolidayArray I need to use aaa:bbb where aaa is a formula that will > generate the beginning start cell. Can I concatenate a formula within an > address? >
Have a look at how holidays are handled in the built-in macro Schedule. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
