Excel/Expert Profile

Aidan Heritage

Available

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:

Recent Reviews from Users

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 .....
RJ02/21/17101010
Nico02/17/17101010Hi Aidan I did manage to figure .....
Peter02/16/17101010Thanks, traveling so i won't be able .....

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