Hi,
Pretty simple task but I just dont have the time to do it.
If I keyed into a spreadsheet the result of three playing cards laid out in front of me (eg: Jack of hearts, Jack of diamonds, three of clubs) I would key in JH JD 3C into three cells next to eachother
I need a formula that will tell me if the result is a Royal Flush, Flush, straight, straight flush, one pair, three of a kind etc…. I can provide all of the possible results
The result will a one word answer in the format “straightflush” or “threeofakind”
Prefer if the formula is in excel but open to suggestions