Posted on February 16th, 2009 by Joseph Harris
Reader Writes:
Joseph,
I have a spreadsheet set up where I enter all of my companies “packages shipped” data. I would like to know the value of the last row that I inputted. So, if column A contains packages shipped on each row, I want to know the last number entered in column A.
Thanks,
Carl
…………………………………………
Carl,
You can find the last [...]
Posted on February 9th, 2009 by Joseph Harris
Excel Solver is back in Excel 2008…
Posted on February 9th, 2009 by Joseph Harris
The standard vlookup function allows for one condition to be looked up. For example, if I have the data in rows 1 through 7 below, and I want to determine the favorite color of Dan, who was born in Jan and is 16 years old, the standard vlookup function will not work.
The standard vlookup function [...]
Posted on December 9th, 2008 by Joseph Harris
Today a colleague told me they were going crazy because they kept accidentally clicking on emails in an email list they maintained in Excel. I said, why don’t you turn off the hyperlinks then you will not have to worry about it. My colleagues face went blank….”You can do that?”.
Steps to disable auto hyperlinks (pre [...]
Posted on December 2nd, 2008 by Joseph Harris
There are times when it is useful to remove all formulas from a worksheet. It may simplify a sort or perhaps you do not want to show the world your method of calculation. The quickest and easiest method of doing this is using paste special.
Select the cells or entire worksheet you would like to remove [...]
Posted on November 20th, 2008 by Joseph Harris
To quickly ad the $ symbol around your cell references simply select the cell references in the formula bar and press f4. For example, if you have =A1 in the formula bar and you highlight and then press f4, the result will be =$A$1.
A quick way to create an absolute cell reference.
Joseph Harris
ExcelYogi.com
Analyst Resources
Bookmark It
