You are reading a single comment by @christianSpaceman and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@christianSpaceman
I don't have a machine in front of my to play with this this week, but arbitrary length concatenations are a problem in excel formulae.
Unless you know you'll never need to concatenate more than N cells, this alone might force you to vba your way around this ...
Something like this might help - I think you want a vlookup to return more than one value from agreed_leave that matches the date:
https://www.extendoffice.com/documents/excel/1979-excel-lookup-value-return-multiple-corresponding-values.html