Analyst •
285 Reference •
196 Reply •
1 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(102) clipboard(13) add-in(10) string split(9) word extraction(5) distinct(3) row-to-column transposition(2) sort(2) column-to-row transposition(2) data concatenation(2) set operation(2) spl xll practice(2) conditional query(1) topn(1) string generation(1) command line(1) difference(1) text file association(1) string handling(1) data search(1) spl desktop practice(1) more>>>
excel(102) clipboard(13) add-in(10) string split(9) word extraction(5) distinct(3) row-to-column transposition(2) sort(2) column-to-row transposition(2) data concatenation(2) set operation(2) spl xll practice(2) conditional query(1) topn(1) string generation(1) command line(1) difference(1) text file association(1) string handling(1) data search(1) spl desktop practice(1) more>>>
-
mars • Analyst • 1 Reply 271 View • 2023-12-14 03:35:00
SPL Desktop Practice: How to Quickly Split an Excel into Multiple Excels
-
mars • Analyst • 1 Reply 253 View • 2023-11-30 08:22:18
SPL XLL Practice: Excel Interval Association
-
mars • Analyst • 1 Reply 256 View • 2023-11-23 12:35:36
How to do Excel table association – You are out if you know only VLOOKUP
-
mars • Analyst • 1 Reply 286 View • 2023-11-30 08:20:31
SPL XLL Practice: Almighty Text Splitting in Excel
-
mars • Analyst • 1 Reply 325 View • 2023-11-20 08:22:19
Set operations of Excel inter row data (intersection, union, difference)
-
mars • Analyst • 1 Reply 417 View • 2023-11-20 08:22:28
Set operations of data between Excel columns (intersection, union, difference)
-
-
mars • Analyst • 1 Reply 273 View • 2023-11-20 08:22:47
How to automatically extract eligible rows in Excel
-
-
mars • Analyst • 1 Reply 317 View • 2023-08-31 10:34:05
Batch summary of multiple Excel spreadsheet data – done in 1 minute
-
-
-
blackduckie • Analyst • 233 View • 2021-07-30 10:54:37
Calculate the Difference of Two White-space-separated Strings
-
blackduckie • Analyst • 219 View • 2021-07-30 07:40:55
Find Corresponding Data in the One Table Using the Other Table
-
blackduckie • Analyst • 220 View • 2021-07-30 07:23:03
Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them
-
blackduckie • Analyst • 279 View • 2021-07-30 06:54:34
Find Values Corresponding to Keys Stored in a Specific Cell
-
blackduckie • Analyst • 230 View • 2021-07-30 06:38:22
Sum up Key Value Pairs and Concatenate Results
-
blackduckie • Analyst • 223 View • 2021-07-30 03:07:26
Move Cells Containing Values in the Last Four Columns into Corresponding Rows
-
blackduckie • Analyst • 199 View • 2021-07-30 02:47:59
Group Rows and Concatenate Each Value of a Specific Column into a String
-
blackduckie • Analyst • 204 View • 2021-07-30 01:56:59
List Values in a Specific Column Whose Occurrences Rank in Top 10
-
blackduckie • Analyst • 224 View • 2021-07-29 10:26:46
Concatenate Two Columns and Enter Result to Another Column
-
-
blackduckie • Analyst • 242 View • 2021-07-29 03:43:34
Sort a Certain Column according to the Specific Order of Key Words It Contains
-
blackduckie • Analyst • 224 View • 2021-07-28 10:42:11
Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell
-
blackduckie • Analyst • 249 View • 2021-07-28 10:29:10
Write All Values of the Non-Grouping Field in One Row