Analyst •
284 Reference •
196 Reply •
1 Follow
Follow
-
blackduckie • Analyst • 1 Reply 1,326 View • 2020-12-08 11:53:50
Extract Data from a Specifically-patterned TXT File to Export to Excel
-
-
blackduckie • Analyst • 1 Reply 265 View • 2020-12-06 08:32:59
Directly Query Excel/Text Files Using SQL
-
blackduckie • Analyst • 1 Reply 362 View • 2020-12-04 09:21:54
Execute Excel-like Formulas outside Excel
-
blackduckie • Analyst • 1 Reply 338 View • 2020-12-04 08:37:33
Group & Summarize an XLS file without Using Excel
-
blackduckie • Analyst • 1 Reply 342 View • 2020-12-03 10:12:06
Get the Previous & Next Row of Same Group without Sorting the Excel Data
-
blackduckie • Analyst • 1 Reply 385 View • 2020-12-02 06:05:30
How to Use SQL to Query Data in Excel
-
-
blackduckie • Analyst • 1 Reply 380 View • 2020-11-12 07:30:55
Group & Summarize a Big Excel File Every N Rows
-
blackduckie • Analyst • 1 Reply 391 View • 2020-11-12 07:26:55
Dynamically Parse Expressions That Contain Cell Variables
-
blackduckie • Analyst • 1 Reply 384 View • 2020-11-12 07:24:31
Group & Summarize Excel Data with a Scripting Language
-
blackduckie • Analyst • 1 Reply 442 View • 2020-11-11 09:27:48
Get Values from Same Group by Relative Position in Excel