Judith-Excel-Sharing - DEV Community

Judith-Excel-Sharing

Sep 27

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

#productivity #tutorial #programming #beginners

6

1

1 min read

Judith-Excel-Sharing

Sep 26

#65 — Filter Rows by Position

#productivity #programming #tutorial #beginners

6

1

1 min read

Judith-Excel-Sharing

Sep 25

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

#productivity #beginners #tutorial #programming

7

3

1 min read

Judith-Excel-Sharing

Sep 24

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

#productivity #tutorial #programming #beginners

6

1

1 min read

Judith-Excel-Sharing

Sep 11

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

#productivity #programming #tutorial #beginners

10

1

1 min read

Judith-Excel-Sharing

Sep 10

#61 — Split Words as Individual Characters

#productivity #tutorial #programming #beginners

6

1

1 min read

Judith-Excel-Sharing

Sep 9

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

#productivity #programming #beginners #tutorial

6

1

2 min read

Judith-Excel-Sharing

Sep 6

#59 - Split IP Addresses And Then Group Rows

#productivity #tutorial #programming #beginners

6

1

1 min read

Judith-Excel-Sharing

Sep 5

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

#productivity #programming #tutorial #beginners

6

1

2 min read

Judith-Excel-Sharing

Sep 4

#57 — Concatenate Column Titles Corresponding to Empty Cells

#productivity #programming #tutorial #beginners

6

1

1 min read

Judith-Excel-Sharing

Sep 3

#56 — Get The Same Rows from A Table

#productivity #tutorial #programming #beginners

6

3

1 min read

Judith-Excel-Sharing

Sep 2

#55 — Remove Duplicate Rows

#programming #productivity #beginners #tutorial

7

1

1 min read

Judith-Excel-Sharing

Aug 29

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

#productivity #programming #beginners #tutorial

6

1

1 min read

Judith-Excel-Sharing

Aug 28

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

#productivity #programming #beginners #tutorial

5

2

1 min read

Judith-Excel-Sharing

Aug 27

#52 — Get The Last Row of Each Group

#productivity #tutorial #programming #beginners

11

2

1 min read

Judith-Excel-Sharing

Aug 26

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

#productivity #tutorial #beginners #programming

7

2

1 min read

Judith-Excel-Sharing

Aug 23

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

#productivity #programming #beginners #tutorial

8

2

1 min read

Judith-Excel-Sharing

Aug 22

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

#productivity #programming #tutorial #beginners

7

2

1 min read

Judith-Excel-Sharing

Aug 21

#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

2

1 min read

Judith-Excel-Sharing

Aug 19

#47 — Sort An EXCEL Table According To Custom Segments

#productivity #programming #tutorial #beginners

7

2

1 min read

Judith-Excel-Sharing

Aug 16

#46 — Find The Category Meeting The Specified Condition

#tutorial #productivity #programming #beginners

6

2

1 min read

Judith-Excel-Sharing

Aug 15

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

#productivity #tutorial #programming #beginners

7

2

1 min read

Judith-Excel-Sharing

Aug 13

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

#tutorial #productivity #programming #beginners

9

2

1 min read

Judith-Excel-Sharing

Aug 13

#43 - Find the Difference Between Two Strings

#productivity #tutorial #programming #beginners

9

2

1 min read

Judith-Excel-Sharing

Aug 9

#42 — Skip Empty Cells To Sort Members

#tutorial #productivity #programming #beginners

8

2

1 min read

Judith-Excel-Sharing

Aug 8

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

#productivity #tutorial #programming #beginners

12

2

1 min read

Judith-Excel-Sharing

Aug 7

#40 — Group And Summarize A Tree Structure Table

#tutorial #productivity #programming #beginners

6

2

1 min read

Judith-Excel-Sharing

Aug 6

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

#productivity #tutorial #programming #beginners

6

2

1 min read

Judith-Excel-Sharing

Aug 2

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

#productivity #tutorial #programming #beginners

6

2

1 min read

Judith-Excel-Sharing

Aug 1

#37 — Replace Duplicate Items with The Specified Text

#productivity #tutorial #programming #beginners

5

2

1 min read

Judith-Excel-Sharing

Jul 30

#36 — Match The First Part of The Cell Value

#productivity #tutorial #programming #beginners

7

2

1 min read

Judith-Excel-Sharing

Jul 29

#35 - Get A Random Row from Each Group

#productivity #tutorial #programming #beginners

11

4

1 min read

Judith-Excel-Sharing

Jul 26

#34 — Remove Duplicates And Compute Intersection

#productivity #tutorial #programming #beginners

6

2

1 min read

Judith-Excel-Sharing

Jul 25

#33 — Find The Differences Between Contents of Two Cells

#productivity #tutorial #beginners #programming

6

2

1 min read

Judith-Excel-Sharing

Jul 24

#32 — Find The First Cell Value Meeting The Specified Condition

#tutorial #programming #beginners #productivity

7

2

1 min read

Judith-Excel-Sharing

Jul 23

#31 — Write The First Lines of Multiples CSV Files to Excel

#tutorial #productivity #programming #beginners

9

2

1 min read

Judith-Excel-Sharing

Jul 22

#30 — Align Rows of Data To A Specified Column

#tutorial #productivity #programming #beginners

6

2

1 min read

Judith-Excel-Sharing

Jul 19

#29 — Group an Excel table and Store It as Multiple Files According to Part of The Values of Specified Cells

#productivity #tutorial #beginners #programming

6

2

1 min read

Judith-Excel-Sharing

Jul 18

#28 — Combine Two Tables With Different Column Headers

#beginners #programming #tutorial #productivity

6

2

1 min read

Judith-Excel-Sharing

Jul 17

#27 — Group and Summarize A Table Where Every N Rows Consists of A Range by Column

#beginners #programming #tutorial #productivity

5

2

1 min read

Judith-Excel-Sharing

Jul 16

#26 — Get Two Numbers from Each of The Two Sets of Numbers and Let Them Equal A Specified Value

#programming #beginners #tutorial #productivity

8

2

1 min read

Judith-Excel-Sharing

Jul 15

#25 — Write Continuous Numbers in A String of Numbers as Intervals

#programming #beginners #tutorial #productivity

8

2

1 min read

Judith-Excel-Sharing

Jul 12

#24 — Repeat the Value of Each Cell N times According to the Value of the Neighboring cell

#tutorial #beginners #productivity #excel

7

2

1 min read

Judith-Excel-Sharing

Jul 11

Expand Multi-Row Text in A Cell to Multiple Cells

#programming #beginners #tutorial #productivity

7

2

1 min read

Judith-Excel-Sharing

Jul 10

Summarize Data in Every Two Columns under Each Category

#programming #beginners #tutorial #productivity

6

2

1 min read

Judith-Excel-Sharing

Jul 10

Group Rows and Concatenate Cell Values

#programming #beginners #tutorial #productivity

1

1 min read

Judith-Excel-Sharing

Jul 10

Group Rows and Concatenate Cell Values

#programming #beginners #tutorial #productivity

6

2

1 min read

Judith-Excel-Sharing

Jul 8

Concatenate Column Values and Perform Grouping & Aggregation

#programming #beginners #tutorial #productivity

6

2

1 min read

Judith-Excel-Sharing

Jul 2

List the Positions of Each Character

#beginners #programming #tutorial #productivity

6

2

1 min read

Judith-Excel-Sharing

Jul 1

Split & Group Text and Perform Distinct on Each Group

#tutorial #programming #beginners #productivity

7

2

1 min read

Judith-Excel-Sharing

Jun 28

Split Each Cell Value And Expand It According To The Specified Rule

#programming #beginners #tutorial #productivity

7

2

1 min read

Judith-Excel-Sharing

Jun 27

Import A TXT File Where The Separator Is Missing In A Column To Excel

#programming #beginners #tutorial #productivity

6

2

2 min read

Judith-Excel-Sharing

Jun 26

In Excel, Re-arrange A Sequence N Times Randomly

#tutorial #productivity #beginners #programming

7

1

1 min read

Judith-Excel-Sharing

Jun 25

In Excel, Search A Target Value And Hide Columns To Its Right

#programming #beginners #tutorial #productivity

7

2

1 min read

Judith-Excel-Sharing

Jun 24

In Excel, Parse Hexadecimal Numbers And Make Queries

#beginners #programming #tutorial #productivity

7

1

1 min read

Judith-Excel-Sharing

Jun 21

New Course Launch: SPL Programming on esProc Desktop

#beginners #programming #tutorial #productivity

5

1

1 min read

Judith-Excel-Sharing

Jun 20

In Excel, Judge Whether A Word Has Duplicate Letters

#beginners #programming #tutorial #productivity

10

2

1 min read

Judith-Excel-Sharing

Jun 19

In Excel, Find the Maximum Value and the Neighboring N Members Before and After

#beginners #programming #tutorial #productivity

7

2

1 min read

Judith-Excel-Sharing

Jun 18

In Excel, Combine Multiple Detail Data Columns into One Row in Each Group

#beginners #programming #tutorial #productivity

5

2

1 min read

Judith-Excel-Sharing

Jun 17

In Excel, Identify Data Layers Correctly and Convert Them to a Standardized Table

#beginners #programming #tutorial #productivity

5

2

2 min read

Scudata

Want to connect with Judith-Excel-Sharing?