Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter list and delete
I have two sets of transaction receipts that I would like to filter? or
whatever, in order to delete some transactions. The data are in columns (assume Column E and Row 2). The particular transactions I would like to delete are the transactions that are for a zero (0) amount. The column is formatted for numbers with no decimal points. I figure I might have to have one of those "IF" statements but I am unsure how to do it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter list and delete
Column E and Row 2??
If you have two columns w/transaction amounts and want to delete those where both are zero, filter both columns for zero and delete the results (you can delete the entire row so when you turn off autofilter there are no gaps in your data). If it is an OR situation, filter one column at a time and delete the data. Either way be sure to back up your data. "OfficeNDN" wrote: I have two sets of transaction receipts that I would like to filter? or whatever, in order to delete some transactions. The data are in columns (assume Column E and Row 2). The particular transactions I would like to delete are the transactions that are for a zero (0) amount. The column is formatted for numbers with no decimal points. I figure I might have to have one of those "IF" statements but I am unsure how to do it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter list and delete
Is there a formula or function that would do the filtering for me? All this
editing of my data takes a long long time. "JMB" wrote: Column E and Row 2?? If you have two columns w/transaction amounts and want to delete those where both are zero, filter both columns for zero and delete the results (you can delete the entire row so when you turn off autofilter there are no gaps in your data). If it is an OR situation, filter one column at a time and delete the data. Either way be sure to back up your data. "OfficeNDN" wrote: I have two sets of transaction receipts that I would like to filter? or whatever, in order to delete some transactions. The data are in columns (assume Column E and Row 2). The particular transactions I would like to delete are the transactions that are for a zero (0) amount. The column is formatted for numbers with no decimal points. I figure I might have to have one of those "IF" statements but I am unsure how to do it. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter list and delete
I've noticed that using the filter tends to cause Excel to recalculate.
Maybe try setting calculation to manual (Tools/Options/Calcuation) before filtering. "OfficeNDN" wrote: Is there a formula or function that would do the filtering for me? All this editing of my data takes a long long time. "JMB" wrote: Column E and Row 2?? If you have two columns w/transaction amounts and want to delete those where both are zero, filter both columns for zero and delete the results (you can delete the entire row so when you turn off autofilter there are no gaps in your data). If it is an OR situation, filter one column at a time and delete the data. Either way be sure to back up your data. "OfficeNDN" wrote: I have two sets of transaction receipts that I would like to filter? or whatever, in order to delete some transactions. The data are in columns (assume Column E and Row 2). The particular transactions I would like to delete are the transactions that are for a zero (0) amount. The column is formatted for numbers with no decimal points. I figure I might have to have one of those "IF" statements but I am unsure how to do it. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter list and delete
Thank you it worked fine
I did a macro so that I won't have to go in and do it by myself every time I have to filter. "JMB" wrote: I've noticed that using the filter tends to cause Excel to recalculate. Maybe try setting calculation to manual (Tools/Options/Calcuation) before filtering. "OfficeNDN" wrote: Is there a formula or function that would do the filtering for me? All this editing of my data takes a long long time. "JMB" wrote: Column E and Row 2?? If you have two columns w/transaction amounts and want to delete those where both are zero, filter both columns for zero and delete the results (you can delete the entire row so when you turn off autofilter there are no gaps in your data). If it is an OR situation, filter one column at a time and delete the data. Either way be sure to back up your data. "OfficeNDN" wrote: I have two sets of transaction receipts that I would like to filter? or whatever, in order to delete some transactions. The data are in columns (assume Column E and Row 2). The particular transactions I would like to delete are the transactions that are for a zero (0) amount. The column is formatted for numbers with no decimal points. I figure I might have to have one of those "IF" statements but I am unsure how to do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula/Macro to delete rows that do not meet criteria from a list? | Excel Worksheet Functions | |||
Excel 2007 B2 - Selecting every cell that starts with a certain word | Excel Discussion (Misc queries) | |||
How do i delete data from a main xl list using another xl list??? | Excel Discussion (Misc queries) | |||
How do I delete items in one list from another list? | Excel Discussion (Misc queries) | |||
How do I delete a drop list button | Excel Worksheet Functions |