Independent Science + Technology

Author: Judith-Excel-Sharing

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

Post date November 5, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#87 — Merge Data of The Same Group

Post date November 1, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date October 30, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#69 — Filter by Multiple Conditions

Post date October 9, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date September 27, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date September 24, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#61 — Split Words as Individual Characters

Post date September 10, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date September 9, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#59 - Split IP Addresses And Then Group Rows

Post date September 6, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#57 — Concatenate Column Titles Corresponding to Empty Cells

Post date September 4, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#56 — Get The Same Rows from A Table

Post date September 3, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date August 29, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date August 28, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#52 — Get The Last Row of Each Group

Post date August 27, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date August 26, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date August 23, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date August 22, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#46 — Find The Category Meeting The Specified Condition

Post date August 16, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date August 13, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#42 — Skip Empty Cells To Sort Members

Post date August 9, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date August 8, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#40 — Group And Summarize A Tree Structure Table

Post date August 7, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#37 — Replace Duplicate Items with The Specified Text

Post date August 1, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#34 — Remove Duplicates And Compute Intersection

Post date July 26, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date July 24, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date July 23, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#30 — Align Rows of Data To A Specified Column

Post date July 22, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date July 19, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

#28 — Combine Two Tables With Different Column Headers

Post date July 18, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date July 17, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date July 16, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date July 15, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

Concatenate Column Values and Perform Grouping & Aggregation

Post date July 8, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date June 28, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

In Excel, Re-arrange A Sequence N Times Randomly

Post date June 26, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

In Excel, Parse Hexadecimal Numbers And Make Queries

Post date June 24, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date June 19, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

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

Post date June 18, 2024
Post author By Judith-Excel-Sharing
Post categories In beginners, productivity, programming, tutorial

Nothing left to load.