Jan 20 2022 10:58 AM
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..?
Jan 20 2022 11:38 AM
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 ?