Before you buy a gift card, check this list

-
Many stores have plans to close some or all locations after the Christmas holiday. Before you buy that gift card for little Johnny, better check out whether they'll still be around.

Comments

Post a Comment

Popular posts from this blog

Digital Signatures in PDF Do Not Print

-
Image
Trouble getting the digital signature in a PDF to print? The solution is actually simpler than you might think. With your document open in Adobe Acrobat Reader, click File >> Print. When the Print dialog box opens, look for the "Comments and Forms:" drop-down below the Properties button, located in the upper-right. Click the drop-down and select "Document and Markups." Now print. That's all there is to it.
Read more

Referencing the value of a cell, not its formula

-
Image
In Excel, I will use formulas quite frequently for my analysis. At times I want to reference the resulting value of the formula for comparison or to feed another formula. Unfortunately, if you are doing a comparison, Excel will try to compare the formula instead of the formulas results. Well, turns out there is an easy way to correct this. If you want your formula result to be a number, then use the VALUE function. If you want the formula result to be text, use the TEXT function. Here is the syntax for each: VALUE(text) TEXT(value,format_text) -- The format_text value can be any format from the Category box on the Number tab (in the Format Cells dialog box) except General. Here is an example of each: =VALUE(MID(A2,46,FIND("&",A2)-46)) -- this actually finds a number beginning with the 46th character of a string, and continues until it finds the ampersand character. By wrapping the formula with VALUE, I can now compare the number to other numbers in my looku
Read more

Simple notification script for Google Sheets

-
Image
UPDATED: May 19, 2017 I changed the script to be more user-friendly and the ability to include HTML in the email body. I also found that Google moved a few things in the menus, so I modified the instructions as appropriate. Google Sheets has a nice feature to notify yourself if something has changed, but every person who wants to be notified must add a notification for themselves. With a simple script, you can send notifications to people of your choosing. In this example, I've written a script to send an email when 1 or more rows are added. Get started. Go to the sheet Find a cell in the sheet that wont ever be over-written. Enter the value of the current total number of rows in the sheet. Note the cell for use in your script. I used G2. Go to Tools > Script editor... Write your script. Add this script in the script editor. Change as required to meet your needs. function check4NewLines() {       // /////////////// //////////////// ////////////////
Read more