Pull in data from store sheets into master ranking sheet

Woodpusher147

New Member
Joined
Oct 6, 2021
Messages
38
Office Version
  1. 365
Platform
  1. Windows
Hello
I hope someone can help with a task I need to complete

I have 4 sheets that represent 4 stores and need to pull 3 columns from these sheets depending on what department they state in column D.
Below is a snip of one of the stores
1634028140060.png

Column C = Staff Name
Column D = Department and is a dropdown list "Bedroom", "Upstairs" & "Downstairs"
Column E = Total points

I need to rank ALL staff in a separate sheet by department
e.g. grab all names and scores from Store 1, Store2 , Store3 and Store4 sheets that are on a row where column D contains "Bedroom" and then rank them by column E (points)
If it is possible, I would also like the rows to show WHICH store/sheet name the member of staff came from
This needs to be done for all 3 departments

I envisage the results to look like the below
1634028921455.png

The above could be on one sheet named "Bedroom" or all 3 departments could be ranked on one sheet called "Leaderboard" or something like.


I hope thats clear and thank you for any help

Simon
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,148,277
Messages
5,745,816
Members
423,980
Latest member
zimza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top