Previous Topic Next Topic

Marco to delete cells containing an interger

Solved/Closed
KareemB Posts 4 Registration date Friday March 12, 2010 Status Member Last seen March 12, 2010 - Mar 12, 2010 at 01:31 PM
 KareemB - Mar 12, 2010 at 05:07 PM
Hello,

I am stuck and would love some help.

I have two Columns in Excel J and K. The two Columns contain numbers from 1 to 53. I would like to delete any cell containing the number 1 in columns J and K automatically. Is there an easy way to do this without a Marco? If not could someone help me out?

Thanks,

Kareem

5 responses

Answer 1 / 5
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 12, 2010 at 01:46 PM
You want to delete the cell or clear the cell or delete the row ? Also when you say containing, you mean any were in the cell like 213 or just if it is 1
0
Answer 2 / 5
KareemB Posts 4 Registration date Friday March 12, 2010 Status Member Last seen March 12, 2010
Mar 12, 2010 at 02:23 PM
Sorry, I meant clear the cell contents.

And only if the number is 1 would the cells clear

Greatly appreciated
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 12, 2010 at 02:33 PM
Then you can do this.

1. Apply filter.
2. Filter for 1 in the column you desire.
3. Select all the visible cells in that column with data (which should be 1).
4. Right Click and choose Choose clear content
0
Answer 3 / 5
KareemB Posts 4 Registration date Friday March 12, 2010 Status Member Last seen March 12, 2010
Mar 12, 2010 at 02:39 PM
The problem with that is I would like to graph the data and my data is constantly changing. I would have to clear the contents 5 - 6 times a day. Is there a way where it would be done automatically?
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 12, 2010 at 02:44 PM
Not without macro

This is the best I can think of without macro would be the following solution

Lets say the column that you want to address is C. What you can do is that have another column with a formula there as


=IF(C1=1, "",C1) and drag this formula down to the last row of data

Now refer to this new column instead of original C column, in your graph or where ever you wanted to use without "1"
0
Answer 4 / 5
KareemB Posts 4 Registration date Friday March 12, 2010 Status Member Last seen March 12, 2010
Mar 12, 2010 at 02:47 PM
Thnaks i'll try that out

I will keep you posted.

Thanks again
0

Didn't find the answer you are looking for?

Ask a question
Answer 5 / 5
KareemB
Mar 12, 2010 at 05:07 PM
It worked great. Thanks
0