Analyst •
289 Reference •
196 Reply •
1 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(106) clipboard(13) order-based calculation(12) excel handling(10) add-in(10) string split(9) grouping(8) csv(4) inter-row calculation(4) transposition(4) merge(3) distinct(3) data rearrangement(3) conditional grouping(3) difference operation(3) locate calculation(2) file comparison(2) file merge(2) concateantion(1) time series(1) sequence(1) more>>> number extraction(1) vba(1) position-based retrieval(1) post-grouping row-to-column transposition(1) record location(1) member location(1)
excel(106) clipboard(13) order-based calculation(12) excel handling(10) add-in(10) string split(9) grouping(8) csv(4) inter-row calculation(4) transposition(4) merge(3) distinct(3) data rearrangement(3) conditional grouping(3) difference operation(3) locate calculation(2) file comparison(2) file merge(2) concateantion(1) time series(1) sequence(1) more>>> number extraction(1) vba(1) position-based retrieval(1) post-grouping row-to-column transposition(1) record location(1) member location(1)
-
blackduckie • Analyst • 351 View • 2021-07-19 06:02:34
Check Whether There Are Missing Time Points in a Certain Interval
-
-
blackduckie • Analyst • 216 View • 2021-07-16 07:08:37
How to Move a Cell Value and Delete the Empty Row
-
blackduckie • Analyst • 213 View • 2021-07-16 05:49:44
How to Convert Every Column under Same Category Column into a Row
-
blackduckie • Analyst • 215 View • 2021-07-15 09:55:11
How to Get Directory Names in the 6th level of a Specified Path String
-
-
-
blackduckie • Analyst • 189 View • 2021-07-15 08:10:28
Add Proportions of Subcategories on the Right of a Table with Group and Aggregate Vales
-
-
blackduckie • Analyst • 212 View • 2021-07-14 02:13:17
Compare Two Rowwise Worksheets to Get Their Differences
-
blackduckie • Analyst • 221 View • 2021-07-13 10:10:50
Get the Maximum from a Comma-separated String of Numbers
-
blackduckie • Analyst • 232 View • 2021-07-13 09:41:04
Look up a Multi-column Excel Code Table & Return a Specific Value from Lookup Location
-
-
blackduckie • Analyst • 242 View • 2021-07-13 04:14:26
How to Split and Rearrange Strings of KV Format ({key}value)
-
blackduckie • Analyst • 188 View • 2021-07-12 09:13:24
List All Time Points within a Specific Period according to the Specified Interval
-
-
blackduckie • Analyst • 231 View • 2021-07-09 01:55:07
Generate Strings of Sequences of Natural Numbers from Start and End numbers
-
blackduckie • Analyst • 200 View • 2021-07-08 08:36:33
Query Sequences to Populate Transposed Values to Another Worksheet
-
-
blackduckie • Analyst • 182 View • 2021-07-08 06:21:57
Find Positions of Values and Then Get Corresponding Values by Positions
-
-
-
-
blackduckie • Analyst • 249 View • 2021-07-07 02:26:16
Align Two CSV Files by a Specific Column to Compare and Output the Differences
-
blackduckie • Analyst • 264 View • 2021-07-06 09:57:44
Row-to-column Transposition after Two-level Grouping