| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to compare two cells for the same numbers
Is there a way to compare two cells to see how many numbers are same? For example, A2 contains 16, 17, 19; B2 contains 16, 17; and I want to put in C2 the result 2. What is the formula for this? Thanks -- sun1x ------------------------------------------------------------------------ sun1x's Profile: http://www.excelforum.com/member.php...o&userid=28327 View this thread: http://www.excelforum.com/showthread...hreadid=479096 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
| How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added? | Excel Worksheet Functions | |||
| substracting numbers in non contigous cells | Excel Discussion (Misc queries) | |||
| How to compare 3 numbers and return value | Excel Worksheet Functions | |||
| update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
Threaded Mode
