|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
1 |
723 |
|
|
Formula request by
~~~AAA~~~
I am trying to set up a formula each time the data changes in column A
without having to do it manually.
The formula would be using two other columns of data...
|
September 14th, 2006 05:05 AM
by Biff
|
1 |
66 |
|
|
|
November 27th, 2006 07:46 PM
by ¦@²£ÄÒ
|
0 |
113 |
|
|
|
June 22nd, 2007 01:22 PM
by ¦óÄ_Às
|
0 |
80 |
|
|
|
August 15th, 2009 03:48 AM
by ¦¿°¶±j
|
0 |
178 |
|
|
|
December 13th, 2007 12:51 AM
by Pete_UK
|
2 |
86 |
|
|
|
August 9th, 2006 04:41 PM
by ªËªË
|
0 |
77 |
|
|
|
April 24th, 2004 03:53 PM
by ???
|
2 |
162 |
|
|
|
|
0 |
112 |
|
|
¤J¾¤À°±æ by
±þÀs¦â¡@
¦¬Å¥ÂI¼Ëª±¤k¤k!
+86 13925265554
|
|
0 |
114 |
|
|
¤J¾¤À°±æ by
±þÀs¦â¡@
¦¬Å¥ÂI¼Ëª±¤k¤k!
+86 13925265554
|
|
0 |
62 |
|
|
Midnight will not display in cell by
·!¦[··ï¡?¡ï·»Gen°Digger«·ï¡?¡ï··]¦!·
Ok... jeepers.. another problem... ggrrrr
When I enter the time of midnight using military format 24:00, or using 0:00, it does not display in the cell, but...
|
|
3 |
89 |
|
|
|
|
13 |
177 |