| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to identify entries in a matrix also present in another list
I have two matrices of data which have a large number of the same entries. I
need to be able to identify the number of entries in one matrix which also occur within the same column in the other matrix (e.g. how many of the entries in column A in one matrix are also in each column of the other matrix). At the moment the best I can do is use pivot table to search each column in one matrix against each column in the other, which is not ideal in that I have about 200 columns in each matrix. It would also be ideal if I could identify which were the common elements. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limits of MINV matrix function | Excel Worksheet Functions | |||
| Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
| Recreate the upper part of a symetric data matrix 75x75 | Excel Discussion (Misc queries) | |||
| How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
| Finding Values in a "Matrix" | Excel Discussion (Misc queries) | |||
Threaded Mode
