Forum Discussion
Kwesi_Quartey
Feb 20, 2020Copper Contributor
Subtotals or Vlookups or Both.
Hi All
I would be grateful if someone could help me to find a solution
am working on a sheet, such as
| Period | Name | Narrative | GBP |
| 201902 | Jane Doe | Cakes | 1.00 |
| 201806 | Jane Doe | Cakes | 1.00 |
and I have applied a filter for the Narrative column "cakes".
So after this, I need to show the count total for the Period column eg "201902"
I'm trying to achieve something like this at the end.
| Period | Total |
| 201807 | 4 |
I don't want to be counting multiple 201806's and getting the total of them wrong.
Thanks
Kwesi
7 Replies
Hi Kwesi_Quartey , are you trying to list the unique count as per Narrative ? share the sample workbook with your desired output
- Kwesi_QuarteyCopper Contributor
Hi Kwesi_Quartey, still I'm not clear with the output value. I didn't get that, could you please rephrase it again