Analyst •
288 Reference •
196 Reply •
1 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(105) clipboard(13) order-based calculation(12) excel handling(10) add-in(10) string split(9) grouping(8) group(7) word extraction(5) csv(4) inter-row calculation(4) join(4) expand one row to multiple rows(3) distinct(3) conditional grouping(3) align(2) row-to-column transposition(2) sort(2) get maximum/minimum(2) column-to-row transposition(2) date handling(2) more>>> set operation(2) search & selection(1) intersection(1) regular expression matching(1) inter-row(1) order-based grouping(1) aggregate(1) concatenation by row number(1) record deletion(1) batch search(1)
excel(105) clipboard(13) order-based calculation(12) excel handling(10) add-in(10) string split(9) grouping(8) group(7) word extraction(5) csv(4) inter-row calculation(4) join(4) expand one row to multiple rows(3) distinct(3) conditional grouping(3) align(2) row-to-column transposition(2) sort(2) get maximum/minimum(2) column-to-row transposition(2) date handling(2) more>>> set operation(2) search & selection(1) intersection(1) regular expression matching(1) inter-row(1) order-based grouping(1) aggregate(1) concatenation by row number(1) record deletion(1) batch search(1)
-
blackduckie • Analyst • 245 View • 2021-07-29 03:43:34
Sort a Certain Column according to the Specific Order of Key Words It Contains
-
blackduckie • Analyst • 225 View • 2021-07-28 10:42:11
Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell
-
blackduckie • Analyst • 251 View • 2021-07-28 10:29:10
Write All Values of the Non-Grouping Field in One Row
-
blackduckie • Analyst • 191 View • 2021-07-28 10:05:14
Query a Cross Table according to Both Row Value and Column Value
-
blackduckie • Analyst • 201 View • 2021-07-28 09:55:08
Auto-delete Empty Detailed Rows after Grouping
-
blackduckie • Analyst • 224 View • 2021-07-28 09:38:23
Get Common Words of Comma-separated Word Strings
-
-
blackduckie • Analyst • 184 View • 2021-07-27 07:23:55
Get the First Friday of the Quarter Containing the Current Date
-
blackduckie • Analyst • 220 View • 2021-07-27 03:49:10
Copy Each Row Multiple Times by the Value of a Specific Column
-
blackduckie • Analyst • 211 View • 2021-07-27 02:18:45
Search for Each Comma-separated Value from Strings
-
-
-
-
blackduckie • Analyst • 163 View • 2021-07-22 09:51:11
How to Delete Rows with Duplicates in a Specific Column
-
blackduckie • Analyst • 257 View • 2021-07-22 05:49:46
How to Extract the First Two Words from a White-space-separated String
-
-
-
-
blackduckie • Analyst • 1 Reply 311 View • 2021-07-20 09:40:22
How to Split a String by Delimiter and Populate Members to a Certain Area
-
blackduckie • Analyst • 199 View • 2021-07-20 08:35:19
How to Calculate the Proportion of Specified Data in a Row
-
blackduckie • Analyst • 196 View • 2021-07-20 08:24:18
How to Enter Combined Values in the Empty Row after Continuous Rows
-
blackduckie • Analyst • 182 View • 2021-07-20 06:33:15
How to Extract a Substring of a Specified Format from a String
-
blackduckie • Analyst • 237 View • 2021-07-19 10:28:48
Perform Inter-row Calculations within Each Category
-
blackduckie • Analyst • 197 View • 2021-07-19 08:40:14
Align Two Excel Tables by Positions in Corresponding Groups
-
blackduckie • Analyst • 351 View • 2021-07-19 06:02:34
Check Whether There Are Missing Time Points in a Certain Interval