Analyst •
294 Reference •
196 Reply •
1 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(109) clipboard(13) order-based calculation(12) excel handling(10) add-in(10) string split(9) grouping(8) word extraction(5) csv(4) inter-row calculation(4) join(4) transposition(4) expand one row to multiple rows(3) merge(3) distinct(3) conditional grouping(3) difference operation(3) align(2) row-to-column transposition(2) get maximum/minimum(2) regular expression matching(1) more>>> inter-row(1) vba(1) order-based grouping(1) record location(1) batch search(1)
excel(109) clipboard(13) order-based calculation(12) excel handling(10) add-in(10) string split(9) grouping(8) word extraction(5) csv(4) inter-row calculation(4) join(4) transposition(4) expand one row to multiple rows(3) merge(3) distinct(3) conditional grouping(3) difference operation(3) align(2) row-to-column transposition(2) get maximum/minimum(2) regular expression matching(1) more>>> inter-row(1) vba(1) order-based grouping(1) record location(1) batch search(1)
-
blackduckie • Analyst • 223 View • 2021-07-27 03:49:10
Copy Each Row Multiple Times by the Value of a Specific Column
-
-
-
blackduckie • Analyst • 168 View • 2021-07-22 09:51:11
How to Delete Rows with Duplicates in a Specific Column
-
blackduckie • Analyst • 264 View • 2021-07-22 05:49:46
How to Extract the First Two Words from a White-space-separated String
-
-
-
-
blackduckie • Analyst • 1 Reply 318 View • 2021-07-20 09:40:22
How to Split a String by Delimiter and Populate Members to a Certain Area
-
blackduckie • Analyst • 205 View • 2021-07-20 08:35:19
How to Calculate the Proportion of Specified Data in a Row
-
blackduckie • Analyst • 207 View • 2021-07-20 08:24:18
How to Enter Combined Values in the Empty Row after Continuous Rows
-
blackduckie • Analyst • 189 View • 2021-07-20 06:33:15
How to Extract a Substring of a Specified Format from a String
-
blackduckie • Analyst • 242 View • 2021-07-19 10:28:48
Perform Inter-row Calculations within Each Category
-
blackduckie • Analyst • 202 View • 2021-07-19 08:40:14
Align Two Excel Tables by Positions in Corresponding Groups
-
-
blackduckie • Analyst • 225 View • 2021-07-16 07:08:37
How to Move a Cell Value and Delete the Empty Row
-
blackduckie • Analyst • 222 View • 2021-07-16 05:49:44
How to Convert Every Column under Same Category Column into a Row
-
blackduckie • Analyst • 226 View • 2021-07-15 09:55:11
How to Get Directory Names in the 6th level of a Specified Path String
-
-
-
blackduckie • Analyst • 196 View • 2021-07-15 08:10:28
Add Proportions of Subcategories on the Right of a Table with Group and Aggregate Vales
-
-
blackduckie • Analyst • 221 View • 2021-07-14 02:13:17
Compare Two Rowwise Worksheets to Get Their Differences
-
blackduckie • Analyst • 225 View • 2021-07-13 10:10:50
Get the Maximum from a Comma-separated String of Numbers
-
blackduckie • Analyst • 240 View • 2021-07-13 09:41:04
Look up a Multi-column Excel Code Table & Return a Specific Value from Lookup Location