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