I have some data, and I want to make a course wise revenue report.
It is believed that the repeat customers because of previous courses purchased.
I have manually prepared a report from the data and put the comments in each report how it is calculated. Can anyone help me to make a report through formulas.
It would be great if you use formulas instead of Macros
Best Regards
Ali
Hello Ali,
With a helper column where you for example count how many times the individual names is found in your range, the formula to get what you want is then simple. See attached file for some examples.
The example is simple, in other words I am not checking if same name exists twice for same course. In real life scenario I would not base on a criteria that is not unique.
Br,
Anders
Hello Anders
Thank you so much. With your response, I got the hint, and got the desired result by using Pivot.
Here is the final file.
Once again, thank you so much.
