You are here:

Excel/Expert Profile

Tom Ogilvy

U.S.

Available

Expertise

Worked with the program for many years - provided assistance on MS Excel Newsgroups since 1997. Have received the Microsoft MVP award annually since 1999. I don't answer questions on using Excel in a browser Since I have no way to test this. Prefer not to answer charting questions. I consider myself to be particularly knowledgeable about using VBA internal to Excel but have no problems with formulas and pivot tables either.

Experience in the area

Have Used Excel for 15 - 20 years. Answered in excess of 70,000 Excel related questions in MS Excel newsgroups. Unless obvious, please specify whether you want a worksheet function or macro/VBA solution.

Education/Credentials

BS General Engineering (concentration in Industrial Engineering) MS Operations Research Systems Analysis

Average Ratings

Recent Reviews from Users

User	Date	K	C	T	P	Comments
Ryan	11/07/09	10	10	10	10	Thanks for the help!
Adnan	11/07/09	10	10	10	10	Dear Tom, it is working great. Actually .....
Michael	11/06/09	10	10	10	10	Tom, many thanks for the speedy response .....
Steven	11/05/09	10	10	10	10	Works great, many thanks this has been .....
Steve	11/05/09	10	10	10	10	Other than the stray "END IF" above .....

Recent Answers from Tom Ogilvy

2009-11-08 Hiding rows with blank value:

I assume your dropdown is done using the List option from data validation. If so, you can react to a selection by using the worksheet change event. Right click on the sheet tab and select view code

2009-11-07 Hiding rows with blank value:

Sian, Let's assume that column B can be used to determine which rows are blank - i.e. if a cell in column B is blank, then the row needs to be hidden. Assume that values in column B are constants and

2009-11-07 Calculations using Visible results of other Calculations:

IAN, Based on your stated sitation and needs, I would recommend making the stored value and the displayed value by altering your formula to use the round function Y5: =(C5/100)*G5 becomes

2009-11-07 vsual basic:

Nessie, I created a userform and with Textbox1 and a commandbutton. I then put this code in the commandbutton to illustrate Private Sub CommandButton1_Click() TextBox1.Value = "The dog is

2009-11-07 time calculation:

Malcom, E2: 8.55 E3: 11.2 E4: =SUBSTITUTE(TEXT(SUBSTITUTE(TEXT(E3,"#.00"),".",":")-SUBSTITUTE(TEXT(E2,"#.00"),".",":"),"h:mm"),":",".")*1 produces 2.25 for me. Basically, use substitute

Ask A Question

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

Encyclopedia

Browse Answers: