October 11, 2012
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
December 7, 2016
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.