| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete ALL cells containing the same data
Hi,
Am Fri, 10 Jan 2014 16:59:03 -0800 (PST) schrieb GWC: Cell Contains A1 000000001 A2 000000002 A3 000000003 A4 000000003 A5 000000004 A6 000000005 A7 000000006 A8 000000007 A9 000000007 A10 000000008 A11 000000008 A12 000000009 make a helper column with =COUNTIF($A$1:$A$1000,A1)1 in the first row and copy down. Filter this column for TRUE and delete the cells. Then sort A to eliminate the blank cells. Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete ALL cells containing the same data | Excel Discussion (Misc queries) | |||
| How to delete cells with a given data? | Excel Discussion (Misc queries) | |||
| delete columns if cells have no data | Excel Discussion (Misc queries) | |||
| Delete cells containing specific data? | Excel Discussion (Misc queries) | |||
| How do I delete only part of the data in a row of cells? | Excel Worksheet Functions | |||
Hybrid Mode
