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!
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!
|Alan||03/06/17||10||10||10||Aidan thanks for all your help|
|Udyadbhanu||02/22/17||10||10||10||Thank you very much Sir for solving .....|
|Nico||02/17/17||10||10||10||Hi Aidan I did manage to figure .....|
|Peter||02/16/17||10||10||10||Thanks, traveling so i won't be able .....|
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
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
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 macroQuestion: On Sheet "P" column "BP" there
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
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
Answers by Expert: