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.

Joined Joined on  Email address judithliu@scudata.com Personal website http://www.scudata.com/judith-excel/ twitter website
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
#92 — Intersection, Union, And Difference in the Case of Simple Members — Multiple Sets
judith677 profile

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

#programming #tutorial #beginners #productivity
6
Comments 1
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.

Create Account
Already have an account? Sign in
#91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets
judith677 profile

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

#programming #tutorial #beginners #productivity
6
Comments
1 min read
#91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets
judith677 profile

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

#programming #tutorial #beginners #productivity
6
Comments 1
1 min read
#90 — Generate Numbers in Each Group
judith677 profile

#90 — Generate Numbers in Each Group

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group
judith677 profile

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

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
#88 — String Concatenation And Aggregation
judith677 profile

#88 — String Concatenation And Aggregation

#programming #tutorial #beginners #productivity
6
Comments 1
1 min read
#87 — Merge Data of The Same Group
judith677 profile

#87 — Merge Data of The Same Group

#productivity #beginners #programming #tutorial
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)
judith677 profile

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

#productivity #beginners #programming #tutorial
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)
judith677 profile

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

#productivity #beginners #programming #tutorial
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)
judith677 profile

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

#beginners #tutorial #programming #productivity
6
Comments 1
1 min read
#84 — Accumulation for Continuous Occurrence of A Certain Condition
judith677 profile

#84 — Accumulation for Continuous Occurrence of A Certain Condition

#tutorial #beginners #programming #productivity
6
Comments 1
1 min read
#83 — Early-Terminated Accumulation
judith677 profile

#83 — Early-Terminated Accumulation

#tutorial #beginners #programming #productivity
5
Comments 1
2 min read
#82 — Filter by Accumulation
judith677 profile

#82 — Filter by Accumulation

#productivity #programming #beginners #tutorial
6
Comments 1
1 min read
#81 — Accumulate Data in Each Group
judith677 profile

#81 — Accumulate Data in Each Group

#programming #tutorial #beginners #productivity
6
Comments
1 min read
#80 — Simple Accumulation
judith677 profile

#80 — Simple Accumulation

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#79 - Split Aggregation Values And Fill Them in Detail Rows
judith677 profile

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

#programming #beginners #tutorial #productivity
6
Comments 1
2 min read
#78 — Fill Aggregation Value in The First Row of The Same Group of Data
judith677 profile

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

#programming #tutorial #beginners #productivity
6
Comments 1
1 min read
#77 - Conditional Aggregation
judith677 profile

#77 - Conditional Aggregation

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#76 — Simple Column-Wise Aggregation
judith677 profile

#76 — Simple Column-Wise Aggregation

#tutorial #programming #beginners #productivity
6
Comments 1
1 min read
#75 — Find out The Intervals in Which A Certain Condition Occurs Continuously
judith677 profile

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

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

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

#productivity #tutorial #programming #beginners
6
Comments 1
1 min read
#73 — Use Grouped Aggregation Values When Filtering
judith677 profile

#73 — Use Grouped Aggregation Values When Filtering

#productivity #tutorial #programming #beginners
1
Comments
1 min read
#73 — Use Grouped Aggregation Values When Filtering
judith677 profile

#73 — Use Grouped Aggregation Values When Filtering

#productivity #tutorial #programming #beginners
6
Comments 1
1 min read
#72 — Filter by Grouped Aggregation Values
judith677 profile

#72 — Filter by Grouped Aggregation Values

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

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

#productivity #beginners #programming #tutorial
6
Comments 1
2 min read
#70 — Search by Adjacent Rows
judith677 profile

#70 — Search by Adjacent Rows

#productivity #tutorial #programming #beginners
5
Comments 1
1 min read
#69 — Filter by Multiple Conditions
judith677 profile

#69 — Filter by Multiple Conditions

#productivity #programming #tutorial #beginners
6
Comments 1
1 min read
#68 — Search for Rows That Satisfy The Condition
judith677 profile

#68 — Search for Rows That Satisfy The Condition

#productivity #programming #beginners #tutorial
6
Comments 1
1 min read
#67 — Search for Row Numbers That Satisfy The Condition
judith677 profile

#67 — Search for Row Numbers That Satisfy The Condition

#productivity #tutorial #programming #beginners
6
Comments 1
1 min read
#66 — Search for The Position of A Certain Value And Take Values by Position
judith677 profile

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

#productivity #tutorial #programming #beginners
6
Comments 1
1 min read
#65 — Filter Rows by Position
judith677 profile

#65 — Filter Rows by Position

#productivity #programming #tutorial #beginners
6
Comments 1
1 min read
#64 — Search for Top N Values And Last N Values
judith677 profile

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

#productivity #beginners #tutorial #programming
7
Comments 3
1 min read
#63 — Search for The Nth Value And The Nth Value from Last
judith677 profile

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

#productivity #tutorial #programming #beginners
6
Comments 1
1 min read
#62 - Search for A Specified String across The Whole Table
judith677 profile

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

#productivity #programming #tutorial #beginners
10
Comments 1
1 min read
#61 — Split Words as Individual Characters
judith677 profile

#61 — Split Words as Individual Characters

#productivity #tutorial #programming #beginners
6
Comments 1
1 min read
#60 — Find How Many Times Two Specified Members Will Be Contained in A Series of Sets
judith677 profile

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

#productivity #programming #beginners #tutorial
6
Comments 1
2 min read
#59 - Split IP Addresses And Then Group Rows
judith677 profile

#59 - Split IP Addresses And Then Group Rows

#productivity #tutorial #programming #beginners
6
Comments 1
1 min read
#58 — Split Each Row into Multiple Rows According to The Specified Rule
judith677 profile

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

#productivity #programming #tutorial #beginners
6
Comments 1
2 min read
#57 — Concatenate Column Titles Corresponding to Empty Cells
judith677 profile

#57 — Concatenate Column Titles Corresponding to Empty Cells

#productivity #programming #tutorial #beginners
6
Comments 1
1 min read
#56 — Get The Same Rows from A Table
judith677 profile

#56 — Get The Same Rows from A Table

#productivity #tutorial #programming #beginners
6
Comments 3
1 min read
#55 — Remove Duplicate Rows
judith677 profile

#55 — Remove Duplicate Rows

#programming #productivity #beginners #tutorial
7
Comments 1
1 min read
#54 - Combine Cell Values of Every 3 Rows under Each Column into One Cell
judith677 profile

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

#productivity #programming #beginners #tutorial
6
Comments 1
1 min read
#53 — Get Desired Data Every N Rows And Combine Them Into One Row
judith677 profile

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

#productivity #programming #beginners #tutorial
5
Comments 2
1 min read
#52 — Get The Last Row of Each Group
judith677 profile

#52 — Get The Last Row of Each Group

#productivity #tutorial #programming #beginners
8
Comments 2
1 min read
#51 - Get Rankings of Excel Rows in Each Group While Retaining the Existing Order
judith677 profile

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

#productivity #tutorial #beginners #programming
5
Comments 2
1 min read
#50 — Group And Summarize Rows And Add Different Words After Different Counts
judith677 profile

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

#productivity #programming #beginners #tutorial
8
Comments 2
1 min read
#49 - Group An EXCEL Table And Concatenate Values of Rows Meeting The Specified Condition
judith677 profile

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

#productivity #programming #tutorial #beginners
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
judith677 profile

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

#tutorial #productivity #programming #beginners
6
Comments 2
1 min read
#47 — Sort An EXCEL Table According To Custom Segments
judith677 profile

#47 — Sort An EXCEL Table According To Custom Segments

#productivity #programming #tutorial #beginners
7
Comments 2
1 min read
#46 — Find The Category Meeting The Specified Condition
judith677 profile

#46 — Find The Category Meeting The Specified Condition

#tutorial #productivity #programming #beginners
6
Comments 2
1 min read
#45 — Copy Each Row N Times (N Is The Cell Value of The Specified column)
judith677 profile

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

#productivity #tutorial #programming #beginners
7
Comments 2
1 min read
#44 — Group Rows And Combine Non-Null Values in Each of The Non-Grouping Columns
judith677 profile

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

#tutorial #productivity #programming #beginners
8
Comments 2
1 min read
#43 - Find the Difference Between Two Strings
judith677 profile

#43 - Find the Difference Between Two Strings

#productivity #tutorial #programming #beginners
8
Comments 2
1 min read
#42 — Skip Empty Cells To Sort Members
judith677 profile

#42 — Skip Empty Cells To Sort Members

#tutorial #productivity #programming #beginners
8
Comments 2
1 min read
#41 — Group And Summarize Rows While Retaining Columns Whose Values Are Unchanged
judith677 profile

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

#productivity #tutorial #programming #beginners
12
Comments 2
1 min read
#40 — Group And Summarize A Tree Structure Table
judith677 profile

#40 — Group And Summarize A Tree Structure Table

#tutorial #productivity #programming #beginners
6
Comments 2
1 min read
#39 — Define A Dynamic Range of Columns And Perform Aggregation
judith677 profile

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

#productivity #tutorial #programming #beginners
6
Comments 2
1 min read
#38 — Group Columns of An Excel Table And Perform Aggregation
judith677 profile

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

#productivity #tutorial #programming #beginners
6
Comments 2
1 min read
#37 — Replace Duplicate Items with The Specified Text
judith677 profile

#37 — Replace Duplicate Items with The Specified Text

#productivity #tutorial #programming #beginners
5
Comments 2
1 min read
#36 — Match The First Part of The Cell Value
judith677 profile

#36 — Match The First Part of The Cell Value

#productivity #tutorial #programming #beginners
7
Comments 2
1 min read
loading...