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 22.214.171.124 Gill C cgi Teachers 20:48:42 Dashboard web page 126.96.36.199 James R rj Teachers 22:48:42 Shared Drive web page 188.8.131.52 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
Administrator is the value for "Profile".
What's the easiest way of going about this?
I'm using Microsoft Excel 2010.
Thanks in advance,