Archive for the ‘Mail Bag’ Category

Referencing Data in Another Excel Workbook

Posted on February 26th, 2009 by Joseph Harris

Q: Joe, I have data in another workbook that I want to pull into my current workbook. How do I do this? Unsigned A: The easiest way to accomplish this is to open both workbooks. In the workbook you want to pull the data to, enter =, then go to the workbook you are pulling [...]

Find the Last Row with Data in Excel

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 [...]

Countif with Two Criteria

Posted on December 4th, 2008 by Joseph Harris

Q: I need to count the number of times an item occurs in column a if another thing also occurs in column b on the same row. I don’t think countif can be used for this can it? A: You are correct in that countif cannot be used for two arguments in that manner. The [...]

Removing Macros from a Workbook

Posted on November 12th, 2008 by Joseph Harris

Q: How do I remove all the macros from my workbook? I don’t want the “this workbook contains macros prompt” to appear anymore? Thanks, Rodge A: Rodge, There are three things you can do to get rid of the macros message when you open the workbook. Set the macro security setting to low. Move all [...]

Correlation Coefficient in Excel

Posted on November 6th, 2008 by Joseph Harris

Correlation coefficient use

Excel Function to Display Worksheet Name

Posted on October 29th, 2008 by Joseph Harris

Q: Hi, Can you tell me how to show the worksheet name in a cell in my workbook? Thanks, Ted A: Ted, You can do this with the built in functions in Excel. The CELL function with the filename argument, =cell(“filename”), will return the entire path of your workbook along with your current worksheet. We [...]