Excellll

Excellll has asked 5 questions and find answers to 12 problems.

Stats

About

Excellll questions

Best workaround for VBA Transpose array length limit?
Replace() question mark in image dimensions string from Shell
How can I substitute quotation marks in Excel with SUBSTITUTE formula?

Excellll answers

VBA - UDF handles Arrays differently
Spreadsheet formula to gather all matches into one cell
How to keep leading zero and add comma in openoffice calc formula?
Excel: Search for a list of strings within a particular string using array formulas?
Dynamic cell access
Split Uppercase words in Excel
Generating random numbers with normal distribution in Excel
Draw an Excel Line Chart of my account balance
Excel: SUMIFS to sum values adjacent to text strings contained within a text string
find max or min in excel, with conditions