|
|
Countif by
jay
I have two worksheets. I would like to have a formula that counts data
according to the following conditions.
Worksheet 1
A B ...
|
May 28th, 2010 03:21 AM
by jay
|
3 |
246 |
|
|
SUMPRODUCT WITH 4 CONDITIONS NOT WORKING by
Carrach
My formulae below is not working, can you help?
Column H contains 'NZ' or 'SZ',
column I is in 20/5/2010 format,
column G contains 'trade' or 'fdi',
Column...
|
|
3 |
559 |
|
|
|
|
1 |
301 |
|
|
If greater than 5 by
Carolan
Need a formula - I know it's simply - just can't get it.
If A1 is greater than 5, then B1 = 5
If A1 is less than 5, B1 should equal the amount in A1
CarolAnn
|
|
4 |
256 |
|
|
Average IF's by
Noodnutt @ Work
Hi Guy's
Can anyone help me out with the 2K version of the following plz.
=IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000))
This works...
|
|
4 |
316 |
|
|
|
|
1 |
264 |
|
|
RANDBETWEEN INSTALL by
ALee
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.
If necessary, follow the instructions...
|
|
7 |
417 |
|
|
|
|
1 |
309 |
|
|
|
|
4 |
344 |
|
|
sales tax chart by
momof5
I know there must be a formula to figure this out easily, but I can't do it.
I am trying to make a chart like the illustration without figuring every
line....
|
May 28th, 2010 01:17 AM
by momof5
|
0 |
248 |
|
|
|
|
2 |
349 |
|
|
Convert Week number to Month by
KT
I have a worksheet with year and week number and want to use a funtion to
convert these two values into the descriptive month. Some weeks cross
months, but...
|
May 28th, 2010 12:48 AM
by KT
|
0 |
314 |
|
|
Search, Match, Pull by
sjkoep
Hello,
I am looking for help to:
Search through two columns (one for employee, the other for employee number).
I want it to match those two criteria and...
|
May 28th, 2010 12:35 AM
by Max
|
1 |
209 |
|
|
Multiple Numbers in a cell by
Booj
I have a worksheet that has multiple numbers (1234, 3425, 34234,etc.) in a
single cell. I need to separate these and create a new row for each one (ie.
A1...
|
|
2 |
267 |
|
|
VLookup by
Mary Lou
I have a workbook with two worksheets. On the first - it has the following
columns:
Inv # Employee Fees Paid
on the second worksheet i have the...
|
|
1 |
198 |
|
|
Macro to select last row by
msnyc07
I am trying to automate putting a sheet value into Row I. My manual method
is to paste the formula in I2 (since values begin on Row 2), then go to A2,
Ctrl...
|
|
1 |
340 |
|
|
|
|
2 |
307 |
|
|
|
|
1 |
327 |
|
|
Picture protection by
Suresh Lohar
when we protect a sheet with a password, why a picture
that we insert in sheet is not protected.
Suresh
|
|
1 |
286 |
|
|
|
|
1 |
283 |