Average Rank for Similar Datasets over Time

[mattynice_]

Hey everyone first post, hoping someone can help me out.

I'm trying to sort the highest priority items in multiple columns, they are similar lists of items prioritized at different times.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Priority Items[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Item A[/TD]
[TD]Item A[/TD]
[TD]Item C[/TD]
[TD]Item C[/TD]
[TD]Item D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Item B[/TD]
[TD]Item E[/TD]
[TD]Item B[/TD]
[TD]Item A[/TD]
[TD]Item B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Item C[/TD]
[TD]Item C[/TD]
[TD]Item E[/TD]
[TD]Item B[/TD]
[TD]Item G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Item D[/TD]
[TD]Item B[/TD]
[TD]Item D[/TD]
[TD]Item F[/TD]
[TD]Item E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Item E[/TD]
[TD]Item D[/TD]
[TD]Item A[/TD]
[TD]Item E[/TD]
[TD]Item C[/TD]
[/TR]
</tbody>[/TABLE]


I'd like column 1 to compare the rankings for each item in columns 2-5, then return the Items in descending order based on their average rank. Thanks so much for taking a look at this!