I'm not even sure where to start with this one, so apologies if the title seems a little strange.
I have a report from work that lists all of the outstanding fees people, however, if they have more than one fee outstanding it lists on separate rows. So for example, it will appear like this;
I want to do a mail merge and send an email to everyone telling them how much is outstanding. Ideally I'd like to have one line per person with a total fee, rather than individual fees per month etc. My spreadsheet is over 1000 rows and some people have 5+ entries, some 1, some 2 etc. How can I total all of the fees based off the unique ID?
If I am barking up the wrong tree and need to do something else entirely, your help would also be appreciated!
Thanks in advance!
I have a report from work that lists all of the outstanding fees people, however, if they have more than one fee outstanding it lists on separate rows. So for example, it will appear like this;
Unique ID | First Name | Surname | Fee Type | Fee |
1234 | Dan | Smith | Membership Jan | £5 |
1234 | Dan | Smith | Membership Feb | £10 |
9874 | Aaron | Wright | Membership Jan | £5 |
I want to do a mail merge and send an email to everyone telling them how much is outstanding. Ideally I'd like to have one line per person with a total fee, rather than individual fees per month etc. My spreadsheet is over 1000 rows and some people have 5+ entries, some 1, some 2 etc. How can I total all of the fees based off the unique ID?
If I am barking up the wrong tree and need to do something else entirely, your help would also be appreciated!
Thanks in advance!