The story
A reference to the fictional detective Sherlock Holmes, suggesting that the interlocutor has just made an obvious deduction, which they see as a great one.
Etymology from Wiktionary, CC BY-SA 4.0.
no shit, Sherlock
Today it means: A retort to someone who has just said something obvious. Full definition →