Waffle Bytes

Filters can be a wonderful way to control your Inbox.  Here is how to set them up. First, go to the gear icon in the upper-right hand corner of the window when you are in mail - Select Settings from the menu that pops-up - In the Settings window, select the tab Filters and Blocked Addresses - In the Filters and Blocked Addresses screen, click on Create a new filter - The next window will have lots of options to choose from in setting up your filter.  A reminder that Google's foundation is as a search engine - these items you select will actually perform a search of all your mail items that match the criteria (as few or as many as) you select - These items can search by: Who the email is from Who the email is to Keyword(s) in the email subject Keywords within the email (anywhere) Eliminating results with other keywords Emails with attachments Eliminating chat results Emails in a certain size range This gives total flexibility to getting exactly w...

Today I had the need to take a comma separated list from a form and create a column with the unique entries from that list.  Is it doable with Google Spreadsheets?  Most definitely! Here are the steps: 1. Use the SPLIT function to divide your entries to individual cells.  This will use as many columns as number of entries.  ( More info about SPLIT: the first parameter is the cell the data is coming from, the second parameter is what is used to divide the information.  Since I don't want the comma OR the space, my second parameter has both in the quotation marks, so: quote comma space quote .) =SPLIT(A1, ", " ) 2. Fill down as needed 3. Use the UNIQUE function to start creating your new list =UNIQUE(C1:C) 4. Add addition columns of information with curly brackets & semi-colons =UNIQUE({C1:C; D1:D; E1:E; F1:F; G1:G}) 5. Add the SORT function if you want the list alphabetized =SORT(UNIQUE({C1:C; D1:D; E1:E; F1:F; G1:G}) That...