# Compairing a range of cells to another range of cells

#### glennw

##### New Member
Can enyone tell me how to compair a range of cells to another range of cells? Example: if A2 thru F2 are the same as H2 thru M2, then print "WINNER" in the cell that you are creating the formula in.

thank y ou very much for your help.

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
glennw said:
Can enyone tell me how to compair a range of cells to another range of cells? Example: if A2 thru F2 are the same as H2 thru M2, then print "WINNER" in the cell that you are creating the formula in.

thank y ou very much for your help.

=AND(A2:F2=H2:M2)+0

which you need to confirm with control+shift+enter.

Custom format the formula cell as:

[=0]"";[=1]"WINNER"

As instructed, I placed a custom format in the formula cell [=0]"";[=1]"WINNER". When I view it int he "format cell" screen, it looks like [=0]"";[=1]"WINNER"; General. I don't know where the General is coming from. I also placed the "=AND(A2:F2=H2:M2)+0" in the formula cell and all that I am getting is "#VALUE".

In cells A2 thru F2, I placed the numbers 1, 2, 3, 4, 5, 6 and in the other range, I placed the same numbers. In the cell that I am placing the formula in compairing the two ranges, I get "#VALUE".

Thank you.

glennw said:
As instructed, I placed a custom format in the formula cell [=0]"";[=1]"WINNER". When I view it int he "format cell" screen, it looks like [=0]"";[=1]"WINNER"; General. I don't know where the General is coming from. I also placed the "=AND(A2:F2=H2:M2)+0" in the formula cell and all that I am getting is "#VALUE".

In cells A2 thru F2, I placed the numbers 1, 2, 3, 4, 5, 6 and in the other range, I placed the same numbers. In the cell that I am placing the formula in compairing the two ranges, I get "#VALUE".

Thank you.

You need to confirm the formula with control+shift+enter, not just with enter.

IT WORKS!!! Thank you so very much.

Glenn

Replies
4
Views
296
Replies
3
Views
280
Replies
1
Views
246
Replies
6
Views
363
Replies
6
Views
272

Threads
1,212,149
Messages
6,106,253
Members
448,010
Latest member
wbarkwell

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back