-
-
-
6.13 Find out interval in which a certain condition occurs continuously
eBook • 0 Reply • 324 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 • 405 View • 2023-11-23 17:04 -
-
-
6.9 Take values of adjacent rows in same group (search & filter within adjacent intervals)
eBook • 0 Reply • 380 View • 2023-11-23 17:02 -
-
-
-
6.5 Search for row number that satisfies the condition
eBook • 0 Reply • 321 View • 2023-11-23 17:00 -
6.4 Search for position of a certain value, take the value by position
eBook • 0 Reply • 333 View • 2023-11-23 16:59 -
-
-
-
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
eBook • 0 Reply • 402 View • 2023-11-23 11:47 -
5.10 Split by column - merge duplicate rows after splitting
eBook • 0 Reply • 318 View • 2023-11-23 11:46 -
5.9 Split by column - by column - take column name as Sheet name
eBook • 0 Reply • 416 View • 2023-11-23 11:46 -
5.8 Split by column - by column - take column name as file name
eBook • 0 Reply • 352 View • 2023-11-23 11:45 -
5.7 Format conversion - split tables with primary-sub relationship into cards
eBook • 0 Reply • 379 View • 2023-11-23 11:45 -
5.6 Split by row - split multiple cards to make one card generate one file
eBook • 0 Reply • 324 View • 2023-11-23 11:44 -
-
5.4 Split by row - segment by data (by filtering condition)
eBook • 0 Reply • 357 View • 2023-11-23 11:41 -
5.3 Split by row - group by data - split into multiple files
eBook • 0 Reply • 373 View • 2023-11-23 11:40 -
5.2 Split by row - group by data - split into multiple Sheets
eBook • 0 Reply • 318 View • 2023-11-23 11:40 -
-
-
-
-
4.23 Aggregate files - aggregate by cell positions - unfixed number of files
eBook • 0 Reply • 390 View • 2023-11-23 11:38