You are reading a single comment by @hugo7 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.
@hugo7
Just to answer the obvious question of why not = every duplication in Sheet 2 from Sheet 1.
If you're not filling Sheet 1, then Sheet 2 looks a bit shit full of 0's.
EDIT: Looks like you can remove 0 for zero values https://trumpexcel.com/hide-zero-values-excel/