You are reading a single comment by @Polygon 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.
@Polygon
Yeah it was the 3rd "\" that was tricky, as that varies in position, managed it with nested substitute. Textsplit would have been handy but I'm on office 2021.
Anyway, I have loads of entries for each client and project, each corresponding to a file, with a file size for each. Sorry if this is quite basic, but how can I make a chart showing the total filesize for each project? A nice-to-have would be subdivisions for filetype or project. As I understand it I might have to go via a pivot table?