Hi,
I'm trying to make a pivot table based on below. However, the intervals doesn't sum up correct.
I have two columns; Days and Name. Then I made some intervals ranging from 1 - 30 days and 101 -200 days, filtering out how many times the days hit the interval (=IF(AND(A18>=31;A18<=100);"31 - 100 days";""))
I would like to display how many times the intervals occur per name.
Thanks in advance!
I'm trying to make a pivot table based on below. However, the intervals doesn't sum up correct.
I have two columns; Days and Name. Then I made some intervals ranging from 1 - 30 days and 101 -200 days, filtering out how many times the days hit the interval (=IF(AND(A18>=31;A18<=100);"31 - 100 days";""))
I would like to display how many times the intervals occur per name.
Thanks in advance!