How to delete ALL cells containing the same data
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? |
All times are GMT +1. The time now is 10:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com