Hello All,
Have come completely unstuck on this one. Any help would be appreciated.
I am looking for a formula to look-up the name of an organisation – then count how many instances of an outcome they have data recorded against. So for instance, if I got the formula to work and did the look up (on the first table - attached) – the second table (also attached) would be the outcome. It sounds really straight forward, and I've tried to combine countif and v-lookup but just can’t make it work.
I have a huge spreadsheet of around 1500 rows and 500 columns.
Cheers,
Onye
Have come completely unstuck on this one. Any help would be appreciated.
I am looking for a formula to look-up the name of an organisation – then count how many instances of an outcome they have data recorded against. So for instance, if I got the formula to work and did the look up (on the first table - attached) – the second table (also attached) would be the outcome. It sounds really straight forward, and I've tried to combine countif and v-lookup but just can’t make it work.
I have a huge spreadsheet of around 1500 rows and 500 columns.
Cheers,
Onye