如何在选择下拉列表时获取匹配行的数量。 [英] How to get count of matching rows on selection of drop down.
问题描述
嗨专家,
由于我是excel的新手,我不知道如何根据excel中的下拉列表中的两个值来获取记录数。
我的擅长是
日期05/04/2016 //这是第一次下拉
时间11:00 AM //这是第二次下拉
结果...... //这里我需要基于上面的匹配记录数选定的值。
sn约会时间
1 05/04/2016 11:00
2 05/04/2016 11:00Am
3 05/04/2016 11:00Am
1 06/04/2016 11:00Am
结果应为3
提前致谢
mukesh prasad
我的尝试:
我没有尝试过,因为我对excel完全不了解。
尝试CountIf或CountIfs 函数。
他们计算记录(将它们放在函数范围内)与下拉框匹配(将这些记录放在标准中)。
Hi Experts,
As I am new for excel I don't know how to get count of records on the basis of two values from dropdown in excel.
My excel is
Date 05/04/2016 // This is first dropdown
Time 11:00AM // This is second dropdown
result ...... //here I need count of matching records based on above selected values.
s.n. date time
1 05/04/2016 11:00Am
2 05/04/2016 11:00Am
3 05/04/2016 11:00Am
1 06/04/2016 11:00Am
Then result should be 3
Thanks in advance
mukesh prasad
What I have tried:
I have tried nothing as i am completely unknown about excel.
Try "CountIf" or "CountIfs" functions.
They count the records (put them in the range for the function) in the that match your drop-down boxes (put these in the criteria).
这篇关于如何在选择下拉列表时获取匹配行的数量。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!