How to use Group function in Pivot Table in Excel Sheet

Occasional Visitor

I have three columns in an Excel Sheet -> Day of the week(Mon-Sun), 24 hr Timeline(0-24), number of entries.

In the process of finding which consecutive 2 hours had highest number of Entries the 'Group' function isn't showing all the results... I want like '0-2,1-3,2-4,3-5 etc' but the group function is displaying '0-2,3-5,6-8 etc'. 

Is there any other function besides 'Group' that solves my problem..?

1 Reply


To work groups shall not intersect. For example, how Excel will know in each group 2 shall be

0-2, 1-3 or 2-4 ?