使用过滤器和排序在一起的Google工作表 [英] Google sheets using Filter and Sort together
问题描述
这是我的第一个问题.我希望可以. 我是使用Google表格的新手,但是我的进度很慢.
This is my first question here. I hope it's ok. I'm a bit of a newbie using google sheets but I'm slowly progressing.
我正在尝试使用工作表1中的所有数据来构建工作表. 在工作表2上,我想过滤工作表2中在D列中标记为数字"1"的所有数据. 为此,我正在使用
I'm trying to build a sheet with all my data in sheet 1. On sheet 2 I would like to Filter all the data from sheet 2 that is marked with the number "1" in column D. For that purpose, I'm using
=FILTER('Ark1'!A2:C999; 'Ark1'!D2:D999=1)
到目前为止,一切都很好.可以.
So far so good. It works.
然后,我想根据E列中的值对该表进行排序. 为此,我正在使用
Then I would like to sort this sheet based on the value in column E. For that purpose, I'm using
=sort(FILTER('Ark1'!A2:C999; 'Ark1'!D2:D999=1);'Ark1'!E2:E999; SAND)
我收到一个I/T错误.用丹麦语说:
I get an I/T error. In danish it says:
SORT har forskelligeintervaltørrelser. Forventede 2rækkerog 1 kolonner,男性独立998rækkerog 1 kolonner.
SORT har forskellige intervalstørrelser. Forventede 2 rækker og 1 kolonner, men indeholder 998 rækker og 1 kolonner.
Google翻译为:
Google translated to:
SORT具有不同的范围大小.预期为2行1列,但包含998行1列.
SORT has different range sizes. Expected 2 rows and 1 columns, but contains 998 rows and 1 columns.
我在这里有工作表的副本,该副本可编辑以帮助您. https://docs.google.com/spreadsheets/d/1Eh8aBnXH-SbqHyuvvmaCMc9eoNwZvoAtulxeJXB5-bE/edit?usp = sharing
I have a copy of the sheet here which is editable for your help. https://docs.google.com/spreadsheets/d/1Eh8aBnXH-SbqHyuvvmaCMc9eoNwZvoAtulxeJXB5-bE/edit?usp=sharing
非常感谢您的帮助.
推荐答案
使用:
=SORT(FILTER('Ark1'!A2:C999; 'Ark1'!D2:D999=1); 5; 0)
或:
=SORT(FILTER('Ark1'!A2:C999; 'Ark1'!D2:D999=1); 5; 1)
这篇关于使用过滤器和排序在一起的Google工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!