Problem Sorting Data

This should work for you.

Thx Flint, I tried your suggestion with the actual data & no go. When I tried copy/pasting the formulas, I recieved REF errors, & when I tried using the actual sheet sent as an example, substituting the Supervisors & Employee names it it also failed to sort.

This was probably my fault, unlike the example sent there are 5 Supervisors with a total of 40 employees to be assigned. The employees indicate their Supervisors using a drop-down option on each sheet of the workbook. (This Summary will -if I ever get it to work- appear on the last page.)

Again I appreciate your effort, I've been stuck on this for about a 2 weeks, & have started searching through Excel VB manuals, trying to come up with a solution. When I originally posted I didn't think it was that difficult a problem, sorting through a list of names, but apparently it's quite a challenge. I've tried several groups & so far your the only one who has come up with an idea which works at all. Several formulas I've recieved just didn't function, & I recieved a 'nasty' email over my choice of verbage, saying what I requested had nothing to do with sorting.

Again thank you, if you wish I can post the actual worksheet (Due to security considerations, it's for a public school, I'm unable to post the entire workbook) if you think that will make things easier.

Alhazred, glad to be of help.

If you could post a working worksheet (substituting actual data of course), I’m certain this can work for you.

Just an update the problem with the formula sent:

=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2))

As mentioned earlier, the Supervisor entries are gathered from drop downs throughout the workbook. So the above just returns REF, & VALUE errors

Alhazred:

The formula you sent is an array formula and must be entered with Ctrl+Shift+Enter, this is exactly what you are asking for.

Paste the formula in cell A22 and enter it with the keys Ctrl+Shift+Enter, fill down.

Please Login or Register  to view this content.

Notice the reference =$A$21 within the formula, this is the name of the Supervisor in question.

Matt

Again thx Matt, I've been working on this all day with nothing to show for it. Your right the formula does work, if the cells don't reference another sheet, but if they do, well.....see attached.

As you suggested here's a copy of the actual work sheets, & summary page. I've pared it down to about 4 employees, but I think you can see the pattern.

The irony is the pairing of Supervisor to Employees, is only an interm step, to help sort out the data for the final summary. Any suggestions you may have, short of hitting the computer with something heavy, I already thought of that, are greatly appreciated.

I'm trying to create a formula to come up with overall scores for student's 4 exam's. The first three exams were worth 20% each and the last exam was worth 40%. I'm dying here. Any help would be awsome, thanks

Originally Posted by Colsey

I'm trying to create a formula to come up with overall scores for student's 4 exam's. The first three exams were worth 20% each and the last exam was worth 40%. I'm dying here. Any help would be awsome, thanks

Hi Colsey, you may want to ask in the 'General Help' Section. Good luck.

Read Problems Suggestions sheet; I hope this is it.

Matt, I can't thank you enough.

I've attached an example of my most current workbook (I've pared it down to 3 employees). I managed to get it but....as you look at it, you'll notice just how hard it was (It took me 6 Steps!!!) Please be kind, & keep in mind my inexperience with excel, & going forward I'll be using your solution.

The only thing left to do is gather the Data for the Team Sheet (Long D. - JMS, RM, Live, QA, Cal/ Wireless, JMS, RM, Live, etc.) Good News is all the information is in the same cells (LD D22 to C22, Wireless D31 to C31, etc) on each sheet. As mentioned earlier the gathering of Agents into teams was an interm step, which will allow me to locate the right agent & thus the correct info for the Team summary.

As always if you have any ideas on the best way (most certainly not the 1st thing I think of....lol) on how to collect the data for the Summary they'd be appreciated. - Rob

Rob, I've made a few changes.