You are here:

Excel/Expert Profile

Tom Ogilvy

U.S.

Available

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

User	Date	K	C	P	Comments
Debbie Brown	02/10/12	10	10	10	Thank you so much for your quick .....
Jess	02/09/12	10	10	10	Thank you for your help Tom! After .....
Jayendran	02/09/12	10	10	10	Thanks!!!
Carry	02/07/12	10	10	10	Thank you again Tom for your very .....
Tony	02/06/12	10	10	10	Tom, 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

Encyclopedia

Browse Answers: