Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is an example of two number sets I'm using in cells A1:J1 and
A2:J2 4 6 9 15 16 20 21 27 28 29 5 7 9 13 16 21 27 27 31 37 Sometime's my number sets won't have any matching numbers, sometimes all 10 will match. I would like to copy any of the numbers in set two that match any of the numbers in set one into cells L2:U2 without duplicates (27 in this example). For this example I would end up with 9 16 21 27 in cells L2:O2 P2:U2 would be left blank (no zero in cell). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a cell's value to copy another cells info to another workshe | Excel Worksheet Functions | |||
vbe - copy a cell's value by other workbook | Excel Programming | |||
matching numbers | Excel Worksheet Functions | |||
Formula to copy another cell's contents - Help! | Excel Discussion (Misc queries) | |||
How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) |