You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
Could certainly be done with a pivot, but then you have to remember to refresh the pivot each time, or code something to do it for you...
-
pivot
This has literally changed my life. (along with discovering you can import data from a webpage).
I feel like I may need to take some sort of online xls. course as I'm clearly overusing formulas.
If anyone knows of a particularly good series on YouTube, etc. please let me know.
EDIT: fwiw I'm actually using LibreOffice Calc, which seems to be pretty similar.
Sam_w
hugo7
@Chalfie
Would a pivot have solved this?