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
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.
Hello Gurus,
Need a little help here regarding data validation. I have a dataset from A2 till D18. Using data validation which has been placed at G2, H4 and I6 and probably some other function I want to extract only those fields that are corresponding to the selection.
For ex., If I select...
Hui, thanks for your reply....but the gaps are what I don't want to show up in my graph, I want to show only the data part and not the N/As. The N/As will always pop up at the bottom of my data range-I don't want to manually adjust the range of the graphs every time the data changes.......is it...
Hey guys, I am working on a dashboard in which I need a graph - the source data for this graph will be certain formulated fields and fields which are blank are shown as "--".
Problem - When I make the graph, it is also considering the formulated fields and showing blank fields in the graph and...