EXCEL multi-cell to multi-cell comparison

[copeco]

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....

 

[SkipVought]

Hi,

You could do it like this...

=IF(AND(B2=E2,C2=F2,D2=G2),1,0)
[\code]
Hope this helps  :-) Skip,
SkipAndMary1017@mindspring.com

 

[DaleWatson123321]

Hi copeco,

I've created an example model based on your specific example, and it works. I can email you the file if you like if you have any difficulty with the following...

1) In cell F2, enter the following formula

=HLOOKUP(B2,I2:N2,1,"FALSE&quot+HLOOKUP(C2,I2:N2,1,"FALSE&quot+HLOOKUP(D2,I2:N2,1,"FALSE&quot+HLOOKUP(E2,I2:N2,1,"FALSE&quot

2) In cell A2, use: Format - Conditional Formatting.

3) Change "Cell Value Is" to "Formula Is", and enter: =F2>0

4) Click on "Format",

5) Click the "Patterns" tab, and choose a color.

6) Copy the two cells (A2 and F2) down for all the rows required.

I hope this is what you were seeking. Please advise as to how you make out. And as mentioned, I can email you the file if you like.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[copeco]

I think modifications need to be made to my I-N general totals. These are in ascending order by row & there are reaccuring numbers.

 

[copeco]

I think modifications need to be made to my I-N general totals. These are in ascending order by row & there are reaccuring numbers in different rows.
eg row B1:45 80 160 235
row B2:55 65 160 185

 

[DaleWatson123321]

Hi copeco,

I can "guess" as to what exactly you mean in your last posting. However, in the interest of clarification and saving TIME at both ends, I think it best if we eliminate the "blindfolds" - by sending each other our files.

If you have any sensitive data, simply replace it with fictitious data.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca