|
|
|
April 24th, 2009 03:01 PM
by Luke M
|
2 |
66 |
|
|
Revome blank spacing from ending Numbers by
Calculate Date range
need your urgent help
I have a list a numbers as followings with extra bank spacing at the end of
the numbers, please advice me how to set a formula to...
|
|
6 |
84 |
|
|
Locate data from 1 column in another by
Shaz
I have 500 email addresses in column D and 13,000 in column A. Now i want to
delete all of the column A except the ones which are also in column D.
in other...
|
|
2 |
59 |
|
|
|
April 24th, 2009 02:26 PM
by Ward
|
6 |
117 |
|
|
Can't stop recalc by
[email protected]
I have some fairly large reports that utilize the SUMPRODUCT
functions. Daily I have to clear the unlerying data tables and
repopulate with current data. I...
|
|
2 |
99 |
|
|
Accumulator by
BadBoy
Hello,
It would seem what I was looking for all this time was called an accumulator.
Is there some way to alter the code below to link up to a page in...
|
April 24th, 2009 12:25 PM
by BadBoy
|
2 |
79 |
|
|
conditional formating if and And by
ROPL
Hi help please,
=OR(F3="Schedule booked",AND("D3C3"))
I am trying to write if field F3 quotes "Schedule booked" And the amount
(field d3) is less than...
|
|
2 |
66 |
|
|
COLUMN() problem with array formula by
ejack
I am having a problem error proofing this formula. The formula as listed
successfully takes a heading and concatenates some text onto it and then goes
into...
|
April 24th, 2009 07:05 AM
by ejack
|
0 |
73 |
|
|
|
|
6 |
88 |
|
|
How do I get text to speech to work in XP? by
MotorCityRock
I have not been able to get text to speech to work in Excel that has Windows
XP. I haven't used this function in quite some time and I don't know if it
is...
|
April 24th, 2009 04:17 AM
by comcdp
|
3 |
110 |
|
|
|
|
3 |
61 |
|
|
Format text in formula line by
mge
Is there a way to format specific text in a formula line. For example, can I
make the 1 superscript in the following formula line.
="The current tax rate1 is...
|
|
6 |
97 |
|
|
Getting wrong answer with Match Function by
CB1215
Excel 2007, HP PC. I have a long array of data, with a varying number of
entries per each individual on whom training data is kept, based on what
events...
|
|
3 |
97 |
|
|
|
|
8 |
62 |
|
|
Average by Multiple Criteria. by
RoadKill
How can I try to do an average requiring multiple criteria? For example, I
want to do it by Employee Name and Date Range.
So if cells A1:A100 is the Name,...
|
|
3 |
79 |
|
|
Variable Symbol by
Kashyap
Hi, How to make + symbol variable in the below formula?
This formula is in G25 and symbol is in F25
=(NOW()-E$592)+E614
|
|
1 |
53 |
|
|
Custom date fields for pivot tables by
Amijab
I have a pivot table that is updated daily, but for reporting purposes, I
only want to include the last 14 days in my report . I see date filters for
this...
|
|
4 |
136 |
|
|
comparing columns to find dup's by
stacey
i have 1 worksheet with 2 columns....i need to know the names that show in
both columns.
i know there is a =countif formula but i cant find it anywhere.
thx...
|
April 24th, 2009 01:24 AM
by stacey
|
2 |
88 |
|
|
|
April 24th, 2009 12:16 AM
by PJFry
|
1 |
71 |
|
|
Row increments - by
Janelle
I am trying to copy a long "=IF" formula down a row by dragging it. The
"=IF" formula is linked to another worksheet, and I am trying to increase the...
|
|
7 |
75 |