SOLVED

Counting text by month

Copper Contributor

Hi,

 

I need to count a text for example "Yes" and "No" that is repeated every day from Jan to June. what I need is find out  How many yeses and Nos in Jan Feb Mar,etc, I have attached the file

 

Thanks =)

1 Reply
best response confirmed by maalee100 (Copper Contributor)
Solution

@maalee100 

You may create PivotTable to show that

image.png

1 best response

Accepted Solutions
best response confirmed by maalee100 (Copper Contributor)
Solution

@maalee100 

You may create PivotTable to show that

image.png

View solution in original post