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.
Advertisements

One thought on “Databases – retrieving records

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s