Srishti Malhotra
Reputation: 1
excel function to find 1 student in more than 1 course
I am working on a file that has students and the courses in which they have enrolled. I have to find if they have enrolled in more than 1 course. which formula will be suitable in excel?
Upvotes: 0
Views: 137
Answers (1)
Dominique
Reputation: 17555
I'm using following formula (using the helper column "Both together"):
=COUNTIF(C$2:C6, C6)
Where my data look as follows:
The column "Both together" consists of the following formula:
=A2 & "|" & B2
Upvotes: 1
Related Questions
- Find multiple matches in a column and Fetch details - based on Student ID from another sheet
- Distributing students across classes based on marks
- mysql - find all students of a class if at least one student attended
- Return all courses a student is taking (Many to Many SQL Database example)
- Query to find students who took many courses together
- SQL query to find the students in one course
- In SQL, How to display a student who is taking more than one subjects?
- How to count students number on different conditions in a attendance sheet
- How to count number of students which have passed or failed in multiple subjects in Excel
- SQL Query to check if student1 has a course with student 2