Excel/Expert Profile


Ask A Question

Expertise

Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want. [Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]

Experience in the area

Extensive experience.

Education/Credentials

Master of Science (MS) degree Operations Research (ORSA)

Awards and Honors

Microsoft MVP in Excel.

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Debbie Brown02/10/12101010Thank you so much for your quick .....
Jess02/09/12101010Thank you for your help Tom! After .....
Jayendran02/09/12101010Thanks!!!
Carry02/07/12101010Thank you again Tom for your very .....
Tony02/06/12101010Tom, Thanks mate. It was doing my .....

Recent Answers from Tom Ogilvy

2012-02-10 If Statement:

Debbie Brown,    say the value is in C3      in another cell    =IF(AND(COUNTIF(C3,"*DLV*")>0,COUNTIF(C3,"*CNF*")>0),"Y","N")    That finds the substrings "DLV" and "CNF" in the specified cell and if they

2012-02-09 Comparing Two Columns Of Dates And Getting A Percentage:

 Nick Rupp    assume the dates are in A1:A26    then   =(countif(A1:A26,">=Jan 1, 2012")-Countif(A1:A26,">=Jan 31, 2012"))/26      format the cell to display as percentage    If you had   Jan 1, 2012

2012-02-08 Conditional formula to return a "Yes" or a "No":

Jess    =IF(COUNTIF(Sheet2!$A$1:$A$5,A2),"YES","NO")      if the value is not there countif returns a zero and in the if statement this zero value is treated as a false and the expression in the false

2012-02-08 Consolidating hours tracked over several projects:

Neal,    assume your project names can be in A2:A12 and there there will be no empty rows in that range of cells except after the last filled entry - in otherwords, you wont have    Project1  <empty cell>

2012-02-08 Userform Cell Fill:

Keegan,    If I can depend on column C to be able to tell me the next place to put the data    Private Sub Confirmbutton_Click()    'make sheet active'  ActiveSheet.Activate  'Determine Empty Row'  Dim

 

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

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2012 About.com, a part of The New York Times Company. All rights reserved.