Counting a Running Column
Hi
I have kind of data as follows. I want to create a graph of the total number of login - logout vs. time elapse. That is I want to create another two columns. One to count the number of logins and another to count the number of logouts. I only have the data in the first column. What is the function to create the second column, No.of Logins? No.of Logins No.of Logout No.ActiveUsers Login 1 0 1 Login 2 0 2 Logout 3 1 2 Logout 3 2 1 Login 4 2 2 Logout 4 3 1 Login 5 3 2 .... Thanks, Jirong |
Hi!
I have to question your logic on calculating the number of active users. Your first 3 entries a login login logout Your number of active users is: 1 2 2 Seems to me that it should be: 1 2 1 And then follow that logic. Why would it NOT follow that logic? How can you have 2 logins and 1 logout and still have 2 active users? Biff -----Original Message----- Hi I have kind of data as follows. I want to create a graph of the total number of login - logout vs. time elapse. That is I want to create another two columns. One to count the number of logins and another to count the number of logouts. I only have the data in the first column. What is the function to create the second column, No.of Logins? No.of Logins No.of Logout No.ActiveUsers Login 1 0 1 Login 2 0 2 Logout 3 1 2 Logout 3 2 1 Login 4 2 2 Logout 4 3 1 Login 5 3 2 .... Thanks, Jirong . |
All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com