• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I need help with a formula

Alex_a

New Member
I have a list of employees with their hire and training dates for different departments. I need to use a drop box, select the date and department and populate the required fields in the second worksheet (dashboard). I know we can use a combination of index, match and row but I don't know how I can put them together ( I did index and match but when I select different month and department, the old employee population from the previous selection was not removed from the list, it needs to be refreshed for the new month and dept. selection). Thanks a lot.
 

Attachments

  • Copy of Employee Example.xlsx
    10.5 KB · Views: 6
Your thread title is extremely poor - practically everybody here needs help with a formula!!!

Provide a mock-up of what you want with results entered manually.
 
Some alternatives given, I hope you can all see them and use them.
1. Slicers on the table
2. Pivot with timeline+slicer
3. formula solution
 

Attachments

  • Copy of Copy of Employee Example.xlsx
    33.3 KB · Views: 8
Check this Formula Solution, Works fine according to your requirement.
=IFERROR(INDEX(Data!B$2:B$30,SMALL(IF((Data!$D$2:$D$30=$I$3)*(MONTH(Data!$E$2:$E$30)=MONTH($I$1)),ROW(Data!$B$2:$B$30)-ROW(Data!$B$1)),ROWS($B$6:B6))),"")
 

Attachments

  • Copy of Employee Example.xlsx
    13.4 KB · Views: 9
Back
Top