Excel 2007 : Complex lookup required

Hi,
I am currently assiting a friend with their business based on a java based product that is not yet fully developed. In the mean time, we are trying to track the number of users that are logged in currently, but the system events does not included those that have been continiously logged in therefore giving skewed results. So what we have done is exported backdated xls in the hope of trying to work out which clients have been logging in and those that havent logged out, therefore implying that they are still logged in.

What we need help in doing is to somehow using the 6000+ rows is to find a quick way of returning those people that have not logged out essentially. But to do this we need to correspond the client names with their logging in details, and seperate the clients, then from that individually count each clients logins (the event is named as "Logged in" on our side) and if it gives an odd number they are still logged in, but if even they must have logged out.

We have tried combining h and v lookups with counif and such but we cannot seem to get anything to do what is required, so any help is appreciated.

Many Thanks

Hi,

Apologies, that was an error on my part. Ive got attached a demo, all the values are false but the idea is essentially the same.

Thanksdemo2.xlsx

If it is possible to pull all the events that are 'Logged in and Logged out' into a different sheet as a counted figure for each individual person. So for 'Ray Jones' he has logged in and logged out therefore the figure will be 2. Then with that 2 we will know that he is logged out because it is even. If it were say 'Chuck Norris' who has 'Logged in', 'Logged out', 'logged in', the number will be 3, implying he is still logged in.

I hope that helps

You are an absolute God Send! Thanks very much for that, it actually works very well!

Im guessing if i were to do a thing by that side that instantly says logged in or not, i would do a logic test so if number is odd, logged in, if even logged out?

Sorry,

What you have done is perfect I cannot thank you enough. However, is it possible with these numbers to just make things easier if others look at it by just in the adjecent cell using a formula that says if the number is even then 'Logged Out' appears, if not 'Logged In' appears.

Yeah that its.

Thank you very much for your help! You have saved us alot of time and effort on ourside and it is much appreciated. Hopefully in time we will be as adept in Excel as you are!