You are here:
Excel/Questions Answered by Expert JP
| Subject | Date Asked |
| Incremental | 4/16/2008 |
| Q: I have a spreadsheet in which 25 consecutive rows refer to a single row (but separate colums) on ... A: The easiest solution is….. I assume that your formulas begin with and equal sign (although the same ... | |
| excel dates | 4/13/2008 |
| Q: i need the curent date on several workbooks at work,and doing it manualy it takes alot of time..so i ... A: There are 2 options that I am aware of: Opt1 – choose manual calculation function under ... | |
| excel formulas | 4/4/2008 |
| Q: Please explain the formula =trunc(h11/j11),4. What does this formula mean? I do understand that h11 ... A: To truncate, done using the Trunc function basically means to cut off a number at a given point or a ... | |
| vlookup on pivot table | 4/3/2008 |
| Q: I'm trying to do a vlookup on a pivot table but am having problems. The pivot table has three ... A: Pivot Tables report data in an outline format. I am not aware of a way to format the table so that ... | |
| saved excel worksheet in 2 different my document folders | 4/2/2008 |
| Q: I am using windows 2000 pro. Have a my documents folder on desktop and in admin and administrators ... A: The only way to sync the folders is to select all files from one folder and copy past to the ... | |
| Copying columns from one sheet to another columns in different sheet | 2/22/2008 |
| Q: My question is :- I have 2 sheets. Sheet1 and sheet2.I have 4 columns in sheet1 and 3 columns in ... A: I assume that the data in the Birth and DOB columns are unique. If so then add a 4th column to sht2 ... | |
| Tracking time | 2/21/2008 |
| Q: I need to track the time that the power has gone off from a property. Sometimes it has gone off for ... A: Current Time: Cell A1 =NOW() - Use Time and Date Format Cell B1 =N(A1) - Use number ... | |
| stock items sheet | 2/21/2008 |
| Q: I have created a list of stock items and the available quantity of each that we have in stock. This ... A: This could get complicated but the easiest solution without having to create inventory tracking sw ... | |
| Excel question | 2/20/2008 |
| Q: Good afternoon, I am trying to calculate percentages and here is my scenario, cell A1 has en ever ... A: If I am reading your question correctly, then use the below formulas. Just add the desired % to ... | |
| ranking | 2/20/2008 |
| Q: I have a list of people that were given a random number, they are not in sequence ie. (not 1,2,3,4) ... A: Please be more specific on what you are trying to do. I do not understand how you are ranking the ... | |
| unable to open file | 2/20/2008 |
| Q: when i try to open my file this error msg comes "Read Error.Data could not be read from file" plz ... A: I have never heard of this error before. Try: first: Select the file, right mouse click, open ... | |
| stock items sheet | 2/20/2008 |
| Q: I have created a list of stock items and the available quantity of each that we have in stock. This ... A: After an order is entered, what is your process to update the available in stock sheet? The ... | |
| Excel | 2/19/2008 |
| Q: Is it possible to have a timer in excel, so that when x amount off time has gone by, the cell ... A: 1 minute = ~ 0.0006944444 or, multiply by 120 for 2 hrs = 0.0833333327318542 ... | |
| MS Excel 2003 | 2/18/2008 |
| Q: Is is possible to multiply numbers from two cells and have the answer in one of those two cells? ... A: If you cannot find a formula to fit a process then you must change the process in order to obtain ... | |
| Anniversary of Hire Date | 2/15/2008 |
| Q: I would like to create an excel spreadsheet that shows (in blue) when an employee hits the following ... A: I apologize...I did not read your question correctly the first time. The below formula will ... | |
| compare and get common from 2 lists in excel sheet | 2/15/2008 |
| Q: i want to get common items from 2 columns in excel sheet e.g. 1 2 2 4 6 6 7 8 9 9 plz help me ... A: Like all excel problems there are always multiple ways to solve issues. Ease and practicality ... | |
| Circular reference/Object Variable | 2/14/2008 |
| Q: I have just finished creating an eight-worksheet Excel workbook with multi-sheet =Sum(IF arrays and ... A: Without seeing what your formulas are it is difficult for me to help. You probably need this data ... | |
| Excel Text Import | 2/14/2008 |
| Q: I have a 2007 spreadsheet which contains 4 sheets. The first sheet references cells in the 3 other ... A: I have to be honest with you...In general I do not use the text import function, so the guidance ... | |
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
JP
Top Expert on this page
Expertise
I am an expert on the advanced Excel functions (lookup, database, reference and logical); and I am extremely proficient with data mining and reporting. I am not a VBA or control box expert.
Experience
I have been using Excel throughout my career in accounting, finance and, most recently, treasury and I have provided support for sales managers (medical and pharmaceutical) on how to use Excel to consolidate and analyze raw sales data from various “home grown” systems.
Education/Credentials
MBA - Finance Concentration
BBA - Accounting
©2012 About.com, a part of The New York Times Company. All rights reserved.