Tag feed

#spl-xll

2 posts0 followers

EesProcesproc-desktop.hashnode.dev

#125 — Grouping Upon Encountering Blank Rows

Jan 3, 2025 · 1 min read · Problem description & analysis: Here below is a data table: Task: The data consist of multiple segments, and each segment includes N consecutive rows and 1 blank row. Now we want to calculate the sum of the values of each segment, and fill in the re...

EesProc commented

EesProcesproc-desktop.hashnode.dev

0

In Excel, Insert Group Headers to Detail Data Rows in Each Group

May 31, 2024 · 5 min read · Problem description & analysis The Excel worksheet below contains multiple vertical subtable groups, which are separated by a blank row. In each group, the 2nd cells of both row 1 and row 2 contain subtable group headers and row 3 contains column hea...

EesProc commented

#spl-xll

Search Hashnode

#spl-xll

#125 — Grouping Upon Encountering Blank Rows

In Excel, Insert Group Headers to Detail Data Rows in Each Group