Mar 22 2019 02:45 PM
As part of an assignment handed off to me from my manager, I have to create a very complex excel online spreadsheet.
I am trying to create an error message for when a user selects a name that is on the previous date.
As you can see , "Andrew A." under Auditor #1 is Cell B6 and Auditor #2 is Cell C6. Those cell scurrently contain a list of the employees at our location. I need to also validate and give an error message for when the same name is selected for B6 and C6. Please also assume the same would be needed for every other pairing on this spreadsheet.
Mar 22 2019 03:04 PM
Using structured references to create a field within a table
= IF( [@Auditor1]=[@Auditor2], "Error", "" )
gives "Error" or blank.
The total count of double assignment errors would be
= SUMPRODUCT( SIGN( Table1[Auditor1]=Table1[Auditor2] ) )
Mar 22 2019 03:55 PM