|
|
|
May 13th, 2005 11:10 PM
by Max
|
20 |
276 |
|
|
COUNTIF in between rows by
Vasilis Tergen
How would I find the maximum amount of intervals between
"Larry" re- appearing in column A?
I must use a formula- not a macro or a filter.
The correct answer...
( 1 2 3)
|
|
20 |
176 |
|
|
Compare columns, count matches by
adodson
I'm looking to compare two lists (a1:a10 compared to b1:b10, unnamed). Then,
return the count of original matches between the two lists. For example, if...
( 1 2 3)
|
|
20 |
233 |
|
|
|
|
20 |
193 |
|
|
|
|
20 |
200 |
|
|
If/Then Statement by
Karen
I need help with an IF/THEN statement if anyone can be so kind.
The formula will be placed in column U.
In column F there could be a number 1, 2, 3, 4 or...
( 1 2 3)
|
August 14th, 2007 06:53 PM
by Pete_UK
|
20 |
196 |
|
|
Tricky IF/Then Date based formula needed by
Titanium
Column A has the date and time displayed: Thu, 06/14/07, 11:15
Column B needs to calculate: "If (A=Mon to Fri from 7:00 to 20:00, Sat from
7:00 to 15:00, Sun...
( 1 2 3)
|
September 6th, 2007 01:50 AM
by Titanium
|
20 |
225 |
|
|
Date Conversion Formula Needed by
Titanium
From a database some info is generated that reads "20070917 at 1900".
I need to be able to generate "9/17/07 at 19:00"
At first I was thinking I could use a...
( 1 2 3)
|
September 16th, 2007 09:18 PM
by Titanium
|
20 |
199 |
|
|
|
September 29th, 2007 03:22 AM
by Max
|
20 |
196 |
|
|
|
|
20 |
148 |
|
|
copy a list and skipping blanks by
ART
Which formula do I use if I want to copy a range of cells but skiping the
blanks. For example, in column A is a list of items, and in column B is a
list of...
( 1 2 3)
|
November 29th, 2006 03:21 PM
by ART
|
20 |
240 |
|
|
lookup more than one cell by
andrewm
Is it possible to lookup on more than one lookup table simulatenously.
I was told to use lookup and not an if statement as I cannot use more
than 7 nested...
( 1 2 3)
|
|
20 |
522 |
|
|
|
November 2nd, 2005 10:32 PM
by Domenic
|
20 |
504 |
|
|
|
|
20 |
360 |
|
|
|
|
20 |
280 |
|
|
Removing Rows for Printing by
Frick
I have a report that pulls data from another worksheet in Range A26:J58.
What I want to be able to do is assign a button for printing the report but
before...
( 1 2 3)
|
|
20 |
403 |
|
|
|
|
20 |
200 |
|
|
Intersection point return data by
tvtime
First, thanks to Peo for helping me truncate time AND lookup all in one
formula.
Second, I'd like help with an 'intersection' formula, if possible. ...
( 1 2 3)
|
July 27th, 2006 07:20 PM
by Biff
|
20 |
168 |
|
|
|
September 5th, 2006 10:56 PM
by Domenic
|
20 |
197 |
|
|
vlookup formula by
Gemz
Hi, I have the following 2 formulae and i have been desperately trying to
make them work but the dont!
I am looking up the value of column D in 1 worksheet...
( 1 2 3)
|
January 24th, 2008 04:16 PM
by Gemz
|
20 |
217 |