Automate IDs Based on Tiers

[rosetc16]

Hi all,

I have attached my document with my desired result in the link below (I can't figure out how to add an excel document to this page). Below is a quick summary of what I'm looking to do (it's also in the document). I appreciate all your help and please let me know if you have any questions!

[TABLE="width: 345"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD="colspan: 5"]1. I want player's ID's to automatically populate in column B based on if they are the specific position and the speicifc tier found in the Data portion in columns P through T

2. I will use a vlookup to get the players name next to their ID, but I would love to add their comment (found in column T) to their name. If it isn't possible to add the comment, it's not a big deal.

3. If I decide to add another player to tier 2 to make 3 players in tier 2, I want the "tier 3" to move down one more cell so there is a space between tier 2 and 3.[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]


You can also find this post here: https://www.excelguru.ca/forums/showthread.php?8701-Automate-IDs-Based-on-Tiers&p=35763#post35763 (EXCEL DOCUMENT IS IN THIS LINK)