You are here:
Excel/Questions Answered by Expert Edward H. Mori
| Subject | Date Asked |
| How to get data from web in Excel | 5/12/2009 |
| Q: I would like to automate couple of my tasks using VBA/Excel. Let me explain the current process that ... A: It sounds like the log in screen is a form of security for the web page. There might be a VBA ... | |
| Pivot Table Dates | 3/19/2008 |
| Q: I have a list of individual names and dates on which the individuals where paid. I need to know the ... A: Here's the table I got Count of SSN Date ... | |
| excel questions | 3/17/2008 |
| Q: I have 2 questions to ask you if you have the time. 1. What function or formula can I use to convert ... A: 1. That would be a format. In the Format pull down menu select Format Cell. There are a variety of ... | |
| Multiple Selections from Pull down Menus | 3/14/2008 |
| Q: I have created a drop down menu using Validation Data and it only allows me to select one item. I ... A: Glad that worked. I have done that for some forms I use here. If it says Unfreeze panes Freeze is ... | |
| Multiple Selections from Pull down Menus | 3/14/2008 |
| Q: I have created a drop down menu using Validation Data and it only allows me to select one item. I ... A: OK Example You drop down is in A1. You select value A. In B1 the VLOOKUP would return the value ... | |
| Vacation time formula | 3/12/2008 |
| Q: I'm looking for a formula to calculate vacation time based on date of hire. The schedule is as ... A: The easiest way is in Column A have the start date then add the number of days to that to calc the ... | |
| Excel Sum If | 3/11/2008 |
| Q: I'm working trough a Excel problem that seems to have me puzzled. I have two sheets of data. I'm ... A: Yeah I hate it when this stuff happens! Once you get it set it should be OK on going. You are ... | |
| Excel Sum If | 3/11/2008 |
| Q: I'm working trough a Excel problem that seems to have me puzzled. I have two sheets of data. I'm ... A: If you are exporting your Access data now to Excel your formatting should remain stable. If it ... | |
| Excel Sum If | 3/10/2008 |
| Q: I'm working trough a Excel problem that seems to have me puzzled. I have two sheets of data. I'm ... A: Can you put all your data in one worksheet? If so, create a column to identify term'd employees. ... | |
| Link to a list in another Excel Workbook | 3/5/2008 |
| Q: I have a worksheet that i am trying to make access list data from another file(workbook)have you ... A: What you need to do is put the worksheet you are referencing in the same workbook. Then on ... | |
| Copy data from One Excel Book to Another | 1/2/2008 |
| Q: Here is my challenge: I have two Excel Books. Book 1 - Order Form Book 2 - Consolidated Orders In ... A: Question - Is this order form overwritten with each new order? Possible solution - In book 2, ... | |
| Grand Totals for Rows in a Pivot Table | 4/4/2007 |
| Q: I'm working with a pivot table that looks like this: Cat1 Cat2 Cat3 Cat4 Date 3 4 5 ... A: Never had that problem. Here is the way my options are set up Checked Grand totals for columns ... | |
| ranking, I think | 1/25/2007 |
| Q: My column has several number 5's, several number 6's, several number 7's and several number 8's. I ... A: OK let me break the formula down. A1:A5 A1 would be the beginning cell of your data & A5 would be ... | |
| Comparing Columns | 1/9/2007 |
| Q: Basically what your saying is, If I have two columns with data like: Column1 Column2 ... A: =VLOOKUP(B1,$A$1:$A$907,1,FALSE) B1 is the value you are looking up $a$1:$a$907 if where you are ... | |
| combat training | 9/11/2006 |
| Q: I want to transition one of my accounting staff to a financial analyst. As you know, most execl ... A: There probably is a web site like that, I just don't know of it. The best thing to do would not ... | |
| Merge two or more excel database sheets | 9/7/2006 |
| Q: I am hoping that you will be able to assist me with my problem. It has just come to light within ... A: It sounds like you want to combine all the data you have into one master copy, correct? If so, then ... | |
| applying excel to prepare exam results | 3/11/2005 |
| Q: i have been trying to prepare examination results using microsoft excel 2000 version.i put down the ... A: Try this for the grades. You will need to adjust the ranges to fit you scale. ... | |
| calculating turnaroundtime to exclude holidays | 2/11/2004 |
| Q: i have managed to make a worksheet that we use in my department for calculating turn-around-time's ... A: Think I got it. List all you holiday dates in one column. Then use this where column A is your ... | |
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
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Edward H. Mori
Top Expert on this page
Expertise
Expert with pivot tables, very good with many functions, excellent in report formatting. I don't do charts.
Experience
Heavy Excel user & SAS programmer since 1994. I don't do VBA code, but would like to learn.
©2009 About.com, a part of The New York Times Company. All rights reserved.