Spreadsheet: 686124d1594375487-multiple-entries-rows-of-a-unique-name-and-finding-the-maximum-value-in-another-column-excel-forum-help-sample
Sheet: Original File

role_name | user_building_id | user_building_name | username | email | schoology_user_id | unique_user_id | action_type | item_type | item_id | item_name | course_name | course_code | section_name | last_event_timestamp | event_count | role_id | user_building_code | last_name | first_name | device_type | item_building_id | item_building_name | item_building_code | item_parent_type | group_id | group_name | course_id | [NAME] | section_school_code | section_code | month | date | timestamp
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | CREATE | SESSION |  |  |  |  |  | 00:03:57.300000 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-02 00:00:00 | 20:03:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:03:57.300000 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-02 00:00:00 | 20:03:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2403812049 | Please make sure you have watched all the materials in this folder before moving on | ASL 1 | ASL101 | MI | 00:06:36.100000 | 2 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:06:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812059 | [NAME] | ASL 1 | ASL101 | MI | 00:06:51.700000 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:06:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812064 | Reasons to Take ASL | ASL 1 | ASL101 | MI | 00:25:01.800000 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:25:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2520233669 | What is a learning facilitator? | ASL 1 | ASL101 | MI | 00:30:31.700000 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:30:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812067 | Meet your teacher.mp4 | ASL 1 | ASL101 | MI | 00:31:49.300000 | 2 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:31:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2540313761 | Meet Christina Pribonic | ASL 1 | ASL101 | MI | 00:32:03 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:32:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2540317007 | [NAME] | ASL 1 | ASL101 | MI | 00:33:14.700000 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:33:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2520233680 | Meet and Greet | ASL 1 | ASL101 | MI | 00:33:39.900000 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:33:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2403812311 | Glide | ASL 1 | ASL101 | MI | 00:34:32 | 1 | 334361 |  | Adams | Sydney | WEB_MOBILE | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 20:34:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | CREATE | SESSION |  |  |  |  |  | 00:09:25.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-02 00:00:00 | 21:09:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:09:25.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-02 00:00:00 | 21:09:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2403812311 | Glide | ASL 1 | ASL101 | MI | 00:09:26.200000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 21:09:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2403812314 | Be sure to reach out to your learning facilitator through Glide, before moving on to the next unit. | ASL 1 | ASL101 | MI | 00:16:30.700000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 21:16:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812088 | ASLVA Syllabus ASL 1 (1).pdf | ASL 1 | ASL101 | MI | 00:22:15.700000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 21:22:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2591285102 | Creating your Go React Account | ASL 1 | ASL101 | MI | 00:42:43.600000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 21:42:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:19:02 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-03 00:00:00 | 01:19:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2591285102 | Creating your Go React Account | ASL 1 | ASL101 | MI | 00:19:02.200000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:19:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | EXTERNAL_TOOL | 2591286161 | Meet + Greet with your learning facilitator | ASL 1 | ASL101 | MI | 00:19:45.700000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:19:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2403812092 | Please make sure you have watched all the lessons in this folder before moving on | ASL 1 | ASL101 | MI | 00:24:08 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:24:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812104 | How do I watch the lessons?.mp4 | ASL 1 | ASL101 | MI | 00:29:02.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:29:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2593942222 | What's the easiest, fastest way to get through this class?.mp4 | ASL 1 | ASL101 | MI | 00:30:07.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:30:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812111 | How do I review vocabulary?.mp4 | ASL 1 | ASL101 | MI | 00:36:53.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:36:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812125 | How can I review what I'm learning?.mp4 | ASL 1 | ASL101 | MI | 00:38:56.800000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:38:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812136 | How can I practice signing?.mp4 | ASL 1 | ASL101 | MI | 00:39:44.800000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:39:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812141 | How do I submit assignments?.mp4 | ASL 1 | ASL101 | MI | 00:41:42 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:41:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2404166856 | Recording Go React assignments directly in Schoology | ASL 1 | ASL101 | MI | 00:43:41.700000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:43:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812148 | How do I take quizzes and tests?.mp4 | ASL 1 | ASL101 | MI | 00:44:06.100000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:44:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812154 | What if I have a question?.mp4 | ASL 1 | ASL101 | MI | 00:45:53.100000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:45:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812162 | How do I know my grade?.mp4 | ASL 1 | ASL101 | MI | 00:46:44.800000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:46:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812168 | ASLVA Syllabus ASL 1 (1).pdf | ASL 1 | ASL101 | MI | 00:47:53.600000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:47:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2533506963 | Getting your computer ready | ASL 1 | ASL101 | MI | 00:48:39.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:48:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | CREATE | SESSION |  |  |  |  |  | 00:51:22.300000 | 2 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-03 00:00:00 | 01:51:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812094 | How do I navigate the course?.mp4 | ASL 1 | ASL101 | MI | 00:51:29.700000 | 2 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:51:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | TEST/QUIZ | 2403812172 | I have completed the "How to navigate the course" materials | ASL 1 | ASL101 | MI | 00:52:10.500000 | 3 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-03 00:00:00 | 01:52:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | CREATE | SESSION |  |  |  |  |  | 00:25:12.500000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-04 00:00:00 | 17:25:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812173 | Unit 1 Content (Greetings, Farewells, Emotions, and Introductions) | ASL 1 | ASL101 | MI | 00:25:24.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:25:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2597788721 | Student's Choice | ASL 1 | ASL101 | MI | 00:25:47.800000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:25:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2403812189 | Remember to complete everything in this folder in sequential order | ASL 1 | ASL101 | MI | 00:27:02.300000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:27:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812190 | Unit 1 Content PDF.pdf | ASL 1 | ASL101 | MI | 00:27:10.700000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:27:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2560702068 | Unit 1a Checklist | ASL 1 | ASL101 | MI | 00:27:21 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:27:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | PAGE | 2403812205 | Lessons | ASL 1 | ASL101 | MI | 00:44:49.300000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:44:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812194 | Greetings, How are you?.m4v | ASL 1 | ASL101 | MI | 00:45:03.300000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:45:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | [NAME] | 2403812215 | Unit 1a, Your experience | ASL 1 | ASL101 | MI | 00:49:17.700000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:49:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | SUBMIT | [NAME] | 2403812215 | Unit 1a, Your experience | ASL 1 | ASL101 | MI | 00:58:13.100000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 17:58:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812265 | Notes for Learning ASL.m4v | ASL 1 | ASL101 | MI | 00:07:00.800000 | 2 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-04 00:00:00 | 20:07:00 |  | Multiple entries/rows of a unique name, and finding the maximum value in another column
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:07:01 | 3 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-04 00:00:00 | 20:07:00 |  | This will make more sense when you look at the sample of my spreadsheet.
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:43:20.200000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-05 00:00:00 | 03:43:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:28:37.200000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-05 00:00:00 | 04:28:00 |  | I have hundreds of students that take an online class from me. I get a report (CSV file) from my Learning Management System, Schoology that includes a lot of metrics related to student activity. It's information overload with 1000's of rows of a spreadsheet taken up. The good news is, the information I want is contained in this massive spreadsheet. Bad news is, I don't know how to pull it out.
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812216 | Language, ASL.m4v | ASL 1 | ASL101 | MI | 00:30:07.300000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-05 00:00:00 | 04:30:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | CREATE | SESSION |  |  |  |  |  | 00:31:40.700000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-06 00:00:00 | 21:31:00 |  | I'm looking to extract a few things from this enormous CSV sheet. 1) I want the first name, last name, and last login date (column AG) for each student. 2) I want a field that will be populated if a phrase that begins with "I have completed" is found in a column K.
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | READ | FILE | 2403812222 | Deaf Culture and the Deaf Community.m4v | ASL 1 | ASL101 | MI | 00:18:57.800000 | 2 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-06 00:00:00 | 22:18:00
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:18:58 | 2 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-06 00:00:00 | 22:18:00 |  | The challenge is, the current CSV file shows ALL activity for each student. For example, [NAME] takes up 57 rows of the spreadsheet documenting every single activity they performed (in this case it's 57 activities and 57 rows on the spreadsheet). [NAME] completed these activities from 7/2/20 through 7/8/20. All 57 rows have a date of when that activity was performed. I simply want the LATEST date to be extracted out for [NAME]. The further challenge of this is the fact there are multiple students. So somehow the formulas/functions created need to know how to stop analyzing the data for [NAME] after row 57, and start analyzing data for the next student, [NAME] (who has 8 rows of activities on the spreadsheet).
Student | 708173257 | The ASL Virtual Academy | sadams |  | 93949389 | sadams2020 | UPDATE | SESSION |  |  |  |  |  | 00:52:22.900000 | 1 | 334361 |  | Adams | Sydney | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-07 00:00:00 | 20:52:00
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | CREATE | SESSION |  |  |  |  |  | 00:23:36.500000 | 1 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-01 00:00:00 | 21:23:00 |  | In column K, [NAME] has a result that starts with "I have completed". I want that cell result to be pulled out.
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | READ | EXTERNAL_TOOL | 2404360117 | Unit 1a (b) Greetings practice | ASL 1 | ASL101 | MI | 00:29:13.100000 | 2 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-01 00:00:00 | 21:29:00
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | UPDATE | SESSION |  |  |  |  |  | 00:55:37.500000 | 2 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-01 00:00:00 | 21:55:00 |  | I'm attaching a sample of my massive spreadsheet (sample includes less than 100 rows). The tabs at the bottom are titled "original file" and "desired output." It's pretty self explanatory, but "original file" is what I'm working with, and the desired output is what the spreadsheet would look like if I had it my way.
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | UPDATE | SESSION |  |  |  |  |  | 00:43:13.900000 | 1 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-02 00:00:00 | 00:43:00
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | READ | EXTERNAL_TOOL | 2404343588 | Unit 1a (c) Hi, How are you? | ASL 1 | ASL101 | MI | 00:43:14.300000 | 1 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 00:43:00 |  | I've never used this forum before. I'm very curious to see what kind of help I get. Looking forward to it!
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | READ | LINK | 2403812271 | Sign Language Dictionary (use this site to look up vocabulary words you've learned. You can also see how this sign is produced in other sign languages!) | ASL 1 | ASL101 | MI | 00:50:44.200000 | 1 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 00:50:00
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | READ | FILE | 2403812198 | Greetings, What's up?.m4v | ASL 1 | ASL101 | MI | 00:56:31.600000 | 1 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 00:56:00
Student | 708173257 | The ASL Virtual Academy | nangell |  | 93474078 | nangell2020 | READ | EXTERNAL_TOOL | 2404363007 | Unit 1a (d) What's up? | ASL 1 | ASL101 | MI | 00:03:38.200000 | 6 | 334361 |  | Angell | [NAME] | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 709733603 | 2403812012 |  |  | 7 | 2020-07-02 00:00:00 | 01:03:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | CREATE | SESSION |  |  |  |  |  | 00:29:13.500000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-03 00:00:00 | 19:29:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | UPDATE | SESSION |  |  |  |  |  | 00:29:13.500000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-03 00:00:00 | 19:29:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | FILE | 2354889632 | Unit 7 Grammar, Tend-to.m4v | ASL 2 | ASL102 | Section FGHS | 00:44:08.700000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-03 00:00:00 | 19:44:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | UPDATE | SESSION |  |  |  |  |  | 00:59:37.200000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-05 00:00:00 | 18:59:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | CREATE | SESSION |  |  |  |  |  | 00:59:37.200000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | USER |  |  |  |  |  |  | 7 | 2020-07-05 00:00:00 | 18:59:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | FILE | 2354889650 | Unit 7 Essential Signs.mp4 | ASL 2 | ASL102 | Section FGHS | 00:03:56.100000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:03:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | FILE | 2354889651 | Unit 7 Grammar, Plural Pronouns.m4v | ASL 2 | ASL102 | Section FGHS | 00:05:30.200000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:05:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | FILE | 2359616428 | Unit 7 Physical Descriptions Vocabulary.mp4 | ASL 2 | ASL102 | Section FGHS | 00:14:10.300000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:14:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | FILE | 2354889659 | Unit 7 Mouth Morphemes.m4v | ASL 2 | ASL102 | Section FGHS | 00:15:31.900000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:15:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | SUBMIT | TEST/QUIZ | 2354889667 | Unit 7, (k) Grammar + Culture Practice Quiz | ASL 2 | ASL102 | Section FGHS | 00:21:13.500000 | 2 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:21:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | TEST/QUIZ | 2354889667 | Unit 7, (k) Grammar + Culture Practice Quiz | ASL 2 | ASL102 | Section FGHS | 00:21:28.300000 | 20 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:21:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | SUBMIT | TEST/QUIZ | 2354889668 | Unit 7, (l) Grammar + Culture Test | ASL 2 | ASL102 | Section FGHS | 00:24:48.500000 | 1 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:24:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | TEST/QUIZ | 2354889668 | Unit 7, (l) Grammar + Culture Test | ASL 2 | ASL102 | Section FGHS | 00:25:21.700000 | 14 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:25:00
Student | 708173257 | The ASL Virtual Academy | [NAME] |  | 86526817 | [NAME] | READ | TEST/QUIZ | 2354889669 | Unit 7, (m) Listening Quiz | ASL 2 | ASL102 | Section FGHS | 00:26:30.800000 | 2 | 334361 |  | Arnott | Lily | WEB | 708173257 | The ASL Virtual Academy |  | COURSE |  |  | 917430668 | 2211716981 |  |  | 7 | 2020-07-05 00:00:00 | 19:26:00