I have 2 drop down lists by using data validation . One for division and one for month. I successfully linked the division list to filter for division by using the filter function. But I don’t know how to add the second filter. The formula is = filter(requirement_1;requirement1[Division]=J62 requirement 1 is the name of the table. How do i add the second filter without errors
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Data table linked to 2 drop down lists
- Thread starter joand7123
- Start date
Excel Facts
How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
CA Vijay Gupta
New Member
- Joined
- Jun 22, 2020
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
= filter(requirement_1,(requirement1[Division]=J62)*requirement1[Month]=J63)
J63 = Cell Reference to 2nd Drop down of month
J63 = Cell Reference to 2nd Drop down of month
Upvote
0
Similar threads
- Replies
- 0
- Views
- 162
- Replies
- 2
- Views
- 199
- Question
- Replies
- 0
- Views
- 382
- Solved
- Replies
- 3
- Views
- 399
