| 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? |
| 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 | |||
Threaded Mode
