-
7.3 Fill aggregation value in the first row of the same group of data
eBook • 0 Reply • 476 View • 2023-11-23 17:07 -
-
-
6.13 Find out interval in which a certain condition occurs continuously
eBook • 0 Reply • 468 View • 2023-11-23 17:04 -
6.12 Filter by maximum or minimum value within a group (find out one for each group)
eBook • 0 Reply • 533 View • 2023-11-23 17:04 -
-
-
6.9 Take values of adjacent rows in same group (search & filter within adjacent intervals)
eBook • 0 Reply • 505 View • 2023-11-23 17:02 -
-
-
-
6.5 Search for row number that satisfies the condition
eBook • 0 Reply • 449 View • 2023-11-23 17:00 -
6.4 Search for position of a certain value, take the value by position
eBook • 0 Reply • 491 View • 2023-11-23 16:59 -
-
-
-
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
eBook • 0 Reply • 542 View • 2023-11-23 11:47 -
5.10 Split by column - merge duplicate rows after splitting
eBook • 0 Reply • 458 View • 2023-11-23 11:46 -
5.9 Split by column - by column - take column name as Sheet name
eBook • 0 Reply • 541 View • 2023-11-23 11:46 -
5.8 Split by column - by column - take column name as file name
eBook • 0 Reply • 470 View • 2023-11-23 11:45 -
5.7 Format conversion - split tables with primary-sub relationship into cards
eBook • 0 Reply • 505 View • 2023-11-23 11:45 -
5.6 Split by row - split multiple cards to make one card generate one file
eBook • 0 Reply • 436 View • 2023-11-23 11:44 -
-
5.4 Split by row - segment by data (by filtering condition)
eBook • 0 Reply • 497 View • 2023-11-23 11:41 -
5.3 Split by row - group by data - split into multiple files
eBook • 0 Reply • 501 View • 2023-11-23 11:40 -
5.2 Split by row - group by data - split into multiple Sheets
eBook • 0 Reply • 469 View • 2023-11-23 11:40 -
-
-
-