|
|
|
|
1 |
224 |
|
|
To Tom Ogilvy by
Ramadan
Hi Tom
first off all I want to thank you very much for your
response but unfortunately until now no success in my excel
sheet which is very important to my...
|
|
6 |
167 |
|
|
How many records with xl 03 hold? by
Adam
The current record limit is 256 columns and 65kish rows,
will this be extended in the 2003 version?
I've heard that quattro pro looks at 1 million...
|
|
1 |
86 |
|
|
Simple running total Excel 97 for Windows by
Stuart Matley
I want to add a figure in a cell to show how long I've
spent on a job. In the adjacent cell I want Excel to add
the new figure to the previous figure to give a...
|
|
1 |
470 |
|
|
Pivot Tables by
Karl
I need a pivot table, that allows me to nest specific
data filters within specific sets of data. For instance,
if I pull down menu A, it gives me options 1,...
|
October 14th, 2003 05:40 PM
by Karl
|
0 |
123 |
|
|
Concatenate Formula not Text by
Russell
Is it possible to Concatenate two or more cells to create a formula?
I.e. I would like to create a formula that references cells in a
seperate workbook. Using...
|
|
1 |
238 |
|
|
Editing by
AJ
Hi All,
I have a list of thousands of names in which some of them
are repeated twice or thrice. I want to get the list from
that which would not have any...
|
October 14th, 2003 06:04 PM
by Aj
|
2 |
91 |
|
|
Formulas by
Richard Shaw
I am running Excell 2000 Version 9.9.3821 SR-1 on my
Millenium system. I want to have the number in a given
cell recorded automatically in another cell, if...
|
|
2 |
84 |
|
|
Formula assistance please in Excel 2002 by
RD
OK, here goes:
I have a sheet with values in column a, b, c and d, call the sheet
"Projects"
I have another sheet, call it, "Time", where in A1 I put a...
|
October 14th, 2003 07:53 PM
by RD
|
3 |
264 |
|
|
|
|
3 |
263 |
|
|
function skips lines by
Jennifer
I have this function and I want it to count all the cells
in the specified range.
=SUMPRODUCT(('Main FOB Log'!K3:K589"")*('Main FOB...
|
|
7 |
299 |
|
|
WeekNum function in vba?? by
Roger
Is there a function similar to that of the WeekNum function
found in excel 2002 for vba?
And/or how do I call the function from excel, or a link to
download a...
|
|
2 |
230 |
|
|
adding work days by
Melissa
I'd like to use Excel to develop a project schedule. Is
there a way to add, for example, 3 work days to a
particular date? I know I can add 3 to any date and...
|
|
2 |
321 |
|
|
vlookup function by
Miranda
The following problems are not occurring in all of the
cells with formulas even though the functions are exactly
the same and referencing the correct cells. I...
|
|
1 |
300 |
|
|
formula with variable parameter by
GM
I am doing a comparison of financial results. I have five
columns which represent quarters. The financial results
for each quarter are stored in different xls...
|
|
1 |
181 |
|
|
Color text from a function by
DSKOG
I want to highlight problems in a report.
To this end I was planning to use the
TEXT(text,format) function to allow me to change the color
of the text. ...
|
|
2 |
180 |
|
|
excel: Edit cell??? by
AL
I know it's easy, but I forget how.
I imported a file from a data base to excel.
The names came over combines,
ie: (Sablone,Al A.) or (Sablone,AL) in one...
|
|
2 |
288 |
|
|
deleting excel macros by
jim
I created an excel macro, used it, and tried to delete
it. however, every time I open the spreadsheet, it asked
if I would like to "enable" or "disable" the...
|
October 14th, 2003 10:37 PM
by Paul B
|
1 |
178 |
|
|
Radio Button by
Spike9458
I am using a spreadsheet set up by somebody else. It has several columns,
where if you click on the radio button at the top, a data entry windows pops
up and...
|
|
7 |
186 |
|
|
View error by
Denise
When I open up my file I am getting the 'Ready' message in
the lower left hand corner but the screen is still gray
and the file is not showing on the screen. ...
|
|
1 |
105 |