Good Monday Morning!
Since most of the MrExcel readers read the page at work, I'll start with an introduction here. I was reading the local newspaper and they had an article about the trendy, new, easy-to-use Weblog technology. Basically, it is easy to create a daily posting to your web site, without having to go through the hassles of FTP, etc.
It sounded interesting. On Saturday, I signed up with Blogger, and am now typing this article into my browser. With a click of the button, it will be added to the MrExcel site. I already answer a few e-mails every day, it should be easy to copy and paste them into the Weblog and create a daily Q&A from the MrExcel mailbag.
Sunday was a slow mail day, so here are a couple questions from Friday:
Ricardo asked is there a way to get the date and time automatically by creating a formula?
This is an easy one - use =NOW() to get the current date and time. Use =TODAY() to get the current date.
Carol asks "I have a column of numbers that I want to add. But I want subtotals for each person who may have more than one number. Is there a way to add each individual person's numbers without selecting each group for each person and manually adding.
Yes, the feature is called Data - Subtotals. You will find the Subtotals command on the Data menu. Select your data, then choose Data - Subtotals. In the Subtotal dialog box, you will answer three questions:
At each change in: Name
Use function: Sum
Add Subtotal to: Amount
For more details and an image about Data Subtotals, read method #4 in Tip 035.
There you have it, weblog entry #3. The downside is that information here will be in a totally random LIFO sequence - one day it may be simple functions, the next day it may be VBA. Add this page to your favorites, check back a every couple of days and let's see if anything interesting develops from this new technology.
By Bill Jelen on 15-Oct-2001