|
|
August seems to be a very popular birthday month among my Excel friends. I won't mention any names here, because most of them are quite elderly, and the shock might upset them. ;-) Anyway, to all of them, and you, if you're celebrating this month -- happy birthday! The Birthday List If you're in charge of an employee list, and have to send birthday greetings, or hiring date anniversary congratulations, you can use Excel to help you keep track. In the worksheet shown below, there are fictitious employee names and birthdates. In a separate column you could use the MONTH function to check which birthdates are in the current month. This formula compares the month of the date in column C, to the month of today's date. If the months are the same, the result is TRUE. =MONTH(C2)=MONTH(TODAY()) Highlight Birthdays with Conditional Formatting Instead of adding another column with
Continue reading Highlight Current Month Birthdays in Excel
It's Shark Week on the Discovery Channel, so here are a couple of handy Excel functions you can use in case of a shark attack. Of course, if you stay home and watch television, you should be safe. The infamous land shark rarely attacks.
That Shark is Large
Sharks are pretty big, with the shark types in this list ranging from 2 to 5 metres.
You're being attacked by the second longest shark. How long is it? To find out, you can use the LARGE function. It takes two arguments -- the array or range of numbers, and the position in that range.
In this example, the range is B2:B12, and the position is 2.
=LARGE(B2:B12,2)
If you type the position number in cell D1, you can refer to that cell in the LARGE function.
=LARGE(B2:B12,D1)
Sharks Eat Off the Floor
Yes, some sharks eat fish, and other
Continue reading Excel Functions for Shark Week
Someone emailed me last week about problems with a range named Database. For reasons known only to the hamsters that operate my brain wheels, that reminded me of Excel's Data Form. It's a built-in data entry tool, that lists all the fields in a table, with entry boxes for some fields, and the formula results showing. You can scroll through the records, or find specific records, based on criteria. It's not a feature that I use too often, and when I looked for the Data Form command in the Excel 2007 Ribbon, it was missing! It looks like I'm not the only one who doesn't use the Excel Data Form too often. Access the Excel Data Form Even though the Data Form command is missing from the Excel 2007 Ribbon, you can still use it. A quick way to open the Data Form is the keyboard shortcut: Press Alt
Continue reading Mysteries of the Excel Data Form
|
|
Recent Comments