Cool stuff to try on #spreadsheets


Cool stuff to try on  #spreadsheets  

I shared this yesterday but this one has a pretty GIF :-)

#protips  

Originally shared by Alireza Yavari


Google Sets
Give it two examples, and Google's spreadsheet can make a list of almost anything. 

Create a new spreadsheet in Google Drive, type mazda in A1 and honda in A2 (the first column), highlight the two cells and then press Ctrl (or Option for Mac) while clicking and dragging the small blue box from the lower-right corner to select additional cells where to place the Google Sets results.

Yesterday TechCrunch  reported that if you make a spreadsheet in Google Drive (Google Docs, formerly), enter and highlight the names of two beers, and pull down on the corner of the spreadsheet cell while holding Option or Control, the app will automatically fill the following cells with the names of other beers. The information is pulled, seemingly, from nowhere. It doesn't just work for beer, car brands, colors, states, or websites, as reported, but just about any category you can think of. 

See more examples at http://goo.gl/rHrYN

Read more:
http://googlesystem.blogspot.ca/2012/11/google-sets-still-available.html

Comments

  1. I saw this, looks like Knowledge Graph is at work...

    ReplyDelete
  2. Oh my god, this actually works!
    It will even work with one, but the chances of getting the right results will depend on how unique it is.

    ReplyDelete
  3. So Microsoft Office has been around..... guess...... 15 years and they have not figured out how to create lists yet.

    ReplyDelete

Post a Comment