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
#119 — Group by the Expression
judith677 profile

#119 — Group by the Expression

#programming #beginners #tutorial #productivity
5
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
#118 — Group by the Combination of Multiple Columns
judith677 profile

#118 — Group by the Combination of Multiple Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#117 — Simple Grouping
judith677 profile

#117 — Simple Grouping

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#116 — Concatenate Members with the Same Ranking
judith677 profile

#116 — Concatenate Members with the Same Ranking

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#115 — Ranking of Row-Based Data — by the Expression
judith677 profile

#115 — Ranking of Row-Based Data — by the Expression

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#114 — Ranking of Row-Based Data — by the Combination of Multiple Columns
judith677 profile

#114 — Ranking of Row-Based Data — by the Combination of Multiple Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#113 — Ranking of Row-Based Data
judith677 profile

#113 — Ranking of Row-Based Data

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#112 — Ranking of Simple Members
judith677 profile

#112 — Ranking of Simple Members

#programming #beginners #tutorial #productivity
5
Comments 1
1 min read
#111 — Sort in Group
judith677 profile

#111 — Sort in Group

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#110 — Sorting of Row-Based Data — by Expression
judith677 profile

#110 — Sorting of Row-Based Data — by Expression

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#109 — Sorting of Row-Based Data — by the Combination of Multiple Columns
judith677 profile

#109 — Sorting of Row-Based Data — by the Combination of Multiple Columns

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#108 — Sorting of Row-Based Data
judith677 profile

#108 — Sorting of Row-Based Data

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#107 — Sorting of Simple Members
judith677 profile

#107 — Sorting of Simple Members

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#106 — Delete Data that Can be Paired
judith677 profile

#106 — Delete Data that Can be Paired

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#105 — Filter by the Number of Duplicates
judith677 profile

#105 — Filter by the Number of Duplicates

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#104 — Deduplication of Row-Based Data — by Whole Row — Keeping the Original Order
judith677 profile

#104 — Deduplication of Row-Based Data — by Whole Row — Keeping the Original Order

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#103 — Deduplication of Row-Based Data — by Key Column — Keeping the Original Order
judith677 profile

#103 — Deduplication of Row-Based Data — by Key Column — Keeping the Original Order

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
#102 — Deduplication of Simple Data — Keeping the Original Order
judith677 profile

#102 — Deduplication of Simple Data — Keeping the Original Order

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#101 - Deduplication of Row-Based Data - by Whole Row
judith677 profile

#101 - Deduplication of Row-Based Data - by Whole Row

#programming #beginners #tutorial #productivity
6
Comments 1
1 min read
#100 — Deduplication of Row-Based Data — by Key Column
judith677 profile

#100 — Deduplication of Row-Based Data — by Key Column

#beginners #programming #tutorial #productivity
7
Comments 1
1 min read
#99 — Deduplication of Simple Data
judith677 profile

#99 — Deduplication of Simple Data

#programming #tutorial #beginners #productivity
6
Comments 1
1 min read
#98 — Count Duplicates of Row-Based Data — by Key Column
judith677 profile

#98 — Count Duplicates of Row-Based Data — by Key Column

#programming #beginners #tutorial #productivity
5
Comments 1
1 min read
#97 — Count Duplicates of Simple Members
judith677 profile

#97 — Count Duplicates of Simple Members

#tutorial #programming #beginners #productivity
6
Comments 1
1 min read
#96 — Identify Duplications of Row-Based Data — by Key Column
judith677 profile

#96 — Identify Duplications of Row-Based Data — by Key Column

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
#95 — Identify Duplications of Simple Members
judith677 profile

#95 — Identify Duplications of Simple Members

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
#94 — Intersection, Union, and Difference in the Case of Row-Based Data — Two Sets — by Whole Row
judith677 profile

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

#beginners #productivity #programming #tutorial
6
Comments 1
2 min read
#93 — Intersection, Union and Difference in the Case of Row-Based Data — Two Sets — by Key Column
judith677 profile

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

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