probability of getting a pair in poker in excel

[k3j4h5g6]

I'm working on a probability problem related to poker, and I could really use some help with figuring out how to calculate it in Excel. Here’s the scenario:


In a game of poker, you're dealt 5 cards from a standard deck of 52 cards. I want to determine the probability of getting at least one pair (i.e., two cards of the same rank) in my hand.


I understand that this involves some combinatorial calculations, but I'm not sure how to set it up properly in Excel. I've been playing poker online and this question came up because I'm interested in evaluating my chances of winning. Could someone help me verify if this approach is correct and guide me on how to properly set up these calculations in Excel?