PDA

View Full Version : Drop Down Menus to Return Multiple Results



SWExcelBeginner
2016-12-02, 06:16 PM
Good Morning,

I am trying to complete a report that will show, by department, all employees who have spent the most in travel expenses. This is by far the most complex report I will have completed, and am having trouble learning how to design a drop down list, in which someone could select a department number, and their selection will return the top five spenders within that department.

There are over 3,000 employees, and the excel report is referencing an employee roster, and about ten other data sets that report on monthly travel spend.

Here is a snippet of the employee roster.




EE#
Last
GL Code


11434
Aasen
512


12486
Abadilla
650


7411
Abend
522


12221
Abernathy
665


13867
Abraham
681


13698
Abusharkh
665


6244
Achacoso
552


10604
Acoba
512


8759
Adams
512


11109
Adams
512


11940
Adams
552


12603
Adams
520


13887
Adams
512


11777
Addler
552


10097
Adiutori
552


13613
Afu
622


10153
Agaran
531


13426
Agarwal
690


11724
Agnew
686


11431
Agostino
512


11839
Agpaoa
552


7549
Aguas
520


12383
Aguilar
552


9858
Agustin
552


10502
Ahmad
535


10718
Ainley
520


13597
Aitouyahia
645


8788
Alberti
622


12162
Albright
650


13024
Alexander
511


8766
Alf
552


12280
Alfarah
461


12747
Alford Jr.
645


13369
Ali
552









Thank you!!
Sadie

navic
2016-12-02, 07:12 PM
try, return top values in helper column and pull drop-down menu

=LARGE(range;ROW(A1))
copy down (5 cells)