Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If Statement help (I think)
What statement would I use if I want to search a exce data base and find all
rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd |
#2
|
|||
|
|||
Hi Todd
This depends on Why and How Often. But I'd go menu Data Filter Atrofilter, then choose X in the column dropdown that appear in the column header cell. from there copy-paste, subtotal or whatever I want done. Another approach is to create a Pivot Table with the column in question as a page field. HTH. Best wishes Harald "Toddmend" skrev i melding ... What statement would I use if I want to search a exce data base and find all rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd |
#3
|
|||
|
|||
One way
Use DataFilterAutofilter Select the drop down on the column containing your "X's" and select X Select the filtered set of rows and Copy to your other sheet. -- Regards Roger Govier "Toddmend" wrote in message ... What statement would I use if I want to search a exce data base and find all rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd |
#4
|
|||
|
|||
But I want this database to be an ongoing one where I won't have to cut and
paste somethign every time I change the main database. So in theory I would like to add rows of data to the database, and if one specific colum shows up with "X" it will automatically copy it to the "X" file which is a seperate file. The reason is I want a seperate file to see every row, and all of it for the rows that contain "X" in that one column. -- Todd "Harald Staff" wrote: Hi Todd This depends on Why and How Often. But I'd go menu Data Filter Atrofilter, then choose X in the column dropdown that appear in the column header cell. from there copy-paste, subtotal or whatever I want done. Another approach is to create a Pivot Table with the column in question as a page field. HTH. Best wishes Harald "Toddmend" skrev i melding ... What statement would I use if I want to search a exce data base and find all rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement | New Users to Excel | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |