|
|
|
|
0 |
124 |
|
|
|
|
3 |
125 |
|
|
|
May 13th, 2009 02:11 PM
by CLR
|
1 |
116 |
|
|
auto filter by
SPISO
Column A has dates 05/01/09 on down. Is there a way I can auto filter those
rows that are between two days back through 6 days in the future? Let say
today...
|
May 13th, 2009 01:57 PM
by SPISO
|
2 |
244 |
|
|
CALCULATE PROFIT/LOSS by
Tree
This is really a basic math question but I thought Excel was the Math Wizard
(more so than me) and could help, but this has opened up a bit of can of
worms...
|
May 13th, 2009 01:50 PM
by Tree
|
6 |
122 |
|
|
Postcode Area extract first alpha letters by
aquaxander
Hi,
I have a list of postcodes and would like to have only the first letters,
whether this is 2 or 1 letter.
I have been able to extract the beginning of a...
|
|
3 |
138 |
|
|
|
May 13th, 2009 01:48 PM
by Deb
|
3 |
140 |
|
|
Derive Average by
ryguy7272
I have a year end number (Cell B5) and I can derive my Q4 number by summing
Q1 + Q2 + Q3, and subtracting the result from Q4. How do I do this for an...
|
|
5 |
93 |
|
|
Pivot Tables (Sumif) by
[email protected]
Although I have fought the urge, I have finally decided to venture
into the unchartered territory of pivot tables.
I have a large data set with a number of...
|
|
2 |
134 |
|
|
I want to count the total number of date by
shital shah
Hi to all
I want to count the total number of date
Example:- 26/05/1973
then total of day ie 2+6 =8
than total of all ie 2+6+5+1+9+7+3=33 ie=6
how can I...
|
|
0 |
100 |
|
|
COUNTIF Question by
JCarlos
Hi, I searched for my question in these forums, but no one answered it
throughly.
I work for a high school and I have an excel file with grade data for each...
|
|
6 |
131 |
|
|
|
|
2 |
83 |
|
|
Moving formula results to blank line by
Lversteeg
I was wondering if anyone could help me.
I have on one sheet a product selector for my sales team. I have added a
column where they can put an "x" into if...
|
|
3 |
121 |
|
|
Check for error.type in same cell by
art
Hello all:
Is it possible to use the formula Error.type to check if the cell has a
certain error? So, for example, in cell A1 I start with...
|
|
2 |
129 |
|
|
RANKINGS by
Novice at the Computer
I have numbers in colums G, I and K that i want in a first place to 600
place. Ranking from high to low
EG
Colum G3 answer is 150
BUT
Colum K 15 answer is...
|
|
1 |
96 |
|
|
"copy" by
hsfnwa
The basic theory is everytime when I change the datecell under current, it
will automatic copy(link) to the next row instead override the same row
Does anyone...
( 1 2)
|
|
10 |
148 |
|
|
IF statement with multiple values... by
guy.pembroke
Hi,
I would like to be able to search a group of cells for particular text,
placing the true of false value in another cell, using this...
( 1 2)
|
|
12 |
349 |
|
|
specific percentage formula by
Etourneaul
I'm looking for a way to create a formula that shows that if any percentage
over 10% shows up red. Any other results below 10% stay black. Currently i
have...
|
|
2 |
99 |
|
|
replaces formula to its value by
InspectorJim
F2,F9,ENTER should replace a formula with its value. For some reason, the
Excel I am using at work does not function when I do that. Formula remains as
if I...
|
|
1 |
102 |
|
|
|
|
1 |
105 |