|
|
Stop by
Celeste
In row 1 I have my column names. What I want is to be able
to scroll through my spreadsheet without having this row
move so when I am at the bottom of my...
|
July 2nd, 2004 04:18 PM
by CLR 
|
2 |
137 |
|
|
|
Counting columns, adding totals by
Dennis Allen
Hi. I've been handed an excel file that needs tweaking. Was wondering if
someone here could help.
This xls file consists of 7 worksheets, one of every day...
|
|
5 |
120 |
|
|
Total of Time by
A
I'm recording the time I spend working on a piece of work in a spreadsheet
along with meeting details etc.
I've 2 columns that are start and finish times and a...
|
|
1 |
163 |
|
|
|
Error opening spread sheet by
Keith
Hi,
Every time I click on a shortcut link to a spread sheet,
whether on the desktop or from e-mail I get a message that
says "A document with the same...
|
|
1 |
150 |
|
|
|
|
|
3 |
112 |
|
|
|
|
|
7 |
229 |
|
|
|
spreadsheet will not load by
fraustrated
hello there. i have a spreadsheet that is located on my
hard drive. when i click on it, excel opens up but the
data and tool bars will not load. also when i...
|
July 4th, 2004 03:56 PM
by CLR
|
1 |
92 |
|
|
|
functions by
carlos1973
hi,
is there a function that does this
if a1=1, if true a2=b1, if false a2 stays as it was (EITHER WITH A ZERO VALUE OR THE VALUE THAT MAY HAVE BEEN ENTER...
|
|
3 |
108 |
|
|
|
Data Calulation Between Dates by
Ghostrider123
I'm trying to work with the formula:
=SUMIF(B3:B500,??????????????,G3:G500)
I want to be able to calculate data between two dates, let’s say
between 1 July...
|
|
1 |
120 |
|
|
|
Tutorial on formulas by
Helen Tasky
Is anyone aware of any tutorials on formulas? I am especially interested in
the "IF" scenarios.
Thank you.
|
|
4 |
169 |
|
|
|
Formual Syntax? by
QTE
Hi Excel Forum,
What do the two dashes (--) mean and do in the following formulas:
=SUMPRODUCT(--A1:G1)
=SUM(IF(ISNUMBER(--A1:G1),--A1:G1))
entered with...
|
July 5th, 2004 07:20 PM
by QTE
|
3 |
135 |
|
|
|
balance in pivot table by
dk
we are importing a pivot table from column c & d How an we configure colun c minus column d
|
|
3 |
108 |
|
|
|
Hiding Formulas In Cells Not Formula Bar by
mchandler
I'm trying to create a template which contains some cells with formulas. Because the contents of the cells in which the formulas reference are currently empty,...
|
July 5th, 2004 10:05 PM
by Kurewe
|
2 |
131 |
|
|
|
Custom Auto Filter by
Martin
Previously posted in microsoft.public.excel.worksheetfunctions but I
didn't get any response, so I'm trying another group in case I posted
to the wrong one. ...
|
July 6th, 2004 12:12 PM
by CLR
|
5 |
365 |
|
|
|
Cross Referencing by
Simon
I have a workbook containing 12 worksheets, one for every month of the year. Each worksheet contains several columns containing: Date, Credit (value), Credit...
|
July 7th, 2004 11:33 AM
by CLR
|
3 |
125 |
|
|
|
conditional comparison in a data range by
Mona
Hello:
I have 2 worksheets. The first is a product price data
sheet and the second the clients product usage sheet.
My task is to get the price of the...
|
July 7th, 2004 02:25 PM
by CLR
|
1 |
111 |
|
|
|
MoneyCentral Stock Quotes add-in by
Easydoesit
About half my queries come back with the #VALUE error, but I cannot find out
why or how to correct. The Help section does not cover this topic well
enough. I...
|
July 7th, 2004 03:17 PM
by CLR
|
1 |
106 |
|
|
|
Using Autofilter and subtotals together by
Jennifer
I have a spreadsheet that utilizes subtotal (outline) functionality. I need to be able to autofilter on this. When I apply the autofilters, the subtotals plus...
|
July 8th, 2004 12:37 AM
by CLR
|
1 |
101 |
|
|
|
Excel rows by
needhelp
Somehow I've ended up at 65000 rows in a Sheet. How can I delete the unwanted rows (all aprt from 50), as it is making the document size huge!
|
|
4 |
329 |
|
|
|
Displaying zeros as blanks by
Pradhan Balter
I know this is an old question. Is there a way to display
zero fields as blanks? I know I can do this with and If
(x=0,""...etc, but then if this cell is used...
|
|
6 |
141 |
