| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find if value in column A exists in Column B
Hi there - I have 2 columns of data (numerical), I need to find how many
values exist in both columns. Some type of lookup function should do it, but I tried and was unsuccessful. Can anyone help? |
|
#2
|
|||
|
|||
|
Try:
=SUMPRODUCT(COUNTIF(A1:A10,B1:B10)) HTH Jason Atlanta, GA -----Original Message----- Hi there - I have 2 columns of data (numerical), I need to find how many values exist in both columns. Some type of lookup function should do it, but I tried and was unsuccessful. Can anyone help? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| find first nonzero value in column | Excel Worksheet Functions | |||
| find first nonzero value in column | Excel Worksheet Functions | |||
| find first nonzero value in column | Excel Worksheet Functions | |||
| Find AVG/MIN of a Column, excluding 0's and NULL's? | Excel Worksheet Functions | |||
Linear Mode
