Task in Microsoft Excel (translation to interest) + instructions
1 .Change the whole numbers into interest rates:
The table contains a list of samples that are divided by categories (the name of the category is fat font and at the end the same name is blue, with the general call of the samples of this category).Also in the table there is a line "total all" in which there is information on the overall call-vo of all samples in this column.What you need: Translate all of these values into interests while retaining dynamic data change/
That is, the normal numbers within the category and the blue sum number within the category should show a percentage of "Total all" which is 100%.Well, changing the usual numbers, for example, somewhere 8 changed by 7, or adding some new number, would affect the overall picture.2ndReturning the table:
Change the order in the table, now starts with 11 and 20 at the end, and it should be the opposite, it should start with that column that 20 and so on, i.e. develop the opposite order.ThreeDescription of the formula and procedure:
Give me a short instructions, with screens and on the points, how you made point 1, that is, what formula is used, etc. so that in the future I can do it myself.The instructions in the screen record + formula format are also suitable.Submit the amount to the payment together with the response to the task (payment through the seafood)
Applications 1
Client's review of cooperation with Maksim G.
Task in Microsoft Excel (translation to interest) + instructionsHe performed the task quickly and qualitatively, quickly answered but all the questions on the course of the task, and provided a developed plan on the work done, I strongly recommend for cooperation.
Freelancer's review of cooperation with Stanislav Shevchuk
Task in Microsoft Excel (translation to interest) + instructionsThe task is placed as clear as possible, adequate requirements to the project, always in contact (problem with clarifications and explanations did not arise), it was pleasant to cooperate.
-
4467 102 0 Good day . I will be glad to help. I do everything quickly and efficiently!
-
421 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
812 15 0 Normal numbers within categories cannot be displayed in percentages of the total amount as they are entered by the user. You can display the end numbers in percentages, plus add additional columns to display the percentages of ordinary numbers.
On the second point I can write a macro that will change the locations of the column.
Go to turn.
-
143 2 0 Good day . I can do this task, know how to record the process on the video and call off in the zoma. We can discuss the price.
-
543 19 2 Goodbye, the task is clear. I do it quickly and reliably (My feedback is about it). I’m waiting for the feedback.
-
412 7 0 Good day . I have considerable experience working with Excel (the daily use of the last 10 years). The task is clear, I can do the formulas. I will make according to TZ + description what and how I did. Please call me, I will be happy to cooperate.
-
245 5 0 I need clarification on the possible implementation, I can do, there are a few options.
-
5911 345 0 I can perform formulas or macros with explanations what and how after discussion, until the task is uncomprehensible to the end.