DEV Community

Judith-Excel-Sharing profile picture

Judith-Excel-Sharing

Experience the amazing potential of Excel powered by SPL XLL! esProc Desktop is an Excel auxiliary tool to analyze and process desktop data files, which is completely free to download and use.

In Excel, Concatenate the Top 3 Members in Each Group into a String

In Excel, Concatenate the Top 3 Members in Each Group into a String

6
Comments 3
1 min read

Want to connect with Judith-Excel-Sharing?

Create an account to connect with Judith-Excel-Sharing. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
In Excel, Expand All Combinations of Multiple Columns

In Excel, Expand All Combinations of Multiple Columns

5
Comments 2
1 min read
In Excel, Generate a List of All Days of the Month Where a Specified Data Belongs

In Excel, Generate a List of All Days of the Month Where a Specified Data Belongs

5
Comments 2
3 min read
In Excel, Enter Values of the same Category in Cells on the Right of the Grouping Cell in Order

In Excel, Enter Values of the same Category in Cells on the Right of the Grouping Cell in Order

5
Comments 2
1 min read
In Excel, Combine Every N Row into A New Row

In Excel, Combine Every N Row into A New Row

7
Comments 6
1 min read
In Excel Crosstab, Transpose Cross Cells to Columns and Rows to Cross Cells Respectively

In Excel Crosstab, Transpose Cross Cells to Columns and Rows to Cross Cells Respectively

5
Comments 2
1 min read
Excel Perform COUNT on Each Category and Concatenate Results into a String

Excel Perform COUNT on Each Category and Concatenate Results into a String

3
Comments 2
1 min read
In Excel, Align Every Two Columns to Present Them While Setting Missing Values as 0

In Excel, Align Every Two Columns to Present Them While Setting Missing Values as 0

6
Comments 3
3 min read
In Excel, Insert Group Headers to Detail Data Rows in Each Group

In Excel, Insert Group Headers to Detail Data Rows in Each Group

9
Comments 1
3 min read
Actually, you will never be able to master Python

Actually, you will never be able to master Python

Comments
7 min read
ReportLite Practice: Multi-layered cross-reports with complex formats

ReportLite Practice: Multi-layered cross-reports with complex formats

Comments
3 min read
How to do Excel table association – You are out if you know only VLOOKUP

How to do Excel table association – You are out if you know only VLOOKUP

Comments
4 min read
SPL XLL Practice: Almighty Text Splitting in Excel

SPL XLL Practice: Almighty Text Splitting in Excel

Comments
5 min read
SPL XLL Practice: Excel Interval Association

SPL XLL Practice: Excel Interval Association

Comments
3 min read
Excel Advanced Group and Summary Method

Excel Advanced Group and Summary Method

Comments
5 min read
How to Automatically Extract Eligible Rows in Excel

How to Automatically Extract Eligible Rows in Excel

Comments
4 min read
Set operations of Excel inter row data (intersection, union, difference)

Set operations of Excel inter row data (intersection, union, difference)

Comments
5 min read
Set operations of data between Excel columns (intersection, union, and difference)

Set operations of data between Excel columns (intersection, union, and difference)

Comments
4 min read
How to Quickly Split an Excel into Multiple Excels

How to Quickly Split an Excel into Multiple Excels

6
Comments 1
3 min read
Batch Summary of Multiple Excel Spreadsheet Data – Done in 1 Minute

Batch Summary of Multiple Excel Spreadsheet Data – Done in 1 Minute

1
Comments 1
4 min read
How to Merge Excel Sheets Horizontally

How to Merge Excel Sheets Horizontally

Comments
4 min read
How to Quickly Merge Multiple Excel Files

How to Quickly Merge Multiple Excel Files

1
Comments 1
4 min read
The Very Tool to Liberate an Excelman from Working Overtime – SPL

The Very Tool to Liberate an Excelman from Working Overtime – SPL

1
Comments 1
8 min read
A Laymen’s Roadmap for Data Analysis and Processing Technology

A Laymen’s Roadmap for Data Analysis and Processing Technology

Comments
12 min read
A Correct Method for Complete Novice to Self-study of Programming

A Correct Method for Complete Novice to Self-study of Programming

Comments 1
12 min read
What Programming Language Should Business People Learn?

What Programming Language Should Business People Learn?

Comments
9 min read
How do beginners learn SQL quickly?

How do beginners learn SQL quickly?

Comments
5 min read
loading...