Excel- find top three

April 1, 2011 at 06:56:16
Specs: Windows XP
Please help!!

I have a spread sheet that has the headers First Name, Last Name, Crew, and Month (i.e. Jan, Feb, Mar, etc). The combination of first and last names are not repeated. A number value is entered next to the name under the specific month and the crew is a single letter.

I would like to use a formula that would show the top three names based on the number unter the month (i.e. Jan) and the crew they are assigned to.


See More: Excel- find top three

Report •

#1
April 1, 2011 at 07:26:31
I would like to use a formula that would show the top three names based on the number unter the month

Why not just Sort on the value?

MIKE

http://www.skeptic.com/


Report •

#2
April 1, 2011 at 07:57:23
You bring up a great point. This is a matrix for the members of the Safety Team to track participation and such with one of our programs. The list has over 200 employees and for those of us that work within excel, sorting and filtering would be easy...however that is not the case with most of our employees and especially the team members (we are a manufacturing facility). Not only would it reduce the liklihood of things being messed up if the names just appeared in a chart that could easily be copied and pasted in meeting minues, to the plant portal page, etc. but it would save me time from having to explain to a team member (since we rotate responsibilities) every other week how to sort, etc. Everyone is some what familiar with copy/paste.


Report •

#3
April 1, 2011 at 09:15:00
Make a macro assign it to a button, then just have them hit the button?

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
April 1, 2011 at 10:33:35
I am horrible at macros but I will try that. Thanks!

Report •

#5
April 1, 2011 at 10:45:57
Try this:


First create your Macro:

On the Task Bar,
Select Tools,
Select Macro,
Record New Macro,

A small window should open,
Give the Macro an appropriate name, like “MySort”
Click OK

A small box with the word “Stop” should appear.
If it does not don’t worry, will take care of it later.

Sort your sheet in the manner you wish it to be sorted.

When you done,.
Click the “Stop” button to end the macro.
If there is no Stop button, then, On the Task Bar
Select Tools,
Select Macro
Click on Stop Recording Macro


Create a button for the macro

On the Task Bar
Select Tools,
Select Customize

In the small window, under “Categories”,
Scroll down and click on “Macros”
The right panel should change and there should be a smiley face next to “Custom Button”
Left click on the smiley face, hold and drag up to the Task Bar and let go.
Where, on the Task Bar, you put it is up to you. I usually place it on the far left or next to the Help button.

Click “Close” on the small window.

Next, click on the smiley face button and another window opens that reads “Assign Macro”
Find your “MySort” macro and double click and your done.

MIKE

http://www.skeptic.com/


Report •

Ask Question