PinnedAndreas HuebnerWorking efficiently with Google Spreadsheets — Returning multiple values from a vlookupYou are probably familiar with the vlookup function, returning a value from a specific column when a value in the same row matches a…Jan 24, 2023Jan 24, 2023
PinnedAndreas HuebnerWorking efficiently with Google Spreadsheets — Index-Match — The better vlookupI haven’t used the “classical” vlookup for years now as there is a much more straightforward to perform a vlookup — index in combination…Jan 17, 2023Jan 17, 2023
PinnedAndreas HuebnerWorking efficiently with Google Spreadsheets — Counting unique values in a datasetI often need to quickly determine the number of unique values in a dataset, often then to perform further analysis using this unique count…Jan 18, 2023Jan 18, 2023
PinnedAndreas HuebnerHow working fully remote increases both the quality of my life and my productivity at workOpinions expressed are solely my own and do not express the views or opinions of my employer.Jan 15, 2023Jan 15, 2023