esProc Desktopesproc-desktop.hashnode.dev·Nov 15, 2024#97 — Count Duplicates of Simple MembersProblem description & analysis: Here below is a data table of names: Task: Count the number of duplicate names. Solution: Use SPL XLL and enter the formula in cell B2: =spl("=?1.conj().select(~==?2).count()",A$2:A$6,A2) Download esProc Desktop fo...10 likesexcelAdd a thoughtful commentNo comments yetBe the first to start the conversation.
