esProc Desktopesproc-desktop.hashnode.dev·2 hours ago#102 — Deduplication of Simple Data — Keeping the Original OrderProblem description & analysis: There is a data table: Task: Duplicate the data and keep the original order. Solution: Use SPL XLL and enter the following formula: =spl("=?1.id@u()",A2:A17) The results are as follows: Download esProc Desktop for ...Discuss·10 likesexcel
Abhishek Sharmaabhisheksharmacodes.hashnode.dev·20 hours agoAre developers not that much happy?The 2024 Stack Overflow Developer Survey has revealed a startling statistic: only 20% of developers are happy in their current roles. This alarming figure underscores a growing issue within the tech industry, prompting a deeper look into the factors ...DiscussDevops
esProc Desktopesproc-desktop.hashnode.dev·Nov 21, 2024#101 - Deduplication of Row-Based Data - by Whole RowProblem description & analysis: There is a data table: Task: Find out the whole-row data that are not duplicate and the first duplicate whole-row data. Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(ID,Name,Gender,Birthday...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 20, 2024#100 — Deduplication of Row-Based Data — by Key ColumnProblem description & analysis: There is a data table: Task: Find out the data that are not duplicates and the first duplicate data in the Name column. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).group(Name).(~(1))",A1:D7) The ...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 19, 2024#99 — Deduplication of Simple DataProblem description & analysis: There is a data table: Task: We want to duplicate the data. Solution: Use SPL XLL and enter the following formula: =spl("=?1.id()",A2:A17) Download esProc Desktop for FREE and level up your Excel game!!! 🚀🔥⬇️ ✨SP...Discuss·10 likesexcel
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...Discuss·10 likes#Excel-tutorial
Sabelo Mkhizeblackowl.hashnode.dev·Nov 17, 2024From Physics to Code: My journey into Software development - update 2Some wisdom I can share is that, when you start in a space where you are a complete novice, it's important to embrace your lack of knowledge. This mindset will help you remain open to new information and foster curiosity, which are essential for grow...Discuss·1 likesoftware development
Gedion Danielblog.gediondaniel.dev·Nov 16, 2024Getting Started with AWS CodeCommit: A Developer's Guide to Secure Git RepositoriesIntroduction If you've been using GitHub or GitLab, but want to keep your code entirely within the AWS ecosystem, AWS CodeCommit is your answer. It's a fully-managed source control service that hosts secure Git repositories. Let's dive into how to ge...DiscussAWS
Amit Mauryaamitmaurya.hashnode.dev·Nov 16, 2024End-to-End DevOps for a Golang Web App: Docker, EKS, AWS CI/CDIn this article, we are going to learn how to deploy Golang application end to end with on AWS EKS (Elastic Kubernetes Service) with AWS CI/CD. This will enhance your skills and you can add this project in your resume. Before heading to Introduction ...DiscussDevOps ProjectsDevops
SATYAsatya01.hashnode.dev·Nov 15, 2024Typescript Advanced APIsHello Readers, this blog explains some of the Typescript advanced apis. If you are already familiar with typescript, knowing these advanced apis will unlock much more potential for you to write better code. Before diving into the main topic, first le...DiscussTypeScript
