| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Detete matching cells
Col A has 326,167 cells.
Col B has 239,820 cells. Here's portion of my spreadsheet: A B 0000000021957 0000000022002 0000000022002 0000000032002 0000000031957 0000000032003 0000000032002 0000000042002 0000000032003 0000000052002 0000000042002 0000000052003 0000000052002 0000000062002 0000000052003 0000000102002 0000000061967 0000000121996 0000000061968 0000000142002 0000000062002 0000000152002 0000000081963 0000000162002 0000000102002 0000000481994 0000000121996 0000000481995 0000000142002 0000000481996 0000000152002 0000000481997 0000000162002 0000000481998 0000000341991 0000000481999 0000000401961 0000000482000 How can I delete the cells in Col A whose contents match cells in Col B? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Detete matching cells
On Sat, 14 Jan 2012 19:36:36 -0800 (PST), gary wrote:
Col A has 326,167 cells. Col B has 239,820 cells. Here's portion of my spreadsheet: A B 0000000021957 0000000022002 0000000022002 0000000032002 0000000031957 0000000032003 0000000032002 0000000042002 0000000032003 0000000052002 0000000042002 0000000052003 0000000052002 0000000062002 0000000052003 0000000102002 0000000061967 0000000121996 0000000061968 0000000142002 0000000062002 0000000152002 0000000081963 0000000162002 0000000102002 0000000481994 0000000121996 0000000481995 0000000142002 0000000481996 0000000152002 0000000481997 0000000162002 0000000481998 0000000341991 0000000481999 0000000401961 0000000482000 How can I delete the cells in Col A whose contents match cells in Col B? See responses in microsoft.public.excel.programming |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how could i detete lots of rows by one commond | Excel Discussion (Misc queries) | |||
| Matching cells | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Matching cells | Excel Discussion (Misc queries) | |||
Linear Mode
