5

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.

Improve this question
3
  • Can you share a doc with us?
    – Jacob Jan Tuinstra
    Jan 28, 2013 at 6:49
  • 1
    Yes, I'll just need a few hours, please check back in about a day.
    – John K.
    Jan 28, 2013 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, 2013 at 4:11

1 Answer 1

Reset to default
4

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.

Improve this answer
1
  • 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, 2013 at 3:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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