Feed
Pro
Search

Sign in
FactoryKit - the AI software factory: tasks in, pull requests out Bug0 - The AI-native e2e QA regression testing The foreword by Hashnode - official blog from the Hashnode team Passmark - The open-source AI framework for regression testing Hashnode gql skill - let your AI agent publish to your Hashnode blog Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

FeedDiscussion

esProc

Nov 15, 2024

#97 — Count Duplicates of Simple Members

Problem 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...

esproc-desktop.hashnode.dev1 min read

#excel #excel-sheets #productivity #programming-blogs #coding #codenewbies #learn-coding #vba #data-science #data-analysis

Responses

esProc

Feel free to ask away your Excel tasks and we are here to help:

🙌🏻Discord:discord.gg/cFTcUNs7 🙌🏻Reddit: reddit.com/r/esProc_Desktop