I think this is correct now. It seems a bit pointless having the two sheets though? And I assume the bottom table on Data2 where it just shows Name and # Assigned it just for display purposes and isn't meant to be in in any calculations, correct?

What I changed was that the formulas in Data2 were not being associated to the adjacent person's name so of course when sorting occured things would not match. Also, and this has no effect but just an FYI, your Data2 had formulas for Data!A2 instead of just A2, which usually highlights itself in blue in the formula itself you will notice on the original you uploaded.

Attached Files

SampleData_rev1.xls (26.5 KB, 15 views)

Thanks for your help! First off, yes, all the data was for demonstrational purposes -- the real problem is on a work file. I wanted to display the metric data (whatever that happens to be) on a separate tab, separate from the raw data.

It's still really weird. Basically, if you take the "Data2!" out of the formulas on the Data2 tab, it works. When I initially created the formulas, the "Data2!" was automatically populated by Excel.

Anyways, it's working and I'll just have to keep a note of this Excel quirk.

I'm sorry I made a typo which might be confusing. My FYI should have said there were unnecessary references to Data2!A2 (for example) in the Data2 sheet. The sheet name doesn't need to be referenced when refering to a cell within the sheet the formula is in... Anyway you know all that.