Hiya,
I have data spread across 3 worksheets and I needed to pull across the council area and health board names to my main data sheet. It looks OK but I need someone to confirm if there are any issues or if there is a cleaner way of doing it. I have attached a sample spreadsheet for reference.
My friend provided me with a number of questions based on the full data sample, including links to the NHS's free data page, so I could try and get the answers. I mainly used pivot tables to do so. If someone has the time can they also see of the answers I have are correct? I've attached a word document with my answers for reference.
Is it best to use pivots for this or would formulas have been better?
I can email anyone the full spreadsheet I have just so you can check I have in fact answered them myself. My spreadsheet exceeds the attachment limit to add to the post hence why I am offering to email it.
Thanks a lot for any help I get.
Bookmarks