DEV Community

Judith-Excel-Sharing profile picture

Judith-Excel-Sharing

esProc Desktop is a desktop data processing & analytics tool and is specifically designed for ordinary business people, which significantly lowers the technical threshold for data analytics.

8 Week Community Wellness Streak
4 Week Community Wellness Streak
2 Week Community Wellness Streak
1 Week Community Wellness Streak
Two Year Club
Writing Debut
4 Week Writing Streak
One Year Club
#94 — Intersection, Union, and Difference in the Case of Row-Based Data — Two Sets — by Whole Row

#94 — Intersection, Union, and Difference in the Case of Row-Based Data — Two Sets — by Whole Row

6
Comments 1
2 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
#93 — Intersection, Union and Difference in the Case of Row-Based Data — Two Sets — by Key Column

#93 — Intersection, Union and Difference in the Case of Row-Based Data — Two Sets — by Key Column

6
Comments 1
2 min read
#92 — Intersection, Union, And Difference in the Case of Simple Members — Multiple Sets

#92 — Intersection, Union, And Difference in the Case of Simple Members — Multiple Sets

6
Comments 1
1 min read
#91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets

#91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets

6
Comments
1 min read
#91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets

#91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets

6
Comments 1
1 min read
#90 — Generate Numbers in Each Group

#90 — Generate Numbers in Each Group

6
Comments 1
1 min read
#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group

#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group

6
Comments 1
1 min read
#88 — String Concatenation And Aggregation

#88 — String Concatenation And Aggregation

6
Comments 1
1 min read
#87 — Merge Data of The Same Group

#87 — Merge Data of The Same Group

7
Comments 1
1 min read
#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)

#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)

1
Comments
1 min read
#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)

#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)

6
Comments 1
1 min read
#85 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Continuous (Link Relative Ratio And YOY)

#85 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Continuous (Link Relative Ratio And YOY)

6
Comments 1
1 min read
#84 — Accumulation for Continuous Occurrence of A Certain Condition

#84 — Accumulation for Continuous Occurrence of A Certain Condition

6
Comments 1
1 min read
#83 — Early-Terminated Accumulation

#83 — Early-Terminated Accumulation

5
Comments 1
2 min read
#82 — Filter by Accumulation

#82 — Filter by Accumulation

6
Comments 1
1 min read
#81 — Accumulate Data in Each Group

#81 — Accumulate Data in Each Group

6
Comments
1 min read
#80 — Simple Accumulation

#80 — Simple Accumulation

6
Comments 1
1 min read
#79 - Split Aggregation Values And Fill Them in Detail Rows

#79 - Split Aggregation Values And Fill Them in Detail Rows

6
Comments 1
2 min read
#78 — Fill Aggregation Value in The First Row of The Same Group of Data

#78 — Fill Aggregation Value in The First Row of The Same Group of Data

6
Comments 1
1 min read
#77 - Conditional Aggregation

#77 - Conditional Aggregation

6
Comments 1
1 min read
#76 — Simple Column-Wise Aggregation

#76 — Simple Column-Wise Aggregation

6
Comments 1
1 min read
#75 — Find out The Intervals in Which A Certain Condition Occurs Continuously

#75 — Find out The Intervals in Which A Certain Condition Occurs Continuously

6
Comments 1
1 min read
#74 - Filter by Maximum Or Minimum Value within A Group (Find out One for Each Group)

#74 - Filter by Maximum Or Minimum Value within A Group (Find out One for Each Group)

6
Comments 1
1 min read
#73 — Use Grouped Aggregation Values When Filtering

#73 — Use Grouped Aggregation Values When Filtering

1
Comments
1 min read
#73 — Use Grouped Aggregation Values When Filtering

#73 — Use Grouped Aggregation Values When Filtering

6
Comments 1
1 min read
#72 — Filter by Grouped Aggregation Values

#72 — Filter by Grouped Aggregation Values

6
Comments 1
1 min read
#71 — Take Values of Adjacent Rows in The Same Group (Search & Filter within Adjacent Intervals)

#71 — Take Values of Adjacent Rows in The Same Group (Search & Filter within Adjacent Intervals)

6
Comments 1
2 min read
#70 — Search by Adjacent Rows

#70 — Search by Adjacent Rows

5
Comments 1
1 min read
#69 — Filter by Multiple Conditions

#69 — Filter by Multiple Conditions

6
Comments 1
1 min read
#68 — Search for Rows That Satisfy The Condition

#68 — Search for Rows That Satisfy The Condition

6
Comments 1
1 min read
#67 — Search for Row Numbers That Satisfy The Condition

#67 — Search for Row Numbers That Satisfy The Condition

6
Comments 1
1 min read
#66 — Search for The Position of A Certain Value And Take Values by Position

#66 — Search for The Position of A Certain Value And Take Values by Position

6
Comments 1
1 min read
#65 — Filter Rows by Position

#65 — Filter Rows by Position

6
Comments 1
1 min read
#64 — Search for Top N Values And Last N Values

#64 — Search for Top N Values And Last N Values

7
Comments 3
1 min read
#63 — Search for The Nth Value And The Nth Value from Last

#63 — Search for The Nth Value And The Nth Value from Last

6
Comments 1
1 min read
#62 - Search for A Specified String across The Whole Table

#62 - Search for A Specified String across The Whole Table

10
Comments 1
1 min read
#61 — Split Words as Individual Characters

#61 — Split Words as Individual Characters

6
Comments 1
1 min read
#60 — Find How Many Times Two Specified Members Will Be Contained in A Series of Sets

#60 — Find How Many Times Two Specified Members Will Be Contained in A Series of Sets

6
Comments 1
2 min read
#59 - Split IP Addresses And Then Group Rows

#59 - Split IP Addresses And Then Group Rows

6
Comments 1
1 min read
#58 — Split Each Row into Multiple Rows According to The Specified Rule

#58 — Split Each Row into Multiple Rows According to The Specified Rule

6
Comments 1
2 min read
#57 — Concatenate Column Titles Corresponding to Empty Cells

#57 — Concatenate Column Titles Corresponding to Empty Cells

6
Comments 1
1 min read
#56 — Get The Same Rows from A Table

#56 — Get The Same Rows from A Table

6
Comments 3
1 min read
#55 — Remove Duplicate Rows

#55 — Remove Duplicate Rows

7
Comments 1
1 min read
#54 - Combine Cell Values of Every 3 Rows under Each Column into One Cell

#54 - Combine Cell Values of Every 3 Rows under Each Column into One Cell

6
Comments 1
1 min read
#53 — Get Desired Data Every N Rows And Combine Them Into One Row

#53 — Get Desired Data Every N Rows And Combine Them Into One Row

5
Comments 2
1 min read
#52 — Get The Last Row of Each Group

#52 — Get The Last Row of Each Group

8
Comments 2
1 min read
#51 - Get Rankings of Excel Rows in Each Group While Retaining the Existing Order

#51 - Get Rankings of Excel Rows in Each Group While Retaining the Existing Order

5
Comments 2
1 min read
#50 — Group And Summarize Rows And Add Different Words After Different Counts

#50 — Group And Summarize Rows And Add Different Words After Different Counts

8
Comments 2
1 min read
#49 - Group An EXCEL Table And Concatenate Values of Rows Meeting The Specified Condition

#49 - Group An EXCEL Table And Concatenate Values of Rows Meeting The Specified Condition

7
Comments 2
1 min read
#48 — In An Excel Table, Find Rows Corresponding to The 1st And The Last Non-Empty Cells in Each Column

#48 — In An Excel Table, Find Rows Corresponding to The 1st And The Last Non-Empty Cells in Each Column

6
Comments 2
1 min read
#47 — Sort An EXCEL Table According To Custom Segments

#47 — Sort An EXCEL Table According To Custom Segments

7
Comments 2
1 min read
#46 — Find The Category Meeting The Specified Condition

#46 — Find The Category Meeting The Specified Condition

6
Comments 2
1 min read
#45 — Copy Each Row N Times (N Is The Cell Value of The Specified column)

#45 — Copy Each Row N Times (N Is The Cell Value of The Specified column)

7
Comments 2
1 min read
#44 — Group Rows And Combine Non-Null Values in Each of The Non-Grouping Columns

#44 — Group Rows And Combine Non-Null Values in Each of The Non-Grouping Columns

8
Comments 2
1 min read
#43 - Find the Difference Between Two Strings

#43 - Find the Difference Between Two Strings

8
Comments 2
1 min read
#42 — Skip Empty Cells To Sort Members

#42 — Skip Empty Cells To Sort Members

8
Comments 2
1 min read
#41 — Group And Summarize Rows While Retaining Columns Whose Values Are Unchanged

#41 — Group And Summarize Rows While Retaining Columns Whose Values Are Unchanged

12
Comments 2
1 min read
#40 — Group And Summarize A Tree Structure Table

#40 — Group And Summarize A Tree Structure Table

6
Comments 2
1 min read
#39 — Define A Dynamic Range of Columns And Perform Aggregation

#39 — Define A Dynamic Range of Columns And Perform Aggregation

6
Comments 2
1 min read
#38 — Group Columns of An Excel Table And Perform Aggregation

#38 — Group Columns of An Excel Table And Perform Aggregation

6
Comments 2
1 min read
loading...