Desktop •
360 Reference •
166 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(115) split(10) string split(9) distinct(3) sort(2) column-to-row transposition(2) spl xll practice(2) set operation(2) spl desktop practice(1) command line(1) difference(1) text file association(1) string handling(1) data search(1)
excel(115) split(10) string split(9) distinct(3) sort(2) column-to-row transposition(2) spl xll practice(2) set operation(2) spl desktop practice(1) command line(1) difference(1) text file association(1) string handling(1) data search(1)
-
-
Lina • Desktop • 386 View • 2024-04-12 09:49:07
Excel Search for Each Comma-separated Value from Strings
-
Lina • Desktop • 356 View • 2024-04-11 10:26:35
Excel Copy Each Row Multiple Times by the Value of a Specific Column
-
Lina • Desktop • 369 View • 2024-04-10 10:11:06
Excel Get Common Words of Comma-separated Word Strings
-
Lina • Desktop • 368 View • 2024-04-09 09:43:17
Excel Auto-delete Empty Detailed Rows after Grouping
-
Lina • Desktop • 543 View • 2024-04-08 10:00:51
Excel Write All Values of the Non-Grouping Field in One Row
-
Lina • Desktop • 303 View • 2024-04-07 13:10:33
Excel Sort a Certain Column according to the Specific Order of Key Words It Contains
-
Lina • Desktop • 351 View • 2024-04-03 10:00:41
Excel Group Rows and Concatenate Each Value of a Specific Column into a String
-
-
mars • Desktop • 1 Reply 528 View • 2023-12-14 11:35:00
SPL Desktop Practice: How to Quickly Split an Excel into Multiple Excels
-
mars • Desktop • 1 Reply 501 View • 2023-11-30 16:22:18
SPL XLL Practice: Excel Interval Association
-
mars • Desktop • 1 Reply 537 View • 2023-11-23 20:35:36
How to do Excel table association – You are out if you know only VLOOKUP
-
mars • Desktop • 1 Reply 548 View • 2023-11-30 16:20:31
SPL XLL Practice: Almighty Text Splitting in Excel
-
mars • Desktop • 1 Reply 788 View • 2023-11-20 16:22:19
Set operations of Excel inter row data (intersection, union, difference)
-
mars • Desktop • 1 Reply 1,434 View • 2023-11-20 16:22:28
Set operations of data between Excel columns (intersection, union, difference)
-
-
mars • Desktop • 1 Reply 549 View • 2023-11-20 16:22:47
How to automatically extract eligible rows in Excel
-
-
mars • Desktop • 1 Reply 585 View • 2023-08-31 18:34:05
Batch summary of multiple Excel spreadsheet data – done in 1 minute
-
-
-
blackduckie • Desktop • 421 View • 2021-07-30 18:54:37
Calculate the Difference of Two White-space-separated Strings
-
blackduckie • Desktop • 380 View • 2021-07-30 15:40:55
Find Corresponding Data in the One Table Using the Other Table
-
blackduckie • Desktop • 365 View • 2021-07-30 15:23:03
Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them
-
blackduckie • Desktop • 420 View • 2021-07-30 14:54:34
Find Values Corresponding to Keys Stored in a Specific Cell