Excel/Expert Profile

Tom Ogilvy

On Vacation
returns 02/28/2017

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.


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
RJ02/20/17101010Question related to a farming project. Thanks .....
Arvinder02/16/17101010Tom is simply the best. He had .....
Kiritawhita02/13/17101010Perfect, this helped me solve the answer .....
Alan02/08/17101010Thanks Tom they all do the job .....
Bill02/07/17101010Instant answer, even at night! Wow I .....

Recent Answers from Tom Ogilvy

2017-02-19 Microsoft Excel--permutation, summation and more:

RJ,    There is no built in support for doing what you ask.  There is a combin function which will provide the number of combinations:   =Combin(8,2) = 28       You can use this code to generate what you

2017-02-16 Nested vlookups in IFERROR(IF(SEARCH:

 then you would probably need the verbose formula and add code to remove the "CHD" in the formula (when it is there).         =IF(countif(B2,"*CHD*")=0,("192.168."&(VLOOKUP(B2,AnotherSheetSameWorkBook!$B$2:$P$237

2017-02-16 Nested vlookups in IFERROR(IF(SEARCH:

Arvinder,    Lets look at what you asked in your first post:     ("192.168."&(VLOOKUP(B2,AnotherSheetSameWorkBook!$B$2:$P$237,13,FALSE)) & "." & (VLOOKUP(B2,AnotherSheetSameWorkBook!$B$2:$P$237,12,FALSE)))

2017-02-15 Nested vlookups in IFERROR(IF(SEARCH:

Bobby,    Instead of using  =IFERROR(IF(SEARCH("*XYZ",B2),"XYZ"),"ABC")  to replace the reference to B2 in your formula, I would use       IF(ISNUMBER(SEARCH("XYZ",B2)),"XYZ","ABC")        Applied to your

2017-02-13 Returning Trues and Falses if a cell contains:

Kiritawhita,    As I understand the question, you want to see a True if all cells in the specified range contain a command and false if at least one cell in the specified range does not contain a comma


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


All Answers

Answers by Expert:

Ask Experts


©2017 About.com. All rights reserved.