Help Needed with Writing Top 3 and Bottom 3 Formula

I am having trouble trying to figure out how I would have Excel grab top 3 and bottom 3 from a set of raw data.

For example, I have raw data containing Student's Name, Student's Grade, Student's Class Size, Grade Date, and Student Feedback. I have another data set with the Student's Class Size Preference.

I want a report that pulls out the Student's top 3 and bottom 3 scores and feedback only if Grade Date range is (ex: 9-1/2017 - 9/30/2017) and if Student's Class Size is greater or equal to their Class Size Preference.

Help much appreciated.

Dummy Data: https://www.dropbox.com/s/6xkahig05r...mple.xlsx?dl=0.

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Having said that, take a look at the LARGE and SMALL functions

Originally Posted by Moonhana

Thanks Ford. I was not able to upload to forum. So I linked it to DropBox.........

Moonhana many of us are reluctant to download from 3rd party sites. You are better off uploading directly to the forum.

If you used the paperclip icon to upload that hasn't worked for some time.

Try these steps one more time.
To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.