|
|
|
March 17th, 2010 02:42 PM
by JSAUS
|
3 |
187 |
|
|
i can't get this formula to work by
kyle
i'm trying to write a formula where if the cell below it minus the active
cell is -21 x -23 then write one, else leave it blank.
so here's what i got so...
|
March 17th, 2010 02:28 PM
by kyle
|
3 |
175 |
|
|
The Tueday prior to a holiday... by
Steve
If I have holidays identified with an H in the A column, I need to find the
prior Tues, from the Sat prior to the holiday.
Basically I need to find the Sat...
( 1 2)
|
March 17th, 2010 01:59 PM
by Steve
|
10 |
289 |
|
|
implementing formulas in excel by
Ian
How formulas can be implemented in excel by connecting to it using odbc in
c#. Help with some sample code will be greatly appreciated?
|
March 17th, 2010 12:41 PM
by Ian
|
0 |
165 |
|
|
How to replace formula with its result by
jclown
Hello Everyone,
I am using a function to calculate stock levels. For example =2*BR5.
But what I want is the cell to display the answer once it has been...
|
March 17th, 2010 09:59 AM
by jclown
|
2 |
167 |
|
|
actual row number by
climate
I have 63 file.
My data set on to column X, and G2 is row number related to column X.
I need to macro or formula, when run it on any file, copy of column X...
|
March 17th, 2010 07:59 AM
by climate
|
3 |
194 |
|
|
How can I test the text content of a cell by
catefaulkes
I wish to create a logical test - an IF statement that tests whether a cell
contains H, M or L, and output the result as a number.
I cannot get the IF...
|
|
4 |
178 |
|
|
Importing cells frmom a calendar workbook by
AZSteve
"Time-off Calendar" is Excel workbook with 12 worksheets, Jan, Feb, Mar, etc.
Each is set up like a calendar with 7 columns (days of week) across and...
|
March 17th, 2010 04:27 AM
by AZSteve
|
4 |
272 |
|
|
|
|
5 |
237 |
|
|
|
|
6 |
182 |
|
|
|
|
1 |
196 |
|
|
SUMIF with multiple criteria by
GBExcel via OfficeKB.com
Hi,
I need help to SUMIF, subject to several criteria being met.
Here is the setup:
1. I need a formula for cell BB24. The header (cell BB23 contains the...
|
|
5 |
144 |
|
|
|
|
6 |
142 |
|
|
|
|
5 |
148 |
|
|
Cash Statement- Accruing balances by
cjarrar
we are attempting to create a Cash Statement report for a single account and
would like to include a To Date, Month To Date and Fiscal Year totals. Is
there...
|
|
1 |
193 |
|
|
Help with formula: finding text by
Jonas Ornborg
Hi,
I would like to ask for help with a formula for comparing name in a cell
with a list of names in a table. If there is a match it should return a...
|
|
4 |
119 |
|
|
force alignment? by
Art
I know how to format a cell so the alignment is centered both vertically and
horizontally.
However, if a user copies/pastes text from, say, Microsoft Word...
|
|
7 |
381 |
|
|
return different values based on 4 criteria? by
Susie (SFAngelgirl)[_2_]
Need Formula or macro to allocate the "Scheduled hours" based on Group Counts:
If Group "A" and "C" are both greater than 1, then Scheduled "A" and "C"...
|
|
4 |
143 |
|
|
|
|
1 |
137 |
|
|
|
|
1 |
161 |