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

Help with Data Validation

X

xtr3m3dud3

New Member
Hello All,

I have attached a spreadsheet and looking for help in my dashboard that I am creating. I have tried to explain what I want in the same spreadsheet and it involves vlookup and validation.

Really need this on a super urgent basis so please help asap.

Thanks in advance.
 

Attachments

  • Attrition Sample.xlsx
    9 KB · Views: 5
Hi xtr3m3dud3,

Please see this file, does it help?
 

Attachments

  • Attrition Sample-Reworked.xlsx
    9.2 KB · Views: 11
Thanks, but can you modify this a little for me. What I would love to have is
1. Select a VP
2. Show all Managers coming under that VP (but the manager name should not be repeated)
3. Show all tech names besides the relevant managers
 
Good day xtr3m3dud3

"super urgent" to you only, members give time and help free of charge and also lead their own lives outside of Chandoo land, this forum works 24/7 and there are no paid dedicate members online all the time. Perhaps you should read the Key Masters post

http://chandoo.org/forum/threads/new-users-please-read.294/

What you are after is dependent Data Validation and you will find all you need here.

http://www.contextures.com/xlDataVal01.html.

Faseeh's has done the hard work. it would not take you to long to take it to the third level that you are asking for, after you have read the link.
 
You must log in or register to reply here.
Back
Top