All Questions
527
questions
16
votes
7
answers
62k
views
Custom Formula Not Updating
I followed this guide to create the following custom function which counts the number of cells of a certain colour in my spreadsheet:
Function ColorFunction(rColor As Range, rRange As Range, Optional ...
13
votes
5
answers
18k
views
Custom user function without using VBA
Is it possible to create a custom user function in Excel without using VBA?
My problem is I have a long string of standard excel functions strung together to make one very long function.
This function ...
12
votes
3
answers
399k
views
Searching for a value in Excel, returning yes or no
I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...
11
votes
5
answers
214k
views
How to combine values from multiple rows into a single row in Excel?
I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
...
9
votes
2
answers
24k
views
How can I turn a Calculated Column back into a data column in an Excel Table?
I have a large Excel Table (44 columns, 1000+ rows), but one of the columns has been accidentally turned into a Calculated Column (See Here). The result being that now when the users try to add new ...
7
votes
3
answers
19k
views
How do I download a stock price in Excel 2013? Is there an equivalent to Google Doc's GoogleFinance spreadsheet function?
In a Google Docs spreadsheet, I can use this cell formula:
=GoogleFinance("GOOG", "price")
to download the latest price of a stock. Is there an equivalent function in Excel 2013?
Earlier versions ...
6
votes
5
answers
16k
views
How to return everything between two characters in Excel?
I'm a programmer with lots of languages, but somehow I've never learned Excel macro or formula language. I'm sure there must be a simple way to do this, but I'm stumped.
I have a column of file names ...
6
votes
3
answers
1k
views
Count unique value ignoring Text in range
123
562
My Data
548
K166
You
1548
123
562
100
My Data
100
I want to count unique values by ignoring text in the above shown list.
For this I've tried an array formula, {=SUM(1/Countif(,,,,))} but it'...
6
votes
3
answers
2k
views
How to find and replace the character “*” in excel text values in cell, but NOT formulas
Very similar to this question:
How to find and replace the character "*" in Excel
But I need to leave formulas untouched.
I've got about 50+ sheets that have two types of cells with "*"
...
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 ...
4
votes
1
answer
3k
views
Excel format from mm/dd/yyyy to mm-dd-yyyy
I am trying to convert a date from a format with slashes to one with dashes. however when i try:
=SUBSTITUTE(B3,"/","-")
It converts my the would-be date into a date integer. I have tried formatting ...
4
votes
1
answer
307
views
Extract number from complex string if it falls in a given range
I need an Excel formula (or VBA macro) that will allow me to extract a value
from a string. The string is a sequence of words, separated by spaces, in a single cell. I want the word (representing a ...
4
votes
1
answer
41k
views
Add/Subtract button Excel VBA
Here is an example of my project in this picture
I like collecting, so I am making an inventory sheet in Excel.
I want to make a way that I can click a button and it affects the next, or previous ...
4
votes
1
answer
13k
views
Prevent Excel 2010 user from pasting formatting into cell
Is there a way to lock a cell so that a user can copy/paste a value into it, but not copy formatting to it? Locking the worksheet doesn't prevent the user from changing the formatting of the cell by ...
4
votes
1
answer
7k
views
In Excel, doing a "Freeze Panes" on the right-most column instead of the left-most?
My understanding of Excel's "Freeze Panes" feature is that you can only freeze the left-most column(s), or top-most row(s).
However, I have a table where a very important column needs to be located ...