Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have an 8 column spreadsheet.

I want to sort/filter based upon the value of the 4th column.

In a separate sheet within the same spreadsheet, I want to print a list of each row matching a speific condition set for that 4th column. That condition is if the 4th column value of a specific row is anything but zero (numbers).

In the separate sheet, I want to print a list of rows matching this condition, the third column of my original list containing the data from the the original sheet. In the second column, I want to print the value of the filter/sort field, the value that is in that 4th column of the original sheet.

In summary:

Sheet1: 4th column (is it anything other than zero, if so):

Sheet2: 2 columns, 1st column containing value of 3rd column from Sheet1, 2nd column containing the value from the 4th column of Sheet1.

No specific sort order needed, but definitely want to meet the specifications in the Summary above.

I have tried using =sort(Sheet1!C:D, 2, FALSE), but this prints a list of all rows, even the ones containing zero.

share|improve this question
    
Can you share a doc with us? –  Jacob Jan Tuinstra Jan 28 '13 at 6:49
1  
Yes, I'll just need a few hours, please check back in about a day. –  John K. Jan 28 '13 at 15:35
    
Sample Spreadsheet Here is a sample spreadsheet. you can edit, but keep in mind that the structure I have in place must remain. On the actual sheets, there are 10-15 summary cells at the bottom of the sheet that show totals of the columns and other data. –  John K. Jan 29 '13 at 4:11

1 Answer 1

up vote 2 down vote accepted

I've added the result of your question in the Google Spreadsheet you shared with us.
In the SUMMARY sheet I collected all data that fits the criterion D<>0, with the following formula:

=QUERY(DATA!A:D;"SELECT A,C,D WHERE D<>0")

I also added an ID number, for the two companies and added the column to the summary sheet. As you can see, this formula can be easily extended.

share|improve this answer
1  
This helped a lot. I now realize that I was not really looking for a sort, but rather a query of the data that meets my criteria. I specified the specific rows I wished to query, and it leaves out the summary data I did not need queried. –  John K. Jan 30 '13 at 3:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.