Need some more Excel help....

[EQTitan]

I'm currently running a spreadsheet for Warcrows contest of numbers people have guessed as well as how many duplicate numbers have been posted.

What I would like to do now is have a formula sort out what number have been guessed and give me a list of numbers that are still available. Then I'd like to be able to get a total count of how many duplicate guesses there are.

Thanks

 

[Malak]

Way beyond my knowledge, not even sure if that's all possible.