一个单元格中多个标准的Excel匹配指标 [英] Excel Match Index for Mutliple Criteria in one cell
问题描述
然后我有下拉框通过数据验证)来筛选结果并给出最佳结果。然而,当涉及到选择位置时,我可以选择ALL,IND,ENG,USA或IND;#ENG;#USA。如果我选择了IND,那么多个地方的选项将不会被返回(只有IND中的选项才会)。
我是只是想知道是否有任何方法,避免VBA,这将使得可以选择个人位置来返回此位置的所有选项,包括在多个位置可用的选项。
**请注意,这些多个位置包含在SAME单元格中。
这是不可能的,因为你有问题写的。通过数据验证创建的下拉列表只能显示单个结果。如果您选择IND,并想要显示IND和IND,ENG的结果,则需要使用除下拉列表之外的其他内容,或者您需要根据您在代码/逻辑。
我会说你最好的选择是使用VBA。这可以从用户透明。当用户在下拉列表中选择一个值时,vba可以根据所选择的(也称为依赖下拉列表)对剩余的下拉列表进行排序和过滤。
I have a spreadsheet which is filled automatically from data in Microsoft Sharepoint. Unfortunately this data fills my location column as follows: IND;# ENG ;# USA if for example that particular input has 3 locations.
I then have drop down boxes (made via data validation) to filter the results down and give an optimum result. However when it comes to choosing location i can either choose ALL, IND, ENG, USA OR IND;# ENG ;# USA. If I chose, for instance, IND, then the options that are in multiple locations will not be returned (only the options that are in only IND will).
I was just wondering if there is any way, avoiding VBA, which will enable a choice of the individual location to return all options in this location, including the options that are availible in multiple locations.
** Please note that these multiple locations are contained within the SAME cell.
It's not possible as you have the question written. A drop down list created by data validation can only display a single result. If you chose 'IND' and wanted to show results for say 'IND' and 'IND, ENG' you would need to use something other than a drop down list or you need to do additional filtering based on the value selected down stream in your code/logic.
I'd say your best bet is to use VBA. This can be transparent from the user. When a user selects a value in the drop down list, vba can sort and filter the remaining drop down list based on what was selected (aka dependent drop downs)
这篇关于一个单元格中多个标准的Excel匹配指标的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!