Excel/Expert Profile

Ask A Question

Aidan Heritage


Follow me on:


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.


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
Alan03/06/17101010Aidan thanks for all your help
Udyadbhanu02/22/17101010Thank you very much Sir for solving .....
Nico02/17/17101010Hi Aidan I did manage to figure .....
Peter02/16/17101010Thanks, traveling so i won't be able .....

Recent Answers from Aidan Heritage

2017-03-20 Import data from Excel into Word Form:

you may well be able to do this with a mail merge - see http://software-solutions-online.com/word-next-record-if-rule-mail-merge/.  Otherwise, yes you can use VBA to achieve it - which may be easier to

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


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.