Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear cells
Each cell in col A contains a "control-number".
Each cell in cols B thru I contains a "year". For example: 010595369-6,2008,2009,,,,,, 010595370-6,2008,2009,,,,,, 010597700-7,2009,,,,,,, 010597703-0,2007,2008,2009,,,,, 010598830-4,2008,2009,,,,,, 010599037-8,2007,2008,,,,,, 010631923-7,2009,,,,,,, 010632739-1,2005,2006,2007,2008,,,, 010632814-5,2009,,,,,,, 010633029-6,2009,,,,,,, 010633143-5,2009,,,,,,, Each cell in cols R thru AA contains a "control-number" AND a year. For example: 010595369-6 2003,010595369-6 2004,010595369-6 2005,010595369-6 2006,010595369-6 2007,010595369-6 2008,010595369-6 2009,,, 010595370-6 2003,010595370-6 2004,010595370-6 2005,010595370-6 2006,010595370-6 2007,010595370-6 2008,010595370-6 2009,,, 010597700-7 2004,010597700-7 2005,010597700-7 2006,010597700-7 2007,010597700-7 2008,010597700-7 2009,,,, 010597703-0 2004,010597703-0 2005,010597703-0 2006,010597703-0 2007,010597703-0 2008,010597703-0 2009,,,, 010597969-4 2004,010597969-4 2005,010597969-4 2006,010597969-4 2007,010597969-4 2008,010597969-4 2009,,,, 010598830-4 2003,010598830-4 2004,010598830-4 2005,010598830-4 2006,010598830-4 2007,010598830-4 2008,010598830-4 2009,,, 010599037-8 2003,010599037-8 2004,010599037-8 2005,010599037-8 2006,010599037-8 2007,010599037-8 2008,010599037-8 2009,,, 010630761-4 2007,010630761-4 2008,010630761-4 2009,,,,,,, 010631923-7 2004,010631923-7 2005,010631923-7 2006,010631923-7 2007,010631923-7 2008,010631923-7 2009,,,, 010632313-9 2009,,,,,,,,, 010632314-0 2009,,,,,,,,, 010632739-1 2000,010632739-1 2001,010632739-1 2002,010632739-1 2003,010632739-1 2004,010632739-1 2005,010632739-1 2006,010632739-1 2007,010632739-1 2008,010632739-1 2009 010632814-5 2004,010632814-5 2005,010632814-5 2006,010632814-5 2007,010632814-5 2008,010632814-5 2009,,,, 010632843-1 2009,,,,,,,,, 010633029-6 2005,010633029-6 2006,010633029-6 2007,010633029-6 2008,010633029-6 2009,,,,, 010633143-5 2004,010633143-5 2005,010633143-5 2006,010633143-5 2007,010633143-5 2008,010633143-5 2009,,,, How can I clear a cell in cols R thru AA if it matches the "control- number" (in col A) AND the "year" in cols B thru I |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup cells in one column and clear cells in another | Excel Programming | |||
Create a Clear button to clear unprotected cells | Excel Programming | |||
clear contents cells of unprotected cells | Excel Programming | |||
Clear cells with #N/A | Excel Programming | |||
Clear cells range if certain cells are all empty | Excel Programming |