When you spend money on Hextech Crafting, but end up rolling a skin that you already own

Yes. It's completely random what you will get, since even a useless shard can be scrapped into essence and then spent on something you can actually use.