# 匹配多个符合相同条件的结果。

go评论41阅读模式

Match several results with same conditions

# 问题

The aim of my workbook is to show result from a spreadsheet, after applying filters.

I get my spreadsheet in range `A1:C13`,

in column E, thanks to the Yellow formula,
It shows every Done date by unsorted.

The problem is that I want to show relative Name in column F. But there is some equals dates for different names,

My reflex where to do an Index Match, but it can't show when there is several results from the same conditions.

Any ideas ?

The aim of my workbook is to show result from a spreadsheet, after applying filters.

In this example,
I get my spreadsheet in range `A1:C13`,

in column E, thanks to the Yellow formula,
It shows every Done date by unsorted.

The problem is that I want to show relative Name in column F. But there is some equals dates for different names,

My reflex where to do an Index Match, but it can't show when there is several results from the same conditions.

Any ideas ?

# 答案1

Change your formula to include the Name column in the output:

=将您的公式更改为在输出中包含"Name"列：

=SORT(FILTER(Table2[[Date]:[Name]],Table2[Statut]=E1),1,-1)

=如果您的数据不是紧邻在一起，且不希望在输出中显示中间列，那么我们可以使用相同的公式包裹在INDEX函数中，以返回数组的正确列：

=INDEX(SORT(FILTER(Table2[[Date]:[Name]],Table2[Statut]=F1),1,-1),0,1)

=INDEX(SORT(FILTER(Table2[[Date]:[Name]],Table2[Statut]=F1),1,-1),0,3)

Change your formula to include the Name column in the output:

``````=SORT(FILTER(Table2[[Date]:[Name]],Table2[Statut]=E1),1,-1)
``````

If your data is not right next to each other and you do not want the middle columns to show in your output then we use the same formula wrapped in INDEX to return the correct column of the array:

``````=INDEX(SORT(FILTER(Table2[[Date]:[Name]],Table2[Statut]=F1),1,-1),0,1)
``````

And

``````=INDEX(SORT(FILTER(Table2[[Date]:[Name]],Table2[Statut]=F1),1,-1),0,3)
``````

Where the ending `,1` in the first formula refers to the relative column in the referred to range of the date, and the `,3` in the second refers to the relative column in the referred to range of the Name

• 本文由 发表于 2020年1月6日 22:53:26
• 转载请务必保留本文链接：https://go.coder-hub.com/59614199.html
• excel
• excel-2016
• excel-formula

go 32

go 30

go 25

go 26