-
7.11 Calculate using adjacent row/interval when data of the same group is discontinuous (LRR/YOY in the case of missing data)
eBook • 0 Reply • 434 View • 2023-11-27 12:11 -
7.10 Calculate using adjacent row/interval when data of the same group is continuous (link relative ratio and YOY)
eBook • 0 Reply • 435 View • 2023-11-27 12:10 -
7.9 Accumulation for continuous occurrence of a certain condition
eBook • 0 Reply • 385 View • 2023-11-27 10:53 -
-
-
-
-
How to do Excel table association – You are out if you know only VLOOKUP
Desktop • 1 Reply • 483 View • 2023-11-23 20:35 -
7.4 Split aggregation value and fill them in detail rows
eBook • 0 Reply • 438 View • 2023-11-23 17:10 -
7.3 Fill aggregation value in the first row of the same group of data
eBook • 0 Reply • 402 View • 2023-11-23 17:07 -
-
-
6.13 Find out interval in which a certain condition occurs continuously
eBook • 0 Reply • 379 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 • 466 View • 2023-11-23 17:04 -
-
-
6.9 Take values of adjacent rows in same group (search & filter within adjacent intervals)
eBook • 0 Reply • 438 View • 2023-11-23 17:02 -
-
-
-
6.5 Search for row number that satisfies the condition
eBook • 0 Reply • 377 View • 2023-11-23 17:00 -
6.4 Search for position of a certain value, take the value by position
eBook • 0 Reply • 386 View • 2023-11-23 16:59 -
-
-
-
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
eBook • 0 Reply • 457 View • 2023-11-23 11:47 -
5.10 Split by column - merge duplicate rows after splitting
eBook • 0 Reply • 376 View • 2023-11-23 11:46 -
5.9 Split by column - by column - take column name as Sheet name
eBook • 0 Reply • 468 View • 2023-11-23 11:46