Column AK can have a value of 1 or 0. Individuals listed on my spreadsheet can have be listed on multiple rows. Some rows for AK might be a 1 and others, 0. This data is stored on the sheet 'Report - All Data'.
I have another sheet named discrepancy review. I have a unique list of individuals (removed duplicates). I would like to somehow search against Report - All Data. If anywhere in AK = customer ID and a 1, show message A. Otherwise, message B.
I tried a standard if statement but don't know that is appropriate- I feel like the value in AK row 10 will always overwrite AK3, so would not get consistent results. Thoughts?
I have another sheet named discrepancy review. I have a unique list of individuals (removed duplicates). I would like to somehow search against Report - All Data. If anywhere in AK = customer ID and a 1, show message A. Otherwise, message B.
I tried a standard if statement but don't know that is appropriate- I feel like the value in AK row 10 will always overwrite AK3, so would not get consistent results. Thoughts?