|
|
|
September 22nd, 2008 11:45 PM
by JP[_5_]
|
4 |
197 |
|
|
|
|
1 |
172 |
|
|
If Function with Dates by
Bev
I have the following formula - which works correctly,
=IF(F6--"2005-01-01","No","Yes"), F6 is a date ... my question is, what does
the -- signify in the...
|
|
1 |
208 |
|
|
Pivot Tables Based on Filtered Data by
Michael[_3_]
Hi Folks - I created numerous pivot tables from a dataset. I now need to
create the same number of pivot tables for a filtered subset of the dataset.
Is...
|
|
1 |
167 |
|
|
Sumproduct-multiple criteria = and not = by
Tasha
Ok....this is my problem.... have multiple criteria that I need to set up a
SUMPRODUCT function for, equalling some and not equalling some. This is one...
|
September 22nd, 2008 10:10 PM
by Spiky
|
4 |
164 |
|
|
highlight selecting by
SteveDB1
Hi all.
I'm looking to find out what the colored "boxes" are called when we enter a
worksheet function, and select either a single cell, or a range of...
|
September 22nd, 2008 09:47 PM
by Spiky
|
3 |
109 |
|
|
Max problem by
BNT1 via OfficeKB.com
Hi
In a range of cells i have the formula,
=IF(INDIRECT("'"&(B1)&"'!c5")="",NA(),INDIRECT("'"&(B1)&"'!c5")), this
returns N/a when c5 is empty.
I have an...
|
|
2 |
139 |
|
|
Excel send emails by
jc132568
Dear experts,
Can excel send emails automatically when a number in a particular cell falls
under a particular value?
regards
jc132568
|
|
1 |
119 |
|
|
Date expires in 2 years by
Catguam
I am looking for a formula that would mark the cell as "EXPIRED" if the date
is 2 years or more.
My scenario is if a person is trained I need to be notified...
|
September 22nd, 2008 09:01 PM
by Catguam
|
2 |
121 |
|
|
|
|
1 |
271 |
|
|
How do I merge colums with data by
up4ms
I have imported data to excel. The problem is the phone number is broke into
three separate colums. Also the customer first name and customer last name is...
|
|
8 |
92 |
|
|
|
September 22nd, 2008 07:28 PM
by Mike H
|
3 |
102 |
|
|
HELP!!! TIME SENSITIVE by
Walt
Hi,
I have a worksheet that is filtered. I need to create multiply worksheets
that can show information based on the initial worksheet but with different...
|
September 22nd, 2008 07:25 PM
by Walt
|
5 |
114 |
|
|
Reconciling by
Hscott
I have a very large file that we have to reconcile monthly. There are two
worksheets, one is an A/P aged invoice and one has a list of all of our
payments...
|
September 22nd, 2008 07:05 PM
by Spiky
|
3 |
134 |
|
|
|
September 22nd, 2008 06:55 PM
by T. Valko
|
2 |
278 |
|
|
|
|
0 |
116 |
|
|
|
September 22nd, 2008 06:10 PM
by Jay
|
3 |
111 |
|
|
Filter by
Deborah
I have a worksheet with 716 rows I need to select every 17th row. How do I
do that?
|
|
6 |
102 |
|
|
Need to rank values with ties by
MichaelZ
Could someone provide a duplicate ranks with decimal fractions algorithm. I
need to rank data that has tied values, but I want a ranking that is unique
for...
|
September 22nd, 2008 05:44 PM
by Mike H
|
9 |
137 |
|
|
Fill cell based on # of days by
spezticle
My spreadsheet starts on the 17th of september. I'd like to have every cell
filled with red that =b1 (9/17/08) +14.
so,
9/17
10/1
10/14
10/28
all get...
|
September 22nd, 2008 05:00 PM
by Spiky
|
3 |
122 |