You are reading a single comment by @aggi 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.
@aggi
I'm not sure if I'm interpreting the requirements correctly but I'd be tempted to add in another column and use an if statement so that if it is "n" it looks up the value for the previous year (vlookup works on hidden cells so your filter won't make a difference)