|
|
|
|
2 |
112 |
|
|
|
|
2 |
121 |
|
|
|
|
2 |
95 |
|
|
|
|
2 |
144 |
|
|
Looking up data and images! by
LW_Greeney
Can anyone give me some example code to get me on my way to either creating a
spreadsheet where you can have an image change when lookups are done for
specific...
|
|
1 |
75 |
|
|
|
October 11th, 2005 02:19 PM
by Derm
|
0 |
75 |
|
|
Pivottable : repeat break value by
pehuyghe
How can I repeat a break value in a pivottable. I have the following
table :
Year Month Value
2001 Jan 1000
Feb 2000
Mar 1500
2002 ...
|
|
1 |
78 |
|
|
excel running slow when saving by
Andrew
I have a 11mb file everytime i do a change in it takes forever to save.
Just wondering is there anyone with the same problem.
|
October 11th, 2005 01:42 PM
by tkaplan
|
1 |
276 |
|
|
Using F9 Financial Report Program by
Bob
The F9 Financial report writer recommends auto-recalc be set to manual. For
those individuals using F9, there seems to be problems with recalc when
viewing...
|
October 11th, 2005 01:24 PM
by Bob
|
0 |
91 |
|
|
Formula Result by
JT
How can I prevent a #DIV/0! result from displaying in a cell?
Jack Taylor
|
|
8 |
106 |
|
|
date calculations by
TUNGANA KURMA RAJU
I am working on a personal worksheet.In cell A1 I put my Date of
birth(1-NOV-1975) in ddmmmyyyy format.What formula I need to write to get(in
B1 to B6)
1.What...
( 1 2)
|
|
11 |
134 |
|
|
|
|
1 |
77 |
|
|
|
|
0 |
71 |
|
|
Excel List Sorting Problem (Descending) by
Erik
Hi there,
I'm having trouble sorting my list--my column contains *only* 4-digit
numbers but when I click on "descending order", only about the first half...
|
October 11th, 2005 11:12 AM
by Erik
|
2 |
209 |
|
|
|
October 11th, 2005 11:03 AM
by GordonJ
|
0 |
60 |
|
|
Combine rows by
beanmonger
Hi,
I have a data set that looks like this:
Code:
--------------------
Name City Rating Type
Dave London 5 Audi
Dave London 4 Ford
|
|
3 |
76 |
|
|
proper by
afdmello
just suppose a cell is having text in caps and I want to convert it to
proper.How can I do so with only one keystroke: a macro maybe.
Now I do it like...
|
|
3 |
94 |
|
|
FORMULA PRODUCES WRONG RESULT by
Wildebeest222
eg. I enter a formula =SUM(A1:H1) in cell J1.
If I enter 100 in cell A1, J1 shows 100 (Good!).
If I then enter 200 in cell B1, J1 still shows 100 ??
Whatever I...
|
|
2 |
76 |
|
|
Rounding Sums Format by
[email protected].(donotspam)
I'm using the following formula: =SUM(N25:R25). I want to round the result. I
cannot seem to find the correct way to write this formula. I know how to
round...
|
|
2 |
75 |
|
|
Check box by
accessman2
In Excel:
How can I make Checkbox on each row? Thanks.
--
accessman2
------------------------------------------------------------------------
accessman2's...
|
|
1 |
106 |