Marco to delete cells containing an interger
Solved/Closed
KareemB
Posts
4
Registration date
Friday 12 March 2010
Status
Member
Last seen
12 March 2010
-
12 Mar 2010 à 13:31
KareemB - 12 Mar 2010 à 17:07
KareemB - 12 Mar 2010 à 17:07
Related:
- Marco to delete cells containing an interger
- How to delete cells in word - Guide
- How to delete skype account - Guide
- Sed delete line - Guide
- Delete autofill chrome - Guide
- Does instagram delete message requests after 4 weeks - Guide
5 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
12 Mar 2010 à 13:46
12 Mar 2010 à 13:46
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
Posts
4
Registration date
Friday 12 March 2010
Status
Member
Last seen
12 March 2010
12 Mar 2010 à 14:23
12 Mar 2010 à 14:23
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
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
12 Mar 2010 à 14:33
12 Mar 2010 à 14:33
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
Posts
4
Registration date
Friday 12 March 2010
Status
Member
Last seen
12 March 2010
12 Mar 2010 à 14:39
12 Mar 2010 à 14:39
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
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
12 Mar 2010 à 14:44
12 Mar 2010 à 14:44
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
Posts
4
Registration date
Friday 12 March 2010
Status
Member
Last seen
12 March 2010
12 Mar 2010 à 14:47
12 Mar 2010 à 14:47
Thnaks i'll try that out
I will keep you posted.
Thanks again
I will keep you posted.
Thanks again
