esProc Desktopesproc-desktop.hashnode.dev·Nov 18, 2024#98 — Count Duplicates of Row-Based Data — by Key ColumnProblem description & analysis: Here below is a personnel data table: Task: Count the number of duplicate data (the judging basis is that the data in the Name field are the same). Solution: Use SPL XLL and enter the formula in the cell E2: =spl("=?1...10 likes#Excel-tutorialAdd a thoughtful commentNo comments yetBe the first to start the conversation.
