|
|
referencing by
zuapfly
hi, i'm making a calculating worksheet that uses different files...
because i use the same formula often in a larger formula, i put the
returning formula in...
|
|
4 |
162 |
|
|
displaying sales order equal to user input by
avilla
:HI
can anyone help this beginner????
I have a worksheet that hold sales for one of our company depots for
the year todate. There are over 1000 sales and i...
|
|
3 |
197 |
|
|
Marco with autofilter by
avilla
Hi can anybody help
I have used the following code to enter a specific date in an inputbox
that looks at the autofilter column and displays the result...
|
|
4 |
239 |
|
|
borders? by
jkb724
Is there any way to have a border set for every page in my workbook.
Just so that the page is outlined and looks more put together?
Thanks
---
Message...
|
|
1 |
135 |
|
|
funcres.xla by
Fritzj
When openning excel, I now get a message that funcres.xla
is not in right place or gone. What do I do? It did not
use to do this.
|
|
3 |
208 |
|
|
Happy Face Graph ... Is it possible? by
Ken
Excel 2000 ... Is it possible to create a "HAPPY FACE"
Graph where the Face would incrementally turn from a "SAD"
Face to a "HAPPY" Face as Customer...
|
|
5 |
271 |
|
|
if color then formula in cell by
Jonsson
Hi,
Can anyone help me to write a code that says:
IF text in cell B4=red, choose formula in cell C4
IF text in cell B4=black, choose formula in cell D4
IF...
|
|
4 |
339 |
|
|
Always negitive by
HessInAMess
is there a way to tell excel to always make any numbers in a cell
negitive? even when the number wasn't entered with a - sign? I've been
trying to use the...
|
|
2 |
157 |
|
|
Print Rows at Top only on some pages by
S.J. Ring
I have a spreadsheet which contains two types of data, a
total of 12 pages.
The first 10 pages are formatted identically and when
setting the print ranges I...
|
|
2 |
472 |
|
|
Too many different cell formats by
André Martins
I have one worksheet with this problem but in despite of=20
doing a lot of modifications, some time after the problem=20
is still happens. Someone know how can...
|
|
1 |
193 |
|
|
|
|
1 |
284 |
|
|
#NUM! error by
Richard
Whats wrong.
{=SUM((Sheet1!A:A="*")*(Sheet1!B:B="\\\\\\CC\\\\\\")
*Sheet1!E:E)}
thanks in advance
( 1 2)
|
August 3rd, 2004 04:50 PM
by RagDyeR
|
12 |
318 |
|
|
|
|
3 |
433 |
|
|
|
|
2 |
354 |
|
|
alternative to INDIRECT reference by
Nornny
Hi everyone, I have a really big Excel workbook with hundreds of
INDIRECT references to other sheets within the workbook. That is the
ONLY type of INDIRECT...
|
August 3rd, 2004 03:40 PM
by Nornny
|
3 |
239 |
|
|
converting dates by
rexmann
Hi All
I have a couple of excel problems to do with dates (Excel XP/2002).
I have a formula that displays one date minus another and displays the answer as...
|
|
4 |
358 |
|
|
Text format by
Me
Hy,
I have an text how looks like this: "AA-BB CC-dd". I want to select the text until the "-dd", so the result would be "AA-BB CC". So the text until "-"...
( 1 2)
|
|
10 |
212 |
|
|
using countif() to parse string by
tivarney
I am trying to use countif() to parse a cell which contains a string.
For example, the string could be "This is the example string."
Can I use the countif()...
|
August 3rd, 2004 08:13 AM
by JulieD
|
3 |
171 |
|
|
|
|
5 |
483 |
|
|
Use defined names in VBA? by
JRocket02
Hi all
Any way to have Excel generate links or dimension variables so that VBA can
use the defined names on the spreadsheet (menu: insert name define)? ...
|
|
1 |
163 |