• 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.

List exits for the month

Status
Not open for further replies.

archanair

New Member
Sheet 1: Dashboard
Sheet 2:US India employee list

What is required?
Based on the entry in the dashboard for the year and month I need to retrieve the list of exited employees from the master sheet(Sheet 2).
eg. If we select year as "2022" in cell O26 and month as "Jan" in cell O27 my formula should be able to retrieve the list of exited employees who exited in Jan 2022 from Sheet 2 and list in sheet 1 in the below format.
NamesLeaving DateExit TypeRegion


Cell Values
In Sheet 2 which is the master sheet below columns have the exit data
Column V: Date of Leaving
Column W : Year of Leaving
Column X: Exit Type
Column B:Region


Sample File link :https://docs.google.com/spreadsheets/d/1jLGvwH3O62Yft8jtuznQ6r4f7xyvRWQq/edit#gid=2138561937


Please Help!
 
archanair
Why did You duplicate Your thread?
Above's title gives image about week
but
It's writing gives image about today
and
this writings gives image about week ...
You're asking solution for Google Sheets from Excel Dashboard -forum based Excel ... hmm?
You should continue with Your original thread.
This duplicated thread is closed.
 
Status
Not open for further replies.
Back
Top