Desktop •
360 Reference •
166 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(115) order-based calculation(12) split(10) transpose(9) group(7) join(4) expand one row to multiple rows(3) merge(3) text files(3) interval query(2) file comparison(2) sql(2) intersection operation(1) duplicate ranks(1) caculate(1) big data(1)
excel(115) order-based calculation(12) split(10) transpose(9) group(7) join(4) expand one row to multiple rows(3) merge(3) text files(3) interval query(2) file comparison(2) sql(2) intersection operation(1) duplicate ranks(1) caculate(1) big data(1)
-
blackduckie • Desktop • 1 Reply 402 View • 2020-12-31 02:59:33
Compare Adjacent Rows and Group Data by a Specific Interval
-
-
-
blackduckie • Desktop • 1 Reply 441 View • 2021-01-06 02:39:47
Dynamically Query the Interval a Given Value Belongs to in Excel
-
blackduckie • Desktop • 1 Reply 435 View • 2021-01-06 03:00:51
Split and Expand Multiline Words in an Excel Cell into Multiple Rows
-
blackduckie • Desktop • 1 Reply 411 View • 2021-01-07 01:10:18
How to Perform Different Types of JOINs on Two Excel Sheets
-
blackduckie • Desktop • 1 Reply 425 View • 2021-01-08 02:49:09
How to Extract Numbers from Excel Cells
-
-
blackduckie • Desktop • 1 Reply 471 View • 2021-01-11 04:20:00
Get Intersection of Two Filtered Subsets in Excel
-
blackduckie • Desktop • 1 Reply 432 View • 2021-01-11 07:27:41
Get Random Small Samples from a Huge Text File
-
-
blackduckie • Desktop • 1 Reply 441 View • 2021-01-11 10:11:21
Convert Regular Text Data into Excel Data
-
blackduckie • Desktop • 1 Reply 382 View • 2021-01-12 00:55:18
Split a String by Comma and Get Desired Values for Each Substring
-
blackduckie • Desktop • 1 Reply 441 View • 2021-01-12 02:15:13
How to Get Differences between Two Excel Sheets
-
blackduckie • Desktop • 1 Reply 425 View • 2021-01-12 07:12:49
Convert a Crosstab to a Row-wise Table
-
blackduckie • Desktop • 1 Reply 581 View • 2020-11-11 09:27:48
Get Values from Same Group by Relative Position in Excel
-
blackduckie • Desktop • 1 Reply 499 View • 2020-11-12 07:24:31
Group & Summarize Excel Data with a Scripting Language
-
blackduckie • Desktop • 1 Reply 512 View • 2020-11-12 07:26:55
Dynamically Parse Expressions That Contain Cell Variables
-
blackduckie • Desktop • 1 Reply 534 View • 2020-11-12 07:30:55
Group & Summarize a Big Excel File Every N Rows
-
-
blackduckie • Desktop • 1 Reply 513 View • 2020-12-02 06:05:30
How to Use SQL to Query Data in Excel
-
blackduckie • Desktop • 1 Reply 457 View • 2020-12-03 10:12:06
Get the Previous & Next Row of Same Group without Sorting the Excel Data
-
blackduckie • Desktop • 1 Reply 461 View • 2020-12-04 08:37:33
Group & Summarize an XLS file without Using Excel
-
blackduckie • Desktop • 1 Reply 492 View • 2020-12-04 09:21:54
Execute Excel-like Formulas outside Excel
-
blackduckie • Desktop • 1 Reply 361 View • 2020-12-06 08:32:59
Directly Query Excel/Text Files Using SQL