I have a large table with names and numerical values. The names appear more than once and so I want to create a second table which summarises the first so that each name appears once with the total value for that name. I will want to apply a filter to order them alphabetically.
However, I also want to apply some fairly complex formulae to each row of the summary table, including a value which is different for each name so has to stay with that row when reordering them.
I tried a pivot table but I can't find a way to add columns with formulae that stay with the relevant row when reordering.
Any ideas?
However, I also want to apply some fairly complex formulae to each row of the summary table, including a value which is different for each name so has to stay with that row when reordering them.
I tried a pivot table but I can't find a way to add columns with formulae that stay with the relevant row when reordering.
Any ideas?
