-
mars • Desktop • 1 Reply 553 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 558 View • 2023-11-30 16:20:31
SPL XLL Practice: Almighty Text Splitting in Excel
-
mars • Desktop • 1 Reply 796 View • 2023-11-20 16:22:19
Set operations of Excel inter row data (intersection, union, difference)
-
mars • Desktop • 1 Reply 1,512 View • 2023-11-20 16:22:28
Set operations of data between Excel columns (intersection, union, difference)
-
-
mars • Desktop • 1 Reply 562 View • 2023-11-20 16:22:47
How to automatically extract eligible rows in Excel
-
-
mars • Desktop • 1 Reply 599 View • 2023-08-31 18:34:05
Batch summary of multiple Excel spreadsheet data – done in 1 minute
-
-
-
blackduckie • Desktop • 429 View • 2021-07-30 18:54:37
Calculate the Difference of Two White-space-separated Strings
-
blackduckie • Desktop • 396 View • 2021-07-30 15:40:55
Find Corresponding Data in the One Table Using the Other Table
-
blackduckie • Desktop • 374 View • 2021-07-30 15:23:03
Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them
-
blackduckie • Desktop • 428 View • 2021-07-30 14:54:34
Find Values Corresponding to Keys Stored in a Specific Cell
-
blackduckie • Desktop • 406 View • 2021-07-30 14:38:22
Sum up Key Value Pairs and Concatenate Results
-
blackduckie • Desktop • 432 View • 2021-07-30 11:07:26
Move Cells Containing Values in the Last Four Columns into Corresponding Rows
-
blackduckie • Desktop • 351 View • 2021-07-30 10:47:59
Group Rows and Concatenate Each Value of a Specific Column into a String
-
blackduckie • Desktop • 370 View • 2021-07-30 09:56:59
List Values in a Specific Column Whose Occurrences Rank in Top 10
-
blackduckie • Desktop • 372 View • 2021-07-29 18:26:46
Concatenate Two Columns and Enter Result to Another Column
-
-
blackduckie • Desktop • 411 View • 2021-07-29 11:43:34
Sort a Certain Column according to the Specific Order of Key Words It Contains
-
blackduckie • Desktop • 397 View • 2021-07-28 18:42:11
Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell
-
blackduckie • Desktop • 468 View • 2021-07-28 18:29:10
Write All Values of the Non-Grouping Field in One Row
-
blackduckie • Desktop • 377 View • 2021-07-28 18:05:14
Query a Cross Table according to Both Row Value and Column Value
-
blackduckie • Desktop • 370 View • 2021-07-28 17:55:08
Auto-delete Empty Detailed Rows after Grouping