Excel •
258 Reference •
180 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(82) clipboard(13) add-in(10) string split(9) grouping(8) group(7) word extraction(5) csv(4) expand one row to multiple rows(3) distinct(3) row-to-column transposition(2) column-to-row transposition(2) set operation(2) sort(2) data concatenation(2) inter-row(1) batch search(1) regular expression matching(1) concatenation by row number(1) date handling(1) record deletion(1) more>>> intersection(1) aggregate(1) search & selection(1) conditional query(1) topn(1) string generation(1) data search(1) string handling(1) command line(1) text file association(1) difference(1)
excel(82) clipboard(13) add-in(10) string split(9) grouping(8) group(7) word extraction(5) csv(4) expand one row to multiple rows(3) distinct(3) row-to-column transposition(2) column-to-row transposition(2) set operation(2) sort(2) data concatenation(2) inter-row(1) batch search(1) regular expression matching(1) concatenation by row number(1) date handling(1) record deletion(1) more>>> intersection(1) aggregate(1) search & selection(1) conditional query(1) topn(1) string generation(1) data search(1) string handling(1) command line(1) text file association(1) difference(1)
-
-
blackduckie • Excel • 231 View • 2021-07-30 10:54:37
Calculate the Difference of Two White-space-separated Strings
-
blackduckie • Excel • 231 View • 2021-07-30 07:40:55
Find Corresponding Data in the One Table Using the Other Table
-
blackduckie • Excel • 230 View • 2021-07-30 07:23:03
Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them
-
blackduckie • Excel • 231 View • 2021-07-30 06:54:34
Find Values Corresponding to Keys Stored in a Specific Cell
-
-
blackduckie • Excel • 227 View • 2021-07-30 03:07:26
Move Cells Containing Values in the Last Four Columns into Corresponding Rows
-
blackduckie • Excel • 230 View • 2021-07-30 02:47:59
Group Rows and Concatenate Each Value of a Specific Column into a String
-
blackduckie • Excel • 228 View • 2021-07-30 01:56:59
List Values in a Specific Column Whose Occurrences Rank in Top 10
-
blackduckie • Excel • 235 View • 2021-07-29 10:26:46
Concatenate Two Columns and Enter Result to Another Column
-
-
blackduckie • Excel • 227 View • 2021-07-29 03:43:34
Sort a Certain Column according to the Specific Order of Key Words It Contains
-
blackduckie • Excel • 229 View • 2021-07-28 10:42:11
Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell
-
blackduckie • Excel • 236 View • 2021-07-28 10:29:10
Write All Values of the Non-Grouping Field in One Row
-
blackduckie • Excel • 237 View • 2021-07-28 10:05:14
Query a Cross Table according to Both Row Value and Column Value
-
-
blackduckie • Excel • 230 View • 2021-07-28 09:38:23
Get Common Words of Comma-separated Word Strings
-
blackduckie • Excel • 230 View • 2021-07-28 09:17:36
Delete Records Meeting a Specified Condition from a CSV File and Store Them into a New File
-
blackduckie • Excel • 237 View • 2021-07-27 07:23:55
Get the First Friday of the Quarter Containing the Current Date
-
blackduckie • Excel • 239 View • 2021-07-27 03:49:10
Copy Each Row Multiple Times by the Value of a Specific Column
-
blackduckie • Excel • 238 View • 2021-07-27 02:18:45
Search for Each Comma-separated Value from Strings
-
-
blackduckie • Excel • 251 View • 2021-07-23 02:05:14
How to Split a String Containing Different Separators and Enter the Parts to Cells by Column
-
-
blackduckie • Excel • 246 View • 2021-07-22 09:51:11
How to Delete Rows Containing Repeated Values for a Specific Column