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 ...
Feb 20, 2020
Hi Kwesi_Quartey , are you trying to list the unique count as per Narrative ? share the sample workbook with your desired output
- Kwesi_QuarteyFeb 20, 2020Copper Contributor
- Feb 20, 2020
Hi Kwesi_Quartey, still I'm not clear with the output value. I didn't get that, could you please rephrase it again
- Kwesi_QuarteyFeb 20, 2020Copper Contributor
I want to be able to count all the "201806" in the period column and to display the total amount of "201806" in the total column. after I have applied the filter from the other main table.
Period Total 201902 1 201806 1