All Questions
Tagged with worksheet-function vba
575
questions
1
vote
4
answers
421
views
Determining whether VBA is necessary in Excel, or if a pivot chart/table can suffice
I wish that I had a more precisely descriptive title for this question, but I am not very knowledgeable with Excel spreadsheets or VBA (I'm primarily a Java developer, and don't play much in the ...
5
votes
6
answers
12k
views
Is there a way to tell which cells reference a selected cell in Excel?
In Excel, you can tell a cell to reference another cell in order to calculate its value. I'd like to be to do the opposite, to get any cells that reference the currently-selected cell. Is this at all ...
1
vote
3
answers
6k
views
How to input only unique values in a column in Excel 2007
I'd like to know the easiest way to make sure that only unique strings are entered in a particular column in MS Excel 2007? I know I have to put a formula in the Data > Data Validation, but I don't ...
1
vote
1
answer
233
views
Replicating common Excel Functions
I am always curious how some of the functions I use in excel were written, and think it would help at times to see how it was done.
Does anyone know where there is example vba that replicates what ...
2
votes
1
answer
208
views
Return the date of the day under an if formula with Excel or VBA
I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the ...