All Questions
Tagged with microsoft-excel worksheet-function
7,317
questions
2
votes
3
answers
4k
views
Use regression equation in excel formula
I have a spreadsheet with a number of graphs on, and I have displayed the trend-lines / regression lines on these graphs. These are not simple linear regression lines, but are high order polynomial ...
4
votes
2
answers
30k
views
What's the difference between "vlookup" and "lookup" in Excel?
What is the main basic difference between VLOOKUP and LOOKUP in Excel?
I read the main point is that you can specify a range of columns in VLOOKUP and then pick one to return the value. However, it ...
0
votes
2
answers
746
views
Excel showing error message when typing "- do -"?
Why Microsoft Excel Show an Error Message when typing "--do--"? It show an message "Your Formulae is incomplete".
1
vote
3
answers
1k
views
Excel select column
In excel, if I want to perform a function with the column to the left, how do I go about this?
2
votes
3
answers
611
views
How to update all functions in Excel 2007?
Is there a way to quickly fill down a column of functions. For example, if I change my function from
=3*B2
And then fill down so it does it for a lot of rows.
But then change this column to:
=10*...
0
votes
2
answers
583
views
Sort highest match in excel
How can in Excel sort multiple collumns with data?
Column B = Subscribe date
Column A = Subscribe name
I have multiple columns with a lot of doubles names (A) and different subscribe dates(B)
How ...
4
votes
8
answers
23k
views
How can I calculate the sum of all positive integers less than n?
I have the following function:
f(n) = f(n - 1) + (n - 1)
f(0) = 0
n >= 0
I have n declared on column A, and need the result of f(n) on column B.
I'm trying to find the Excel formula equivalent ...
5
votes
4
answers
15k
views
Using two conditions with a SUMIF function in Excel 2003
For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2.
That will basically summarize all the values on my ...
4
votes
4
answers
20k
views
Excel formula to display a string of text and numbers
I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx
data1 is in column A and data2 is in column B.
the format of data1 needs to be 5 numbers (sometimes ...
1
vote
3
answers
3k
views
Sum Column, but only Filtered Rows
I have a large flat file of a bunch of ungrouped primary key values.
I want to filter on a key and populate cell A1 with the value selected from the dropdown list.
In the end, I want to see a sum of ...
7
votes
4
answers
11k
views
How do I get a reference to the last occurrence of a value in an array in Excel?
So if
A1:A5 = {3, 3, 4, 4, 5}
what function could I put into B1 to get a reference to A4 (the cell containing the last occurrence of 4)?
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.
...