Criteria: Column A = names
Column B-E = name/numbers (for a specific name)
Column I-N = numbers (general totals)
Required: If "all" the name/numbers(not added together but separatly)eg(8.0, 9.75,7.0)is found in the numbers(general)eg(8.0, 9.75, 7.0) then highlight the person's name.
I can do this with one cell location only. =countif I2:N20,B2). BUT THIS WILL NOT WORK WITH RANGES COMPARING WITH RANGES.
THANKS....
Column B-E = name/numbers (for a specific name)
Column I-N = numbers (general totals)
Required: If "all" the name/numbers(not added together but separatly)eg(8.0, 9.75,7.0)is found in the numbers(general)eg(8.0, 9.75, 7.0) then highlight the person's name.
I can do this with one cell location only. =countif I2:N20,B2). BUT THIS WILL NOT WORK WITH RANGES COMPARING WITH RANGES.
THANKS....