All Questions
Tagged with microsoft-excel worksheet-function
7,324
questions
1
vote
1
answer
390
views
Summing custom labeled cells in Excel 2010
I have a sheet that I'm calculating particular costs. These costs have associated labels to them: Manufacturing, Variable, Both, Neither. I have created a drop down list for next to the costs that ...
- 26.4k
6
votes
6
answers
29k
views
In Excel, how to fill down consecutive integers following a pattern 1, 1, 2, 2,
In Excel, I know how to use the "fill down" feature to populate a column of sequential numbers.
I would like to do this but following a pattern like:
1
1
2
2
3
3
Does anyone know how to do this? I ...
4
votes
3
answers
26k
views
Average of cells that match criteria and removing duplicates in Excel
I have an Excel spreadsheet where I want to remove the duplicate names and take an average for each person's score. I have a list of the following type:
Al 1
Bob 1
Bob 2
Bob 1
Joe 4
...
4
votes
2
answers
3k
views
Excel conditional formatting based on a formula
I would like to use Excel's conditinal formatting of a particular column based on values in two other columns.
I have values in columns A, B, C and D.
column A has text values (any value user enters)
...
- 2,046
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 ...
- 758
4
votes
2
answers
7k
views
Summing a column in the same column without a circular reference
In Excel you can sum a whole column with =SUM(B:B). But of course you can't use that formula in the column you want to sum, because you'll get a circular reference.
Is there an easy way of summing ...
- 8,522
2
votes
2
answers
2k
views
Excel: ROUND() to the next unit of 5?
I'm creating a lot of graphs, so I'm making a common scale to be able to compare them using MAX/MIN values that I'm hiding in the graph as a separate series. My Vertical AXIS (Y) is in units of 5.
...
- 1,538
0
votes
2
answers
857
views
In Excel; Can LOOKUP return more than one cell as a result?
Lookup has two different usage:
Lookup( value, array )
and
Lookup( value, lookup_range, result_range )
I want to return more than one cell when it found the value.
Like:
=LOOKUP(A17;'Products'!A:...
- 249
2
votes
2
answers
6k
views
How can I manipulate the result of VLOOKUP function?
If VLOOKUP doesn't find a match, it returns something that looks like "#____".
However, I want to manipulate the VLOOKUP formula not to write anything in the cell if it doesn't find a match. (This ...
- 249
2
votes
3
answers
73k
views
How can I combine these 3 conditions in a single Excel formula?
I need to create an excel formula based on the following:
1. If Cell >= 500 Then the Cell text should be "Critical"
2. If Cell >= 400 Then the cell text should be "Medium"
3. If cell < 400 ...
- 751
3
votes
4
answers
3k
views
Averages spread out over several fields in Excel?
I have a table with a sequence of data.
This data is used in a graph.
There are holes in this data that I want to fill in with smoothed out numbers.
Take this table for example:
In the example ...
- 765
2
votes
2
answers
2k
views
Excel: Counting the number of text strings
I have a column in a spreadsheet which lists the status of particular rows - the statuses are text strings like "accepted" "rejected" and so on.
Is there any formula I can use to count the number of ...
- 419
8
votes
3
answers
9k
views
Is there a way to give an Excel table a name that is worksheet-scoped instead of workbook-scoped?
When you create a table in Excel (I'm using Excel 2007) you can give it a name that shows up in the Name Manager dialog. However, the name has workbook scope. I'd like to have a table with a name ...
- 547
0
votes
3
answers
3k
views
Excel: How to sum values in a column based on multiple criteria
I have a list of criteria in row 20, like this:
A20: "My Company, Inc."
B20: "Client Expenses"
C20: "Travel"
The data is below, like this:
B40: "Client Expenses"
C40: "My Company, Inc."
D40: "...
- 663
3
votes
2
answers
10k
views
How do I copy a worksheet without creating local copies of workbook-scoped named formulas?
I have a workbook with some workbook-scoped named formulas. When I copy a worksheet that has some (different) worksheet-scoped names, the copy ends up also having worksheet-scoped names that are ...
- 547