Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
Hi. I have a table that contains data from row A-I. The values in row G
vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below ..05). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
datafilterautofiltercustom...
-- Don Guillett SalesAid Software "excelmybelle" wrote in message ... Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
Take a look at Data Filter AutoFilter Custom, on the column of
interest, then use "Greater than" or "lesser than" for a cirteria......then copy and paste the filtered results to another sheet. Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
Hmm, that is pretty much what I am doing now. I was just hoping there was a
way to automatically do it since this is a file that I have to update every week (and the values change every week). Thank you for your help though :) "CLR" wrote: Take a look at Data Filter AutoFilter Custom, on the column of interest, then use "Greater than" or "lesser than" for a cirteria......then copy and paste the filtered results to another sheet. Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
Once you have the procedure down pat, then it can be automated with macros to
run the AutoFilter under program control and get there with just a push of a button...... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hmm, that is pretty much what I am doing now. I was just hoping there was a way to automatically do it since this is a file that I have to update every week (and the values change every week). Thank you for your help though :) "CLR" wrote: Take a look at Data Filter AutoFilter Custom, on the column of interest, then use "Greater than" or "lesser than" for a cirteria......then copy and paste the filtered results to another sheet. Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
Oh! That is true! Let me give that a shot. Thanks :)
"CLR" wrote: Once you have the procedure down pat, then it can be automated with macros to run the AutoFilter under program control and get there with just a push of a button...... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hmm, that is pretty much what I am doing now. I was just hoping there was a way to automatically do it since this is a file that I have to update every week (and the values change every week). Thank you for your help though :) "CLR" wrote: Take a look at Data Filter AutoFilter Custom, on the column of interest, then use "Greater than" or "lesser than" for a cirteria......then copy and paste the filtered results to another sheet. Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
Good luck, and post back, either here or in the Programming group if you run
into any snags.......... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Oh! That is true! Let me give that a shot. Thanks :) "CLR" wrote: Once you have the procedure down pat, then it can be automated with macros to run the AutoFilter under program control and get there with just a push of a button...... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hmm, that is pretty much what I am doing now. I was just hoping there was a way to automatically do it since this is a file that I have to update every week (and the values change every week). Thank you for your help though :) "CLR" wrote: Take a look at Data Filter AutoFilter Custom, on the column of interest, then use "Greater than" or "lesser than" for a cirteria......then copy and paste the filtered results to another sheet. Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
Thanks. I just set it all up and it worked perfectly. Thanks for the
idea/help. "CLR" wrote: Good luck, and post back, either here or in the Programming group if you run into any snags.......... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Oh! That is true! Let me give that a shot. Thanks :) "CLR" wrote: Once you have the procedure down pat, then it can be automated with macros to run the AutoFilter under program control and get there with just a push of a button...... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hmm, that is pretty much what I am doing now. I was just hoping there was a way to automatically do it since this is a file that I have to update every week (and the values change every week). Thank you for your help though :) "CLR" wrote: Take a look at Data Filter AutoFilter Custom, on the column of interest, then use "Greater than" or "lesser than" for a cirteria......then copy and paste the filtered results to another sheet. Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove values under a certain value from a table?
You're quite welcome........glad to hear you were able to work it out.
Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Thanks. I just set it all up and it worked perfectly. Thanks for the idea/help. "CLR" wrote: Good luck, and post back, either here or in the Programming group if you run into any snags.......... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Oh! That is true! Let me give that a shot. Thanks :) "CLR" wrote: Once you have the procedure down pat, then it can be automated with macros to run the AutoFilter under program control and get there with just a push of a button...... Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hmm, that is pretty much what I am doing now. I was just hoping there was a way to automatically do it since this is a file that I have to update every week (and the values change every week). Thank you for your help though :) "CLR" wrote: Take a look at Data Filter AutoFilter Custom, on the column of interest, then use "Greater than" or "lesser than" for a cirteria......then copy and paste the filtered results to another sheet. Vaya con Dios, Chuck, CABGx3 "excelmybelle" wrote: Hi. I have a table that contains data from row A-I. The values in row G vary from 0 and up... what I would like to do is tell Excel for any value that is below .05 in row G, remove that line from the table and paste that data below the entire table (starting a new table of values that are below .05). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel calculate populate table using row/column values & calc's on other sheet? | Excel Discussion (Misc queries) | |||
Populating a table based on values in another table | Excel Worksheet Functions | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
how to remove "(All)" in a pivot table using VBA | Excel Discussion (Misc queries) |