-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a faint memory of being able to use VBA functions to calculate values in Excel, like this (as the cell formula):
=MyCustomFunction(A3)
Can this be done?
EDIT:
This is my VBA function signature:
Public Function MyCustomFunction(str As String) As String
The function sits in the ThisWorkbook…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Data in TheRange is {1,"",1,"",1,"",1,"",2}
=Match(2, TheRange, 1) returns 9 as expected
=Match(1.5, TheRange, 1) returns 7 as expected
=Match(1, TheRange, 1) returns 5 which is not expected
Anyone come across this ? Anyone got a fix?
Additionally if I use Worksheet.Function.Match in VBA I get…
>>> More
-
as seen on Super User
- Search for 'Super User'
I have a huge Excel table that I need to transform into paragraphs for a Word report, and I can't find an efficient way to do it
The source looks like this:
And I would ultimately need something like this, i.e. through a pivot table. Note that "Item C", which doesn't have any description values…
>>> More
-
as seen on Super User
- Search for 'Super User'
I've got a bit of a problem to solve in Excel, and I'm not quite sure how to go about doing it. I've done a few searches online, and haven't really found any formulas that seem to be useful. Here's the situation (simplified just a bit, for the purpose of this question):
I have data in columns A-E…
>>> More
-
as seen on Super User
- Search for 'Super User'
I have to average grades based on each objective for a new report card we have to complete this year. For example Column one has students names, each additional column will have the objective associated with the assignment. I would like to move the entire column to another sheet for each objective…
>>> More
