Desktop •
360 Reference •
166 Reply •
0 Follow
Follow
-
-
-
jinxing • Desktop • 109 View • 2024-07-16 08:13:58
Group and summarize a table where every N rows consist of a range by column
-
jinxing • Desktop • 111 View • 2024-07-11 08:25:39
Write continuous numbers in a string of numbers as intervals
-
jinxing • Desktop • 108 View • 2024-07-09 13:08:28
Repeat value of each cell N times according to value of the neighboring cell
-
jinxing • Desktop • 190 View • 2024-07-08 03:02:42
Expand multi-row text in a cell to multiple cells
-
jinxing • Desktop • 162 View • 2024-07-05 06:04:23
Concatenate column values and perform grouping & aggregation
-
jinxing • Desktop • 177 View • 2024-07-04 13:37:43
Summarize data every two columns under each category
-
-
-
jinxing • Desktop • 128 View • 2024-07-01 01:56:51
Split & group text and perform distinct on each group
-
jinxing • Desktop • 147 View • 2024-06-26 02:21:11
Split each cell value and expand it according to the specified rule
-
jinxing • Desktop • 142 View • 2024-06-24 13:21:00
Import a txt file where separator is missing in a column to Excel
-
-
jinxing • Desktop • 143 View • 2024-06-24 09:00:03
In Excel, parse hexadecimal numbers and make queries
-
jinxing • Desktop • 149 View • 2024-06-24 08:59:47
In Excel, search a target value and hide columns to its right
-
jinxing • Desktop • 154 View • 2024-06-24 08:59:29
In Excel, judge whether a word has duplicate letters
-
jinxing • Desktop • 138 View • 2024-06-24 08:58:52
Excel, find the maximum value and the neighboring N members before and after
-
jinxing • Desktop • 146 View • 2024-06-24 08:58:35
In Excel, combine multiple detail data columns into one row in each group
-
jinxing • Desktop • 149 View • 2024-06-24 08:58:16
In Excel, identify data layers correctly and convert them to a standardized table
-
-
pjf • Desktop • 451 View • 2021-04-26 09:27:11
Compare two CSV files and find common or different data
-
-
-