Skip to Content
0
Former Member
May 10, 2008 at 04:17 PM

Sum two items of data if same name.....possible structure?

26 Views

Post Author: Stuart

CA Forum: Formula

I want to create a report that can list the top 10 of a list of names and then I want to work out the total percentage in another column.

The problem I have is that my data could have the same name twice and this means that my percentages are different. These two duplicate names should be combined allowing for the total percentage to be correct.

I hope you can follow what I mean and that you can help me create this report.

Kind Regards,

Stuart