Thank you very much for your reply. It is appreciated.
All of these are very interesting and helpful for creating sets with Top Ns and/or ranking. However (unless I am missing something), this doesn't seem to address my larger question. The end result I need is a Top 3 (that recognizes dense ties) the result of which can be used in a series of calculated fields for a different sheet entirely. Here are the methods I've tried (and the problems that resulted):
1.) I can create a Set using Top Ns (limited to 3) to use for a calculation. I can then use this calculation in my other layered calculations. What I can't do however is, is set it up so that it recognizes ties within that Top 3 (so that, say if the third and fourth one are tied, both are considered members of that Set).
2.) Alternatively, I can use a Rank table calculation so that I can retain ties (specifically dense ties), but because it is a table calculation I can't use the result of that rank table calculation in the calculations necessary for my other sheet (because that data doesn't exist in the that form for the table calculation to run properly in that second sheet).
So, is there a way to either a) get ties to be included within a Top N Set or b) a way to do ranking without using a table calculation (so that the result can be used in calculations for a different sheet with a different set up)? Or, is there another way entirely to achieve what I am looking for that I just haven't thought of?