Okay, so, I’m looking to put a formula into excel which does the following:
I want the data from column ‘H’ and column ‘I’ (shown on image 1) to collect and show up in a table on a separate worksheet (image 2) automatically, without me having to input the data myself. However, I have a feeling this will be complicated as each cell in the table will need different circumstances in order to count the instance.
(apologies, wasn't sure how to inbed the images in this post)
Image 1: http://img.photobucket.com/albums/v38/Kimaria/data1.jpg
Image 2: http://img.photobucket.com/albums/v38/Kimaria/data2.jpg
Example:
If counselling shows up alongside the postcode AB10, count as 1 within the cell: B2. Etc…etc…
The purpose of this is to show what services are being commissioned under a certain postcode.
Is this possible to do via the DCOUNTA function or by using a Pivot Table? (Neither of which I have any experience with, unfortunately). If anyone would be able to point me in the right direction or what formula I need to do this, that would be great!
Thanks in advance for your help and apologies if my explanation was poor. If you need more information, I’d be happy to provide it.
Bookmarks