| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing values in columns
Hi
What is the best way to compare values in columns as follows:- A3:A30 contains integers as does B3:B30. What I would like to do is count the number of values in Range B3:B30 that are less than equivalent values in A3:A30. (Also those that are equal and those that are more than) TIA Sandy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing values in columns
Try this
=SUMPRODUCT(--(A3:A30B3:B30)) "Sandy" wrote: Hi What is the best way to compare values in columns as follows:- A3:A30 contains integers as does B3:B30. What I would like to do is count the number of values in Range B3:B30 that are less than equivalent values in A3:A30. (Also those that are equal and those that are more than) TIA Sandy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing values in columns
Perfect Barb - Thank you
"Barb Reinhardt" wrote in message ... Try this =SUMPRODUCT(--(A3:A30B3:B30)) "Sandy" wrote: Hi What is the best way to compare values in columns as follows:- A3:A30 contains integers as does B3:B30. What I would like to do is count the number of values in Range B3:B30 that are less than equivalent values in A3:A30. (Also those that are equal and those that are more than) TIA Sandy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
| comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
| Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
| Comparing values | Excel Discussion (Misc queries) | |||
Linear Mode
