#44 — Group Rows And Combine Non-Null Values in Each of The Non-Grouping Columns
Judith-Excel-Sharing
Posted on August 13, 2024
judith
#33 — Find The Differences Between Contents of Two Cells
Judith-Excel-Sharing
Posted on July 25, 2024
#36 — Match The First Part of The Cell Value
Judith-Excel-Sharing
Posted on July 30, 2024
#47 — Sort An EXCEL Table According To Custom Segments
Judith-Excel-Sharing
Posted on August 19, 2024
#41 — Group And Summarize Rows While Retaining Columns Whose Values Are Unchanged
Judith-Excel-Sharing
Posted on August 8, 2024
#29 — Group an Excel table and Store It as Multiple Files According to Part of The Values of Specified Cells
Judith-Excel-Sharing
Posted on July 19, 2024
#32 — Find The First Cell Value Meeting The Specified Condition
Judith-Excel-Sharing
Posted on July 24, 2024
#38 — Group Columns of An Excel Table And Perform Aggregation
Judith-Excel-Sharing
Posted on August 2, 2024
Group Rows and Concatenate Cell Values
Judith-Excel-Sharing
Posted on July 10, 2024
Concatenate Column Values and Perform Grouping & Aggregation
Judith-Excel-Sharing
Posted on July 8, 2024
#39 — Define A Dynamic Range of Columns And Perform Aggregation
Judith-Excel-Sharing
Posted on August 6, 2024
List the Positions of Each Character
Judith-Excel-Sharing
Posted on July 2, 2024
In Excel, Re-arrange A Sequence N Times Randomly
Judith-Excel-Sharing
Posted on June 26, 2024
#35 - Get A Random Row from Each Group
Judith-Excel-Sharing
Posted on July 29, 2024
In Excel, Search A Target Value And Hide Columns To Its Right
Judith-Excel-Sharing
Posted on June 25, 2024
#26 — Get Two Numbers from Each of The Two Sets of Numbers and Let Them Equal A Specified Value
Judith-Excel-Sharing
Posted on July 16, 2024
Import A TXT File Where The Separator Is Missing In A Column To Excel
Judith-Excel-Sharing
Posted on June 27, 2024
#31 — Write The First Lines of Multiples CSV Files to Excel
Judith-Excel-Sharing
Posted on July 23, 2024
#30 — Align Rows of Data To A Specified Column
Judith-Excel-Sharing
Posted on July 22, 2024
Split & Group Text and Perform Distinct on Each Group
Judith-Excel-Sharing
Posted on July 1, 2024
Expand Multi-Row Text in A Cell to Multiple Cells
Judith-Excel-Sharing
Posted on July 11, 2024
In Excel, Judge Whether A Word Has Duplicate Letters
Judith-Excel-Sharing
Posted on June 20, 2024
Group Rows and Concatenate Cell Values
Judith-Excel-Sharing
Posted on July 10, 2024
Summarize Data in Every Two Columns under Each Category
Judith-Excel-Sharing
Posted on July 10, 2024
In Excel, Combine Multiple Detail Data Columns into One Row in Each Group
Judith-Excel-Sharing
Posted on June 18, 2024
#28 — Combine Two Tables With Different Column Headers
Judith-Excel-Sharing
Posted on July 18, 2024
#27 — Group and Summarize A Table Where Every N Rows Consists of A Range by Column
Judith-Excel-Sharing
Posted on July 17, 2024
#25 — Write Continuous Numbers in A String of Numbers as Intervals
Judith-Excel-Sharing
Posted on July 15, 2024
In Excel, Parse Hexadecimal Numbers And Make Queries
Judith-Excel-Sharing
Posted on June 24, 2024
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.