Ian has attended:
Excel Advanced course
Database calculations automated
I am looking to set up a database that can will automatically calculate some figures when a new data set is uploaded. At present, this is being done manually.
Every year a list of athletes is generated where they are assigned to one of 32 sports across two different levels (lets call then a or b).
I would like review these against the previous years intake to generate figures on:
a) the % on the b list which are new, i.e. they were not on the b list last year
b) the % on the b list that are still there from the previous year
c) the % on the b list that are no longer there as they have been promoted to the a list
c) the % from the previous year that are no longer there as they have been relegated / released from the b list
This needs to be done across a number of sports, and thus needs to allow me to separate out accordingly.
RE: Database calculations automated
Hello Ian,
Thank you for your question.
Could you please send me a sample sheet with some detail on it. This would make it easier to work out the formula and code.
This sample sheet would not have to contain all your data just a sample of layout and data type.
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
RE: Database calculations automated
Happy to send something through - can I email this to you? If so, is there anyway we could set up a call to talk through it?
RE: Database calculations automated
Hello Ian
You can send the sample through to mm@stl-training.co.uk unfortunately as we are training we can only work with posts during breaks.
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
