In this video I walk you through a VBA macro that combines associated records into a single record. The scenario is that we have a book club that records the reading activity of its members. Each read is recorded on a separate row: member's name in column A and book title in column B. [su_youtube url="https://youtu.be/CjnMzRwrSP4"…
Read MoreHow to Perform Fuzzy Match or Partial Match Lookups in Excel
This video demonstrates how to perform fuzzy or partial match lookups in Excel. There are two scenarios where you might need to use a partial match: When the lookup value is partial When the lookup table contains partial strings. The video covers both scenarios. In Office 365 we can use XLOOKUP and FILTER to perform…
Read MoreAdd Checkboxes to Excel Cells
This video demonstrates how to add checkboxes to Excel cells. A checkbox can be linked to a cell so that if it is ticked the cell receives the value TRUE and if unticked the cell receives the value FALSE. The TRUE and FALSE values can be used to apply conditional formatting or within logical tests.…
Read More