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 [...]
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 [...]
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 [...]
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 [...]
Posted on November 6th, 2008 by Joseph Harris
Correlation coefficient use
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 [...]
