| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I find out if numbers in one column are also in a secondcolumn please?
Hello - I hope someone can help please - I'm a bit of a novice it has
to be said ! I have 2 columns of about 800 numbers (varying number of digits between 6 and 8) and I need to find out how many of the numbers in column A are also in column B. I just need a total really - don't need to know which numbers recur I've been looking at countif and lookup and match and getting very confused ! It sounds like it should be easy but I'm stumped Can anyone sort me out? Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find missing numbers in a column | Excel Discussion (Misc queries) | |||
| find duplicate numbers in a column? | Excel Discussion (Misc queries) | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| I need to find odd numbers in a column | Excel Worksheet Functions | |||
| How can you find duplicate numbers in a column? | Excel Worksheet Functions | |||
![RobertSE6[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
