Advocateabdulkhadershaik
New Member
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 the 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..?
In the process of finding which consecutive 2 hours had the 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..?