-
-
-
-
-
mars • eBook • 439 View • 2023-11-23 09:10:02
7.4 Split aggregation value and fill them in detail rows
-
mars • eBook • 403 View • 2023-11-23 09:07:37
7.3 Fill aggregation value in the first row of the same group of data
-
-
-
mars • eBook • 380 View • 2023-11-23 09:04:37
6.13 Find out interval in which a certain condition occurs continuously
-
mars • eBook • 467 View • 2023-11-23 09:04:13
6.12 Filter by maximum or minimum value within a group (find out one for each group)
-
-
-
mars • eBook • 439 View • 2023-11-23 09:02:52
6.9 Take values of adjacent rows in same group (search & filter within adjacent intervals)
-
-
-
-
-
mars • eBook • 379 View • 2023-11-23 09:00:05
6.5 Search for row number that satisfies the condition
-
mars • eBook • 387 View • 2023-11-23 08:59:39
6.4 Search for position of a certain value, take the value by position
-
-
-
-
mars • eBook • 459 View • 2023-11-23 03:47:06
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
-
mars • eBook • 377 View • 2023-11-23 03:46:46
5.10 Split by column - merge duplicate rows after splitting
-
mars • eBook • 469 View • 2023-11-23 03:46:21
5.9 Split by column - by column - take column name as Sheet name