Marco to delete cells containing an interger
Solved/Closed
KareemB
KareemB - Mar 12, 2010 at 05:07 PM
- Posts
- 4
- Registration date
- Friday March 12, 2010
- Status
- Member
- Last seen
- March 12, 2010
KareemB - Mar 12, 2010 at 05:07 PM
Related:
- Marco to delete cells containing an interger
- How to delete cells in word table without shifting - Guide
- Delete cell formatting excel - Guide
- Macro for deleting cell value in excel ✓ - Forum - Programming
- Delete cells/rows but keep row info intact ✓ - Forum - Excel
- Deleting cells based on cell value of samerow ✓ - Forum - Excel
5 replies
rizvisa1
Mar 12, 2010 at 01:46 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
KareemB
Mar 12, 2010 at 02:23 PM
- 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
And only if the number is 1 would the cells clear
Greatly appreciated
rizvisa1
Mar 12, 2010 at 02:33 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
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
KareemB
Mar 12, 2010 at 02:39 PM
- 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?
rizvisa1
Mar 12, 2010 at 02:44 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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"
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"
KareemB
Mar 12, 2010 at 02:47 PM
- 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
I will keep you posted.
Thanks again
Didn't find the answer you are looking for?
Ask a question