|
|
sumif problem by
saziz
Hi Guys,
I am using SUMIF(B1,"0") to find out negative values in column A1.
Now how can I say if the value in column A1is 1 bring that value to
column...
|
July 28th, 2004 05:00 PM
by saziz
|
7 |
271 |
|
|
excel spreadsheet by
[email protected]
I have a 2 sheet excel spread sheet that I put together
with varing column widths.
On the top 1/4 of the first sheet (of the 2 part spread
sheet) I need to...
|
|
0 |
188 |
|
|
|
|
1 |
259 |
|
|
Protection by
BenJAMMIN
I have setup a workbook and selected certain cells to be protected. After creating a password protection for the workbook I saved it and turned it loose to the...
|
|
1 |
190 |
|
|
Newsgroup Search -- Working? by
LarryP
I've tried the Search feature a few times to find a
particular sender or title, but get no results. Ditto
over in the Access newsgroups. ???????
|
|
8 |
287 |
|
|
Consolidating buttons by
David P.
I have a ridiculous amount of buttons that initiate macros on my worksheets. Is there a drop down menu option to consolidate or group certain buttons to make...
|
|
1 |
209 |
|
|
|
|
4 |
519 |
|
|
[URGENT] Line Graph by
jamesjustinaaron
I want to create a line graph using three pieces of data. I know how to create a series of line graphs together, no problem. What I want to do is have one line...
|
|
1 |
788 |
|
|
Save single worksheet as new workbook by
GorillaBoze
I have a workbook containing multiple worksheets. I would like a macro
that would save a single worksheet as a new file. Also, can I have the
new file be...
|
|
6 |
541 |
|
|
Set default values marco by
RJ
I have a model where there are several user defined entries. The ones I can't seem to get to work are resetting a value from a drop-down menu. When recording...
|
|
2 |
274 |
|
|
Making field values appear in every cell by
Eric Stephens
I have a question: is it possible to make the field values appear in every cell, instead of just the first row for that particular level? For example, instead...
|
|
1 |
321 |
|
|
sumproduct question by
mark1
I have three columns. They go like this:
100 1 2
200 0 2
100 1 0
200 0 2
100 1 2
200 0 0
I've always been under the impression that a + sign
|
|
5 |
213 |
|
|
Setting range in a column where data ends by
saziz
Hi Guys,
I have two problems I trying to solve.
1) Column A & B has data (may be 500 rows) a formula is written in
Column C and I like to fill it down until...
|
July 28th, 2004 10:20 PM
by saziz
|
7 |
424 |
|
|
|
|
7 |
395 |
|
|
worksheets and workbooks by
Jason
If I have a large sheet with over 4000 rows and a number of columns including customer name, date, invoice number etc. I’d like to create duplicates of the...
|
|
1 |
436 |
|
|
|
|
2 |
440 |
|
|
Another Hyperlink Question by
RogerT
Hi - I have a long list of names. Each of these names contains a non-displayed hyperlink (one hyperlink per cell). I want to copy only the hyperlinks to...
|
|
4 |
323 |
|
|
Subtotals by
J. Mack
I get the following error message when I try to subtotal my list in Excel 2003. I have been using other versions of Excel for many year, and have never had...
|
|
5 |
341 |
|
|
Excel Templates by
StrangerMike
Hello, this is my first post to this forum.
I am brand new to Excel. I have experience with VB, .net, Access but I
never used excel (other than importing...
|
|
8 |
435 |
|
|
file format not valid by
bill
I moved a spreadsheet from one file to another and when I
try to open, I get 'file format not valid'
|
July 29th, 2004 01:37 AM
by hgrove
|
1 |
195 |