Counting and Ranking unique IDs

I am looking to Count and Rank unique IDs associated with one unique value. This table from another post is very close to what i'm looking to do. However, I keep getting the error "Earlier/Earliest r...