|
|
|
|
0 |
145 |
|
|
Looking at alternatives by
Brad
If you look at the list of dates below you will notice that 8/31/2009 has
many entries. What I want to do is to have a button that will range value
the...
|
September 3rd, 2009 05:27 PM
by Brad
|
1 |
108 |
|
|
dropdown boxes make file size too large by
Terin
Hi. I'm using Excel 2007. I have a cell with a dropdown box that has the
values 1 thru 10. When I save the file (as an Excel 97-2003 compatible .xls
file),...
|
|
2 |
127 |
|
|
Total Help! by
Sean NWIC[_2_]
I need the total that is effected by
Date and phrase.
I need Tuition for:
("NON-TRIBAL FT"=2718)AFTER 2009-10
("NON-TRIBAL FT"=2394)BEFORE 2009-10
("TRIBAL...
|
|
0 |
124 |
|
|
Run-time error '1004' by
murkaboris
Hello:
I've recorded a macro in which I'm copy-pasting the same pivot table in the
same worksheet and then changing the display of number inside to show as %...
|
|
5 |
151 |
|
|
How to match the values within Tables? by
Eric
Does anyone have any suggestions on how to match the values within tables?
For example, there are 2 tables
Table 1 contains date, which is from cell A595 to...
|
September 3rd, 2009 04:43 PM
by Luke M
|
1 |
100 |
|
|
Blank cells by
deannab
Using Excel 2007. I am using this basic formula in the H column
=SUM(H2,C3)-F3 in a spreadsheet with financial information. I copied and
pasted the formula...
|
September 3rd, 2009 04:25 PM
by Luke M
|
1 |
92 |
|
|
|
September 3rd, 2009 04:23 PM
by Cadders
|
4 |
115 |
|
|
Macro security in Excel 2007 by
jodleren
We have just moved to Office 2007, from teh good old office 2003 I
guess....
We have a large number of excel applications, for every day use.
In Excel 2000...
|
|
1 |
111 |
|
|
|
|
2 |
98 |
|
|
Help breaking up data in a cell by
Jim
Hello,
In cell A1 I have the following:
L2D376 - COE
I would like to break up this data into two cells.
In Cell B1 I would like L2D376 to show
|
|
5 |
119 |
|
|
Total of two time keeping codes in one cell by
something68
Luke M was helping me with the following and I haven’t heard from him so I
may have sent him to the funny farm…he was very close in finding a solution
to...
|
September 3rd, 2009 03:50 PM
by Mike H
|
7 |
115 |
|
|
SUMPRODUCT vs Database Query by
Vanessa Simmonds[_2_]
Good Afternoon,
I am using SUMPRODUCT to return the sum of a selection from a spreadsheet
that it downloaded from an access database.
However everytime I...
|
|
1 |
114 |
|
|
Table Lookup by
Andrew Mackenzie
Would appreciate any help offered here.
I have a table of exchange rates something like this:
USD GBP CHF JPY
USD ...
|
September 3rd, 2009 03:13 PM
by Stefi
|
4 |
88 |
|
|
Excel won't start (Office 2k and Vista) by
Andy[_26_]
Hi
I have installed Office 2000 onto my Vista machine. This morning
everything was working fine. Now, however, when I try to start Excel I
get the Excel splash...
|
September 3rd, 2009 03:05 PM
by Bob I
|
4 |
151 |
|
|
data prints outside column by
RobE[_2_]
When I print my document the first page is fine but the second and third
pages have the data printing outside the colum.
I have reduced the document to one...
|
September 3rd, 2009 02:59 PM
by Bob I
|
2 |
100 |
|
|
is Error help by
Jim
Hello,
I'm currently using the following formula:
=TRIM(LEFT(A1,FIND("-",A1)-1))
How would I write this so that if the referred to cell is blank then the...
|
|
3 |
115 |
|
|
Getting an average using if statement by
Black9Medic
I have 9 cells in several locations that I am using the average formula. I
am also linking it to another spreadsheet for general reporting of
efficiency's. ...
|
|
3 |
95 |
|
|
Hide Combo Boxes with macros by
juancarlos
I"m using belog data to hide some rows. What can I add to information below
to hide the combo boxes within this rows?
Sub HideRowsBrazil()
If...
|
|
6 |
109 |
|
|
Finding a number by
Sam
Hi, I wonder if any one can help, I want to look for a number in a row of
cells, I have a row of twenty cells that have a number in each all different,
What...
|
September 3rd, 2009 01:51 PM
by Max
|
6 |
110 |