Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |