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 replies

Answer 1 / 5
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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