Only for questions on programming against Excel objects or files, or complex formula development.
Does anyone have an Excel VBA function which can return the column letter(s) from a number? For example, entering 100 …
excel vba excel-udfI have an Excel sheet with first names in Column A and surnames in Column B. I want to create …
excel excel-formulaThis is one of those things that I'm sure there's a built-in function for (and I may well have been …
excel vba loops excel-2003I have an Excel spreadsheet containing a list of strings. Each string is made up of several words, but the …
excel excel-formulaI'm trying to create a sub-table from another table of all the last name fields sorted A-Z which have a …
sql excel filteringDo you know a way in Excel to "calculate" by formula a list of unique values ? E.g: a vertical …
excel excel-formulaI have an Excel spreadsheet that I want to import select columns into my SQL Server 2008 database table. The wizard …
sql-server excel sql-server-2008 import etlThe problem is that != does not work as a function in excel vba. I want to be able to use …
excel vba function syntax inequalityIs it possible to iterate (loop) a group of rows in Excel without VBA or macros installed? A web search …
excel excel-formulaIn a cell in Excel sheet I have a Date value like: 01/01/2010 14:30:00 I want to convert that Date to Text …
excel excel-formula