Excel/Expert Profile


Ask A Question

Aidan Heritage

Available

Follow me on:
      

Expertise

I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards. I'm based in the UK, so please allow for time differences when asking me questions from other parts of the world!

Experience in the area

My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

Education/Credentials

I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!


This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Udyadbhanu02/22/17101010Thank you very much Sir for solving .....
RJ02/21/17101010 
Nico02/17/17101010Hi Aidan I did manage to figure .....
Peter02/16/17101010Thanks, traveling so i won't be able .....
Chris01/29/17101010Thank you, Aidan Your suggestions are much .....

Recent Answers from Aidan Heritage

2017-02-19 Microsoft Excel--permutation, combinations:

To get the list of numbers, I would use a macro (though for 28 combinations you may just want to type them).  To work out the values is simple enough,and the most common would be found using the MODE worksheet

2017-02-15 VBA macro:

If I've understood the question correctly, this should do it    Sub AE()  'There is a question waiting for you in the category of "Excel".  ' Subject: VBA macro Question: On Sheet "P" column "BP" there

2017-02-11 IF nested formula challenge:

nested if's USUALLY sound to me like a lookup table instead - and I think in this instance that would work quite nicely.  Even with the picture I'm a bit stumped as the calculation you need - you mentioned

2017-01-27 not responding message:

OK - the calculation one is possibly best done in picture form, so this link http://www.howtogeek.com/162219/how-to-change-the-automatic-calculation-and-mult explains

2017-01-24 not responding message:

generally this would happen when excel is doing a high level of work- so a long workbook, perhaps with complicated formulas - windows sees the lack of response as a problem and warns you, but leaving excel

 

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


©2017 About.com. All rights reserved.