Posted to microsoft.public.excel.misc

external usenet poster

Posts: 62

How to delete ALL cells containing the same data --- REVISED

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

A3 and A4 contain 000000003.
Data/Remove Duplicates deletes all but one cell containing 000000003.
Is there a way to delete ALL cells containing 000000003?

REVISION: The cells containing the same data will ALWAYS be consecutive.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete the contents of a cell if (REVISED)	[email protected]	Excel Programming	7	January 23rd 07 10:33 PM
display revised total in Office 2003 when cell data changes	Kerry_y	Excel Discussion (Misc queries)	1	November 15th 06 05:43 PM
Merging data revised	asante_za	Excel Programming	0	January 11th 06 03:36 PM
Format excel to revised date automatically when revised	annetteberrios	Excel Programming	0	September 2nd 05 02:25 PM
REVISED ?? - populate limited cells w/ set value	Jane	Excel Worksheet Functions	1	March 19th 05 02:29 PM

All times are GMT +1. The time now is 12:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us