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!
|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 .....|
|Chris||01/29/17||10||10||10||Thank you, Aidan Your suggestions are much .....|
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
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
Answers by Expert: