Ryan Jendoubi wrote: > This is set up pretty much how I'd like it to work (without the looong list > of input on the first sheet). > > I wasted half my day Googling this and trying various things, and the IRC > channel has declared it impossible without a macro. > > If you've thought of a winning formula I'll be hugely grateful!
I've had a look at the spreadsheet, and tried a few formulas. It seems that to do this with formulas is quite tricky and unfortunately I couldn't get it done. I tried a few different approaches and I think it is technically possible. However, I also think that it would take quite some time to write such a formula (if it is indeed possible). As was mentioned before, it can be done with macros. Would you consider using a macro instead? Regards Stephan -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
