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 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 1433 View 1,433 View • 2023-11-20 16:22:28
Set operations of data between Excel columns (intersection, union, difference)
mars • Desktop • 1 Reply 564 View • 2023-11-20 16:22:38
Excel Advanced Group and Summary Method
mars • Desktop • 1 Reply 549 View • 2023-11-20 16:22:47
How to automatically extract eligible rows in Excel
mars • Desktop • 1 Reply 848 View • 2023-11-20 16:23:25
How to merge Excel Sheets horizontally
mars • Desktop • 1 Reply 585 View • 2023-08-31 18:34:05
Batch summary of multiple Excel spreadsheet data – done in 1 minute
mars • Desktop • 1 Reply 608 View • 2023-11-20 16:18:18
How to quickly merge multiple Excel files
blackduckie • Desktop • 430 View • 2021-07-30 19:05:07
Column-to-Row Transposition
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
blackduckie • Desktop • 398 View • 2021-07-30 14:38:22
Sum up Key Value Pairs and Concatenate Results
blackduckie • Desktop • 425 View • 2021-07-30 11:07:26
Move Cells Containing Values in the Last Four Columns into Corresponding Rows
blackduckie • Desktop • 336 View • 2021-07-30 10:47:59
Group Rows and Concatenate Each Value of a Specific Column into a String
blackduckie • Desktop • 364 View • 2021-07-30 09:56:59
List Values in a Specific Column Whose Occurrences Rank in Top 10
blackduckie • Desktop • 364 View • 2021-07-29 18:26:46
Concatenate Two Columns and Enter Result to Another Column
blackduckie • Desktop • 456 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 • 405 View • 2021-07-29 11:43:34
Sort a Certain Column according to the Specific Order of Key Words It Contains
blackduckie • Desktop • 388 View • 2021-07-28 18:42:11
Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell
blackduckie • Desktop • 461 View • 2021-07-28 18:29:10
Write All Values of the Non-Grouping Field in One Row
blackduckie • Desktop • 361 View • 2021-07-28 18:05:14
Query a Cross Table according to Both Row Value and Column Value
blackduckie • Desktop • 363 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

Recent hot

New group

Contribute open source GitHub