Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing a range of values
I want to compare two ranges of cells with each other. Some need a string
comparasion, and some need a floating point delta comparasion. So I was trying to do something like this: =AND( (A1:A10)=(B1:B10) ) =DELTA( (C1:C10), (D1:D10) ) However I get back #VALUE when I try to do a range like that (it works if I do just one cell). How would I compare all the values at the same time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing a range of values
Assuming you want to compare A1 to B1, A2 to B2, A3 to B3, etc...
Array entered** : =AND(A1:A10=B1:B10) =AND(C1:C10=D1:D10) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) DELTA won't work on arrays. -- Biff Microsoft Excel MVP "tamirh" wrote in message ... I want to compare two ranges of cells with each other. Some need a string comparasion, and some need a floating point delta comparasion. So I was trying to do something like this: =AND( (A1:A10)=(B1:B10) ) =DELTA( (C1:C10), (D1:D10) ) However I get back #VALUE when I try to do a range like that (it works if I do just one cell). How would I compare all the values at the same time? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing a range of values
Thanks, the CTRL+SHIFT+ENTER was what I was looking for.
"T. Valko" wrote: Assuming you want to compare A1 to B1, A2 to B2, A3 to B3, etc... Array entered** : =AND(A1:A10=B1:B10) =AND(C1:C10=D1:D10) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) DELTA won't work on arrays. -- Biff Microsoft Excel MVP "tamirh" wrote in message ... I want to compare two ranges of cells with each other. Some need a string comparasion, and some need a floating point delta comparasion. So I was trying to do something like this: =AND( (A1:A10)=(B1:B10) ) =DELTA( (C1:C10), (D1:D10) ) However I get back #VALUE when I try to do a range like that (it works if I do just one cell). How would I compare all the values at the same time? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing a range of values
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "tamirh" wrote in message ... Thanks, the CTRL+SHIFT+ENTER was what I was looking for. "T. Valko" wrote: Assuming you want to compare A1 to B1, A2 to B2, A3 to B3, etc... Array entered** : =AND(A1:A10=B1:B10) =AND(C1:C10=D1:D10) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) DELTA won't work on arrays. -- Biff Microsoft Excel MVP "tamirh" wrote in message ... I want to compare two ranges of cells with each other. Some need a string comparasion, and some need a floating point delta comparasion. So I was trying to do something like this: =AND( (A1:A10)=(B1:B10) ) =DELTA( (C1:C10), (D1:D10) ) However I get back #VALUE when I try to do a range like that (it works if I do just one cell). How would I compare all the values at the same time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
Comparing a Range of Values | Excel Discussion (Misc queries) | |||
Comparing values | Excel Discussion (Misc queries) | |||
comparing two values | Excel Worksheet Functions |