1
I have a CSV file containing 100,000 rows.
Each row consists of information under a number of columns, such as "Date", "Page Accessed", "Page Type", "IP", "User Surname", "User Forename", "User Login", "Profile".
A few example rows may therefore look like:
A B C D E F G H
18:48:42 Home Drive web page 90.90.90.90 Gill C cgi Teachers
20:48:42 Dashboard web page 90.90.90.90 James R rj Teachers
22:48:42 Shared Drive web page 90.90.90.90 Gill C cgi Teachers
These rows are an individual hit on our Virtual Learning Environment.
I would like to determine how many times each user has made a hit on our VLE.
As such, I would imagine that I need to get excel to count the number of times each User Login
appears in the list of rows where Teachers
, Staff
or Administrator
is the value for "Profile".
What's the easiest way of going about this?
I'm using Microsoft Excel 2010.
Thanks in advance,
Pivot Table or advanced filtering would do exactly this – Raystafarian – 2012-02-23T16:47:39.220
OK, that's great news, but I have no idea how to do either... :) – dunc – 2012-02-23T16:48:16.957
what version of excel are you using – Raystafarian – 2012-02-23T16:48:58.360
I'm using Microsoft Excel 2010. I'll update my OP to clarify that! – dunc – 2012-02-23T17:05:32.223
You want to know how many unique values in column G appear when column H reads Teachers OR Staff OR Administrator? – Raystafarian – 2012-02-23T18:17:10.130
I want to know how many times "cgi" under the "User Login" (which, say, is Column H) appears where the "User Profile" (say, column G) is equal to "Teachers" OR "Staff" OR "Administrator" – dunc – 2012-02-23T18:21:21.810