attended

Hi, I have a workbook that lists all terms attended for each student as well as their GPA for that term in descending order. What I am trying to achieve is target the top entry for each student, which will give me the last term attended as well as their last known GPA. Please see a short example...

Hi. I'm trying to create a double IF statement which returns the value "Attended" in ColC where ColA contains "Confirmed" and ColB contains "Show". Otherwise "Did not attend". Thanks for looking. <tbody> ColA ColB ColC (Desired Result) Confirmed Show Attended Confirmed Show Attended...

I have been charged with coming up with a spreadsheet that will show if someone attended a function each week. I have set up one tab (Weekly Attendees) to include the names and the dates attended. I would like another tab (Attendance) to have the names in Col. A with the Dates on line 1 for 52...

Hey folks Have a column (R) to populate with data depending on the answers in several other columns. I've started it with .... =IF(S5<>"",VLOOKUP(S5,'Look Up Tables'!$T$2:$V$29,3,FALSE),"********") Then in the ******* I need these options from cols AA, O & P to enter the correct treatment AA...

I have a excel table, which has a column each row will show number of student enrolled, and another column name of student attended. I want get the percentage of attendance based on enrollment. Problem I am having is Number of student enrolled repeated in each row. I have to take only once...

Hi All, Im hoping you could help me with a formula that gives me the right % based on these scenarios I have columns that have data like this Planned Attended Unplanned Attended 11-Jun 12-Jun 13-Jun 14-Jun 15-Jun 16-Jun 17-Jun 18-Jun 19-Jun 20-Jun 21-Jun 22-Jun 23-Jun 1 1 1 1...

Hello I am trying to find the formula that will give me the percentage of 2 cells on my training spreadsheet. A1 is attended and A2 is not attended. If 6 people attended and 2 people didn't, what formula would I use to work out the percentage of attendance. A1 = 6 A2 = 2 Total = 8 I know...

Hi all, I'm not even sure if this is possible but I just wanted to see if there was a better solution to something I am struggling with. I am trying to remove duplicate instances from a list of training attendance. People are free to book on a course themselves but the problem from a...

Hi all I have a register, which has days of the week and attendances, tracked in Excel 2010. I need a formula that will calculate the number of individuals who have attended over that period of time, can anybody point me in the right direction? Many thanks