Databases – retrieving records

  • Link to files used in my video.
  • Excelisfun’s one of the several formula  based methods to retrieve records from a list based on a criteria – Video. It is much faster than the array formulas which can produce the same result.
  • Cameron Crest’s video on query function in google spreadsheets is a missing manual for on query functions. His blog lists the spreadsheet employed in the video.
  • Excelhero academy is up and running. Link to Daniel Ferry’s blog.

One thought on “Databases – retrieving records

Leave a comment