You are reading a single comment by @graunch 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.
graunch
Google Sheets Day 1:
https://docs.google.com/spreadsheets/d/1joA1oMsoGaDCwX0u8CAK7IUuMeFqyfLEYzzIWzGB1d0/edit#gid=0
Google Sheets Day 2:
https://docs.google.com/spreadsheets/d/17LXRC-kEewCl3K1mvA1dzWJE8geZx9bK78o2fClZc0g/edit?ouid=113006542528071116740&usp=sheets_home&ths=true
There's probably a neater way to count characters in a string than deleting them and comparing the length
=len(B2)-len(SUBSTITUTE(B2,C2,""))but it's not obvious what.