For another Example:
USER ID = 31267
STATE/TERRITORY EXCLUSIONS = NSW and WA
SITE EXCLUSIONS = 1640 and 1670 (as well as all in NSW and WA)BLANK
SITE PREFERENCES = Preference 1 = 1640, Preference 2 = 1670, Preference 3 = 81, Preference 4 = 422, Preference 5 = BLANK
1640 is in WA so they can't work there
1670 is in NSW so they Can't work there
81 is in NSW so they can't work there
422 is in NT so this would be a Match
So in Column 'BM' it would say 422
Then the algorithm would move to the next row
Bookmarks