|
|
|
February 11th, 2008 06:54 PM
by adimar
|
3 |
78 |
|
|
|
|
3 |
121 |
|
|
Sumproduct with Match and Vlookup? by
adimar
I am looking for a sumproduct formula that counts how many Titles in a sheet
are Backordered and have Availability date between D1 and D2.
The data resides in...
|
February 5th, 2008 11:09 PM
by adimar
|
8 |
163 |
|
|
Disable sheet reference check by
adimar
In sheet “Calculated” I have a formula referencing another sheet in the same
workbook: “SrcData!$F$2:$F$20000”.
In order to refresh “SrcData” the...
|
February 6th, 2008 08:02 PM
by adimar
|
0 |
94 |
|
|
Date comparison by
adimar
For the data below B1A1 is true.
A B
12/3/07 11:48 AM 12/3/07 1:26 PM
How do I check the dates are at least 1 day...
( 1 2)
|
February 3rd, 2008 06:44 PM
by adimar
|
14 |
115 |
|
|
Compare dates with lag by
adimar
I need a formula to check for status=”Closed” and delivery within 2 days of
requested date.
A B ...
|
|
5 |
74 |
|
|
Date value content format by
adimar
I have the data below in different spreadsheets. I'm attempting to debug
"sumproduct" errors on one ofthe sheet. Tha same formula works fine in
another...
|
February 2nd, 2008 08:46 PM
by adimar
|
6 |
97 |
|
|
|
|
5 |
76 |
|
|
|
|
4 |
59 |
|
|
Formula editing by
adimar
I usually edit complex formulas in a text editor, especially if I want to
replace constructs, ex: replace string check for “PROD_1” with...
|
|
2 |
83 |
|
|
Formula with sum/avg by
adimar
I have numbers in columns A1:A100 and B1:B100.
I need the result for MAX(Ai / (Ai + Bi)).
Is there a way to write a worksheet formula and avoid populating an...
|
March 13th, 2008 07:51 PM
by Mike H
|
3 |
66 |
|
|
#n/a result for vlookup by
adimar
In the data below I attempt to find items in column C and return date in
column B
using =VLOOKUP(C2, A9:C11, 2, FALSE)
A ...
|
March 28th, 2008 08:58 PM
by adimar
|
5 |
96 |
|
|
string matching by
adimar
Please help me understand why these apparently equivalent constructs behave
differently? I use them as multipliers in SUMPRODUCT.
The formula is something...
|
April 14th, 2008 10:05 PM
by adimar
|
2 |
76 |
|
|
Date/time increment specifier by
adimar
Date + 1 increments the date.
How do you increment date at year, month, hour, min, or second?
Ex: Is there anything more compact for “Date + 1 year” than...
|
|
4 |
165 |
|
|
Formatting issue by
adin
I'd like this:
Column A Column B
A 1
A 2
A 3
A 4
B 1
B 2
C 1
( 1 2)
|
April 22nd, 2005 06:21 PM
by adin
|
10 |
160 |
|
|
Strip carriage return, add row by
adin
I've got a sheet with 2 columns - column A has multiple values in one cell
that are separated by carriage returns, and column B next to it has only one
value...
( 1 2)
|
|
18 |
419 |
|
|
copying multiple selections by
adinic
Hello. Does anyone know how to do this? For exemple i need to copy
several rows. If i try to do this i get an error....
|
February 24th, 2006 12:50 PM
by CLR
|
1 |
69 |
|
|
|
|
4 |
102 |
|
|
place a number in a cell by
ADiscrete1
I have a column of numbers with blanks in some cells between the numbered
cells.
In the next column I have done an if/then statement when there is a...
|
June 13th, 2006 01:27 AM
by Max
|
3 |
67 |
|
|
|
|
2 |
72 |