Moving rows with multiple criteria
Tue, 8 Jul 2008 18:59:00 -0700
I have a spreadsheet with many rows and columns (rows will grow over time).
I am interested in filtering one column with multiple criteria (i.e. 50
different values may be possible). Is this possible? If so, how.
Two problems I face is: How do I create the formula w/ multiple values? Is
there a limit. ...
|
Is there an INDIRECT function for a RANGE?
Tue, 8 Jul 2008 18:12:00 -0700
I'm trying to find the equivalent of the INDIRECT function, but instead of a
cell location, I'd like to "build" a Range. As an example, I'd like to
convert the following text, "CONCATENATE("Sheet","'!A1:B4") to a range that
Excel can understand. If this were simply a cell reference, then the text
string co ...
|
how do I copy and paste a drop down list in excel?
Tue, 8 Jul 2008 17:49:01 -0700
I have a drop down list in cell A1 and I need to copy and paste that list all
the way down to A200. Copying and pasting is not working nor is dragging
down the corner of the cell. Help! ...
|
Find a color value
Tue, 8 Jul 2008 17:04:01 -0700
Gâ??Day,
I have a worksheet which users can change the color of a particular cell â??
assume C3. What I want to do is change the color of another worksheet tab
(within the same workbook) to match the cell color of C3.
Can anyone help?
Cheers
Scott ...
|
Sum below a specific row
Tue, 8 Jul 2008 16:49:02 -0700
I am attempting to use the SUM function to add values below a certain row? I
know that SUM(A:A) can be used to add every value in the column, and
SUM(A1:A5) can be used to add values in a defined range.
What do I do if I only know one of the values in my range? For example, I'd
like to be able to add the v ...
|
Nested if's and lookup
Tue, 8 Jul 2008 16:40:01 -0700
I need help converting this statement into an excel formula:
If I have a name in one worksheet and I want to look up the name in another
worksheet to find out a certain code and based on that code, I want to do a
calculation it it is blank and if it's not I want a 0.
For example: Worksheet 1 contains a list ...
|
how to copy excel carriage return to notepad w/out the quotations
Tue, 8 Jul 2008 16:37:05 -0700
How do I copy the carriage return [char(10) or char(32) or alt+enter] and
paste it into notepad without having the quotation marks surround it? ...
|
|
|
Hide a sheet with a variable name
Tue, 8 Jul 2008 16:32:01 -0700
G'Day
I am trying to hide a sheet(s) based on a cell value. I have found an old
post thats uses:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim sh As Worksheet
If Not Application.Intersect(Range("B8"), Target) Is Nothing Then
For Each sh In Sheets(Array("Sheet2"))
If ...
|
XIRR FUNCTION
Tue, 8 Jul 2008 16:14:00 -0700
USING THE FINANCIAL FUNCTION i AM TRYING TO CALCULATE THE ANNUAL RATE OF
RETURN FOR THE LAST QUARTER FOR A FUND. FILLING IN THE ARGUMENTS FOR THE
FUNCTION i GET THE FOLLOWING
"=XIRR("-83948.81:84568.12",(4/1/6:2008/30/2008),0.1)" THE FIRST VALUE IS THE
BEGINNING MARKET VALUE AND THE SECOND VALUE IS THE ENDIN ...
|
WHat is wrong with this formula
Tue, 8 Jul 2008 15:54:01 -0700
=IF('11th game'!B(MATCH(A2,'11th game'!B20:B34,0)+19)=Sheet1!A2,COUNTIF('11th
game'!C25:N25,Sheet1!C1),)
11th game is a worksheet name. Excel does not like '11th game'!B The
MATCH returns what I expect. Any help is appreciated. ...
|
