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
KareemB - Mar 12, 2010 at 05:07 PM
Related:
- Marco to delete cells containing an interger
- How to delete whatsapp account without login - Guide
- How to delete whatsapp account without phone - Guide
- Gmail swipe to delete - Guide
- How to delete tabs on android - Guide
- How to delete snapchat account - Guide
5 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 12, 2010 at 01:46 PM
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
Posts
4
Registration date
Friday March 12, 2010
Status
Member
Last seen
March 12, 2010
Mar 12, 2010 at 02:23 PM
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 12, 2010 at 02:33 PM
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
Posts
4
Registration date
Friday March 12, 2010
Status
Member
Last seen
March 12, 2010
Mar 12, 2010 at 02:39 PM
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 12, 2010 at 02:44 PM
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
Posts
4
Registration date
Friday March 12, 2010
Status
Member
Last seen
March 12, 2010
Mar 12, 2010 at 02:47 PM
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