Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
452
questions
54
votes
8
answers
203k
views
Excel function that evaluates a string as if it were a formula?
Suppose I have a text string like "11+5" or even "=11+5" stored in a cell. Is there a function in Excel that will allow me to actually evaluate that string as if it were a formula?
This would be ...
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:
...
47
votes
11
answers
723k
views
How to compare two columns and find differences in Excel?
I have two columns in Excel that I want to compare and find the differences between them.
Suppose:
Col A has 50 numbers, i.e. 0511234567
Col B has 100 numbers in the same format
3
votes
3
answers
13k
views
How do I transpose data in columns to rows?
How do I transpose data in columns to rows?
If the data is:
Joe
some city
some state
Bob
no city
no state
and I use Paste Special » Transpose, I get
Joe some city some state Bob no ...
41
votes
8
answers
227k
views
How to count number of distinct values in a range?
I've got a large table that is already organized using filters etc. I'd like to add a summary underneath certain columns that contain the number of distinct values in that column.
There's no ...
21
votes
1
answer
88k
views
What would be the the mathematical equivalent of this excel formula? =PMT()
I need to create a JavaScript form that does the same calculation as this =PMT() function.
mortgage = 220000
rate= 4.75%
term = 30
The example formula I have is =PMT(4.75%/12,30*12,220000*-1)
What ...
6
votes
4
answers
36k
views
How to fill a large series (over 10,000 rows) in Microsoft Excel without dragging or selecting cells?
I have more than 10,000 rows of data I need to do some calculations on one column of the data. I have made the calculation in one cell and now need to fill the formula for the calculation and all the ...
1
vote
1
answer
540
views
Excel – Checking if the content of several cells exists inside one main cell
I have an Excel spreadsheet.
In column A there are some words. In some cases there are multiple words in one cell, separated by decimal points (periods); e.g., university.of.california or school....
1
vote
2
answers
29k
views
Excel - how to either have direct data input or cell value from formula
I would like to either populate a cell value from direct key input or have the cell value derived from a formula.
Example: either directly input a number into cell A4 or have the value for A4 = A2 + ...
0
votes
1
answer
603
views
Count Unique values based on criteria within 2 columns
I hope someone out there has the brains to help me with issue.
I have a spreadsheet that has multiple columns and duplicates. What i want to do is count all the unique values in column A, only if ...
7
votes
5
answers
44k
views
How to add/subtract months from given date in Excel
Here is my scenario:
I have to populate list with dates and some metadata of upcoming events for the following year in my Excel application. Some of the events are occurring on the same day each ...
1
vote
2
answers
47k
views
How to identify cells in Column A that contain any of the values in Column B
First off, I'm not that advanced of an Excel user. I'm certain Excel can do what I'm about to ask, but I've yet to find a way in any of my attempts or searches.
My question is very similar to https://...
125
votes
14
answers
295k
views
Format a number with optional decimal places in Excel
I have numbers in cells in Excel. I want the numbers formatted so that if they have decimal places they show to a maximum of two, and if they have no decimal places it doesn't show any.
For example.
...
40
votes
17
answers
396k
views
How to get the current column name in Excel?
What is the function to get the current line number and the current column name for a cell in Excel?
25
votes
5
answers
82k
views
Can you do Regular Expressions in Excel without VBScript?
I'm looking for an Excel function that I can put in a cell to do a regex search of the contents of another cell. Is there anything available to do this? I'd prefer not to have to add VB Script to ...