Hello all,
I need some help with an issue I’m currently facing (apologies if it’s straightforward to some just can’t seem to figure it out).
So I have a spreadsheet of 1000’s of entries for users, where I have determine their compliance for training. All the users are registered to either a virtual training session or a face to face session, so each user will have at least 2 entries (some may have more than this as they may have more than one face to face session). If they have completed either of these (i.e. either their classroom session/s or their virtual training), then I can mark them as compliance.
Currently I get this spreadsheet with separate compliance reasons for either the virtual of f2f (in separate columns) but the report doesn’t not show them as compliant if they have completed either (as it looks at all the modules on their profile)
Anywho, is there a way that I can check if a name appears more than once, this can be cross referenced against all the data set and also if this user has a yes against any of their compliance, they are marked as yes. I’ve played around with IF AND formulas but can’t seem to get the right output
Can anyone help, please?
I need some help with an issue I’m currently facing (apologies if it’s straightforward to some just can’t seem to figure it out).
So I have a spreadsheet of 1000’s of entries for users, where I have determine their compliance for training. All the users are registered to either a virtual training session or a face to face session, so each user will have at least 2 entries (some may have more than this as they may have more than one face to face session). If they have completed either of these (i.e. either their classroom session/s or their virtual training), then I can mark them as compliance.
Currently I get this spreadsheet with separate compliance reasons for either the virtual of f2f (in separate columns) but the report doesn’t not show them as compliant if they have completed either (as it looks at all the modules on their profile)
Anywho, is there a way that I can check if a name appears more than once, this can be cross referenced against all the data set and also if this user has a yes against any of their compliance, they are marked as yes. I’ve played around with IF AND formulas but can’t seem to get the right output
Can anyone help, please?