attend

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...

Hi I want to compare 2 tables to see who attended the conference/meeting. So I used vlookup() but what I want to do, instead of Vlookup returning the name, I want vlookup returning "Attended"! How can I do that. I managed to do the "Not Attend" only D2=IFERROR(VLOOKUP(A2,L:L,1,FALSE),"not...

Good day, I am looking for a formula to indicate what training a staff member still has to attend. Below is the training schedule. The T indicates the training they need to attend. The A indicates they have attended the training. What I would like is the list of the staff member that still has...

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...

I have the foliowing snippet of code to email data I need it amended to include the value of B1 on sheet "Ageing" after the text in my code "Please attend to those over 60 days" strBody = strBody & "Attached Please find Debtors Report-Please attend to those over 60 days -Please chase up on...

Hi Please can someone help me. I have a whole list of serial numbers (H001 to H4569) which I want to find within a multiple text strings. Example: H2365 ATTEND TO NOT STARTING 384146 REQ, but the serial numbers are either in the beginning, middle or end of the text string. But the formula also...