![]() |
sum column based on multiple criteria
Good evening,
I am trying to work with the following data: 1 User at top level 2. Login type is 1 of three, UI, Tool, Interface 3. User may login multiple times per day Need to capture all data from DB Columns are Session_ID Start_Time End_Time Login_Minute Login_Hours User_Name Login_Type Formula I am trying to create is By User_Name, Time for Login_Type per day and carry all data for the row to be used in the pivot table as one total per day instead of mulitiples. |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com