Hi, I would like to calculate Data Usage by each Date. Sample file attached. Regards, AM:)
A ashish mehra Active Member Sep 3, 2015 #1 Hi, I would like to calculate Data Usage by each Date. Sample file attached. Regards, AM Attachments Data Usage.xlsx 10.1 KB · Views: 3
Chihiro Excel Ninja Sep 3, 2015 #2 See attached. Used helper columns to convert strings to usable format and then used Pivot to summarize data. Attachments Data Usage_pivot.xlsx 20 KB · Views: 2
See attached. Used helper columns to convert strings to usable format and then used Pivot to summarize data.