Desktop - Group - RaqForum

Desktop • 360 Reference • 166 Reply • 0 Follow

Default Hot Nice Preferred Recent reply
excel(115) clipboard(13) add-in(10) string split(9) group(7) word extraction(5) distinct(3) row-to-column transposition(2) sort(2) column-to-row transposition(2) spl xll practice(2) data concatenation(2) set operation(2) search & selection(1) conditional query(1) topn(1) string generation(1) command line(1) difference(1) text file association(1) aggregate(1) more>>> string handling(1) data search(1)

1 2 3 4 5 6 7 8 9 10 ... 15»

mars • Desktop • 1 Reply 548 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 557 View • 2023-11-30 16:20:31
SPL XLL Practice: Almighty Text Splitting in Excel
mars • Desktop • 1 Reply 793 View • 2023-11-20 16:22:19
Set operations of Excel inter row data (intersection, union, difference)
mars • Desktop • 1 Reply 1485 View 1,485 View • 2023-11-20 16:22:28
Set operations of data between Excel columns (intersection, union, difference)
mars • Desktop • 1 Reply 570 View • 2023-11-20 16:22:38
Excel Advanced Group and Summary Method
mars • Desktop • 1 Reply 558 View • 2023-11-20 16:22:47
How to automatically extract eligible rows in Excel
mars • Desktop • 1 Reply 862 View • 2023-11-20 16:23:25
How to merge Excel Sheets horizontally
mars • Desktop • 1 Reply 596 View • 2023-08-31 18:34:05
Batch summary of multiple Excel spreadsheet data – done in 1 minute
mars • Desktop • 1 Reply 624 View • 2023-11-20 16:18:18
How to quickly merge multiple Excel files
blackduckie • Desktop • 435 View • 2021-07-30 19:05:07
Column-to-Row Transposition
blackduckie • Desktop • 426 View • 2021-07-30 18:54:37
Calculate the Difference of Two White-space-separated Strings
blackduckie • Desktop • 390 View • 2021-07-30 15:40:55
Find Corresponding Data in the One Table Using the Other Table
blackduckie • Desktop • 371 View • 2021-07-30 15:23:03
Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them
blackduckie • Desktop • 425 View • 2021-07-30 14:54:34
Find Values Corresponding to Keys Stored in a Specific Cell
blackduckie • Desktop • 403 View • 2021-07-30 14:38:22
Sum up Key Value Pairs and Concatenate Results
blackduckie • Desktop • 430 View • 2021-07-30 11:07:26
Move Cells Containing Values in the Last Four Columns into Corresponding Rows
blackduckie • Desktop • 348 View • 2021-07-30 10:47:59
Group Rows and Concatenate Each Value of a Specific Column into a String
blackduckie • Desktop • 369 View • 2021-07-30 09:56:59
List Values in a Specific Column Whose Occurrences Rank in Top 10
blackduckie • Desktop • 369 View • 2021-07-29 18:26:46
Concatenate Two Columns and Enter Result to Another Column
blackduckie • Desktop • 461 View • 2021-07-29 14:41:00
Insert Values in a Specific Column That Are Substrings of Values of Another Column to the Third Column
blackduckie • Desktop • 409 View • 2021-07-29 11:43:34
Sort a Certain Column according to the Specific Order of Key Words It Contains
blackduckie • Desktop • 395 View • 2021-07-28 18:42:11
Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell
blackduckie • Desktop • 466 View • 2021-07-28 18:29:10
Write All Values of the Non-Grouping Field in One Row
blackduckie • Desktop • 368 View • 2021-07-28 18:05:14
Query a Cross Table according to Both Row Value and Column Value
blackduckie • Desktop • 367 View • 2021-07-28 17:55:08
Auto-delete Empty Detailed Rows after Grouping

1 2 3 4 5 6 7 8 9 10 ... 15»

How to do Excel table association – You are out if you know only VLOOKUP

SPL XLL Practice: Almighty Text Splitting in Excel

Set operations of Excel inter row data (intersection, union, difference)

Set operations of data between Excel columns (intersection, union, difference)

Excel Advanced Group and Summary Method

How to automatically extract eligible rows in Excel

How to merge Excel Sheets horizontally

Batch summary of multiple Excel spreadsheet data – done in 1 minute

How to quickly merge multiple Excel files

Column-to-Row Transposition

Calculate the Difference of Two White-space-separated Strings

Find Corresponding Data in the One Table Using the Other Table

Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them

Find Values Corresponding to Keys Stored in a Specific Cell

Sum up Key Value Pairs and Concatenate Results

Move Cells Containing Values in the Last Four Columns into Corresponding Rows

Group Rows and Concatenate Each Value of a Specific Column into a String

List Values in a Specific Column Whose Occurrences Rank in Top 10

Concatenate Two Columns and Enter Result to Another Column

Insert Values in a Specific Column That Are Substrings of Values of Another Column to the Third Column

Sort a Certain Column according to the Specific Order of Key Words It Contains

Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell

Write All Values of the Non-Grouping Field in One Row

Query a Cross Table according to Both Row Value and Column Value

Auto-delete Empty Detailed Rows after Grouping

New group

Contribute open source GitHub