-
blackduckie • Analyst • 219 View • 2021-07-30 07:23:03
Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them
-
blackduckie • Analyst • 274 View • 2021-07-30 06:54:34
Find Values Corresponding to Keys Stored in a Specific Cell
-
blackduckie • Analyst • 226 View • 2021-07-30 06:38:22
Sum up Key Value Pairs and Concatenate Results
-
blackduckie • Analyst • 221 View • 2021-07-30 03:07:26
Move Cells Containing Values in the Last Four Columns into Corresponding Rows
-
blackduckie • Analyst • 196 View • 2021-07-30 02:47:59
Group Rows and Concatenate Each Value of a Specific Column into a String
-
blackduckie • Analyst • 200 View • 2021-07-30 01:56:59
List Values in a Specific Column Whose Occurrences Rank in Top 10
-
blackduckie • Analyst • 223 View • 2021-07-29 10:26:46
Concatenate Two Columns and Enter Result to Another Column
-
-
blackduckie • Analyst • 238 View • 2021-07-29 03:43:34
Sort a Certain Column according to the Specific Order of Key Words It Contains
-
blackduckie • Analyst • 218 View • 2021-07-28 10:42:11
Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell
-
blackduckie • Analyst • 246 View • 2021-07-28 10:29:10
Write All Values of the Non-Grouping Field in One Row
-
blackduckie • Analyst • 184 View • 2021-07-28 10:05:14
Query a Cross Table according to Both Row Value and Column Value
-
blackduckie • Analyst • 197 View • 2021-07-28 09:55:08
Auto-delete Empty Detailed Rows after Grouping
-
blackduckie • Analyst • 222 View • 2021-07-28 09:38:23
Get Common Words of Comma-separated Word Strings
-
-
blackduckie • Analyst • 181 View • 2021-07-27 07:23:55
Get the First Friday of the Quarter Containing the Current Date
-
blackduckie • Analyst • 212 View • 2021-07-27 03:49:10
Copy Each Row Multiple Times by the Value of a Specific Column
-
blackduckie • Analyst • 203 View • 2021-07-27 02:18:45
Search for Each Comma-separated Value from Strings
-
-
-
-
blackduckie • Analyst • 160 View • 2021-07-22 09:51:11
How to Delete Rows with Duplicates in a Specific Column
-
blackduckie • Analyst • 254 View • 2021-07-22 05:49:46
How to Extract the First Two Words from a White-space-separated String
-
-
Recent hot
- Foreign-key pre-join(JOIN Simplification and Acceleration Series 6)
- SPL Programming Exercise - Chapter 2 Doing Judgment
- SPL Programming Exercise - Chapter 3 Doing loop
- More foreign-key joins (JOIN Simplification and Acceleration Series 7)
- Excel How to Split a String by Delimiter and Populate Members to a Certain Area
- Excel How to Enter Combined Values in the Empty Row after Continuous Rows
- Excel Check Whether There Are Missing Time Points in a Certain Interval
- Excel How to Move a Cell Value and Delete the Empty Row
- Excel How to Convert Every Column under Same Category Column into a Row
- Excel Generate a Unique ID for Each Category