|
|
Average more than 30 numeric arguments by
~SB
I need help on how to average more than 30 numbers in a single column when
the numbers are not in contiguous rows. Excel tells me I can only have 1 to
30...
|
|
8 |
146 |
|
|
comparing columns by
~Q
how do i compare a Cell A1 in Worksheet 1 to the whole Column B in Worksheet
2 to see if part of any of the contents in Cell A are anywhere in the list...
|
November 17th, 2005 07:41 PM
by Kleev
|
1 |
89 |
|
|
Formula Help IF? by
~Natasha~
I am in need of some help.
I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7...
|
|
7 |
116 |
|
|
Text box character limit issue by
~L
I'm working with a spreadsheet that has automatic calculation disabled
because a large number of UDF database lookups refer to one cell and
recalculating the...
|
November 13th, 2008 06:52 PM
by ~L
|
0 |
71 |
|
|
Index if conditional sum equals a value. by
~L
I have several columns of data. Column A is names, column B is hours, column
C is dates.
I'm looking for a formula that returns the date when the sum of...
|
|
2 |
48 |
|
|
Sumproduct Excluding Array by
~L
Hi,
I have a list of names and a list of names with a list of values and I'm
using Sumproduct to compare the two and give the sum of the values for each...
|
December 20th, 2006 09:07 PM
by T. Valko
|
6 |
52 |
|
|
|
September 26th, 2006 07:28 PM
by Biff
|
9 |
165 |
|
|
Range of a merged cell by
~L
Is there a function that returns the range covered by merged cells? For
example, if A1 through A5 are merged, what function would return A1:A5 if one
of the...
|
September 14th, 2006 07:21 PM
by ~L
|
0 |
93 |
|
|
Formula help by
~Jeff~
I want to calculate the monthly mortgage payment in my spreadsheet. The
interest rate is fixed
Cell values:
A4 = principle
A5 = interest rate
A6 = years of...
|
|
3 |
190 |
|
|
Monthly payment cells by
~Jeff~
If I have a starting cell equal to say: 8/1/2004
I would like each cell under that one to show the 1st of the next month. If
I change the starting cell, the...
|
|
2 |
100 |
|
|
Time formula help by
~Jeff~
I have a cell that equals the remaining number of hours of vacation pay. I
would like to have a cell next to that that would indicate how many work
days are...
|
|
2 |
91 |
|
|
Concatenation question by
~C
I have four feilds, First, Middle, Last and Email. I want to use a
concatenation function in Email to combine First middle and last and
automatically add the...
|
|
1 |
75 |
|
|
Summing lookup values by
~C
I have a spreadsheet and I need to use a VLookup that then sums the returned
values that repeat. Below is an example, where Ashish shows up 3 times in...
|
|
4 |
67 |
|
|
If cell is not blank, then line out row by
~C
I have a spreadsheet. When I enter in a date in the "Date Reply Sent"
column, the issue is now closed. I would like that row to line out. Is
there a way to...
|
|
1 |
77 |
|
|
|
|
12 |
200 |
|
|
|
May 2nd, 2006 02:09 PM
by ~C
|
2 |
89 |
|
|
Combining Worksheets into one by
~C
A client emails me a worksheet with to indicate which duplicate records need
to be deleted. The client has multiple locations, so each location fills
marks...
|
February 2nd, 2006 03:29 PM
by ~C
|
2 |
93 |
|
|
Excel Reference or VLookup? by
~Brenda
I am using Excel 2000. I have a spreadsheet that has some
calculations that are simple totaling of columns.
Rather than rekey that total on another...
( 1 2)
|
July 20th, 2004 11:57 PM
by Don
|
10 |
290 |
|
|
Ignoring zero cells in IF statements by
~Andy~
Hi all - I'm not sure if it's an IF statement I need - but if it is then
I would like to know how to ignore cells with zero as the number.
Let me explain...
|
November 29th, 2005 02:20 PM
by SteveG
|
5 |
95 |
|
|
Navigating by
~ One Fine Old Dude
I minimize Excel and size it so it uses 1/2 of my monitor window. I open
another window in the other half so I can copy data from this to Excel.
On...
|
|
0 |
61 |