|
|
macro - hide rows by
Will
I will try this again but I do not understand all the
lingo so please lead me.
Cells A2:A60 contain formulas that return a result of
either "" or a number....
|
September 17th, 2003 10:18 PM
by Will
|
3 |
446 |
|
|
revision number of excel worksheet.. by
PhantomSteve
Is there any way I can get a cell to show the revision number of the
current document (ie how many times it has been saved)?
In Word, this is done by...
|
|
1 |
406 |
|
|
Formula Help by
SFrick
In row 5 i have text, positve and negative numbers.
I need a formula that will return 1 when the cell above in row 5 is
positive and 0 when it is negative or...
|
|
1 |
258 |
|
|
This directed to John Wilson/or anyone else by
Radio848
Hi Guys & Gals:
John provided me with the enclosed macro, (I have made modifications, so the
problem isn't his fault)
Problem: I can only get the enclosed to...
|
September 17th, 2003 11:09 PM
by Radio848
|
6 |
391 |
|
|
Split Combined Name by
dlaw
Cell A contains a name in the format 'first initial last'.
I want to create cells from this: 'first' 'initial'
and 'last'.
Are there formulas for the 3 cells...
|
September 17th, 2003 11:14 PM
by mr
|
1 |
438 |
|
|
Changing A1 to $A$1..... by
43fan
Is there any way to change a set of cells all at one time? The entire
equation?
I'm copying cells from one area in the worksheet to another, and I don't
want...
|
September 17th, 2003 11:31 PM
by jr
|
3 |
299 |
|
|
TROUBLESHOOTING VLOOKUP - PASTE NEW VALUES by
Charlie Marcous
I have a workbook where column "I" looks up the value
in "J" in another worksheet and returns a correct value
for column "I" which works for 400+ rows just...
|
|
1 |
719 |
|
|
Counting by
Jennifer
I have three columns that I am using. I am trying to
count one column if the other two columns meet some
criteria.
B2:B2000 has data that is either: 1, 2, or...
|
|
1 |
259 |
|
|
sumproduct formula by
Sue
How do I get the following formula to work I want to count
the # of lines that have vendor in column L and a date
between the values referenced, and any cell...
|
|
1 |
280 |
|
|
AutoSum Limitation? by
Kelly
Does anyone know what the limitation is on how many cells
you can use in a Sum function?
I ask because I'm trying to total about 60 cells into 1
and receive...
|
|
1 |
154 |
|
|
sum minus the smalles cell by
Hai Nguyen
Hi All.
How do create a formula which give me the sum of 5 cells minus the smallest
cell?
eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas...
|
September 18th, 2003 12:17 AM
by 2rrs
|
4 |
317 |
|
|
|
|
1 |
607 |
|
|
Formula help, CELL Function help needed. by
Kenny McCormick
Thanks,
That did help me see what matches i have in the two sets of
colums but I am still lacking the second part where if there is a
match in the two colums,...
|
September 18th, 2003 01:13 AM
by Biff
|
2 |
587 |
|
|
sumproduct by
sue
Can someone tell whats wrong with the following formula? i
want to the number of lines that has vendor in column L
etc and any cells in column F that contains...
|
|
1 |
247 |
|
|
|
September 18th, 2003 01:34 AM
by acw
|
1 |
440 |
|
|
Date Format by
Susan
I have a spreadsheet with several hundred dates in
diffferect cells. The dates are typed in as "01/01/2003"
but show up in the spreadsheet as a five digit...
|
|
2 |
438 |
|
|
return in excel by
Christian
i have a cell in a spreadsheet, which i was currently
displaying the values of two other cells, with a space
between the values. what i would like would be to...
|
September 18th, 2003 01:45 AM
by acw
|
4 |
272 |
|
|
automatic links by
Leticia
I have copied a file to re-use for another purpose. I made
my changes, but now it has an automatic link from the
original file. I have looked all over to try...
|
September 18th, 2003 01:50 AM
by acw
|
2 |
476 |
|
|
Excel 2000 - PivotTable Sort and Top 10 by
Craig Padoa
I have just purchased this Micosft published book
Accessing and Analyzing Data with Microsoft Excel. I am
currently on the Pivot Table section (Chapeter...
|
|
1 |
593 |
|
|
last day of month by
Radeesh
Hi
I am using a formula to get a sum amounts between the first of the month and
the last day of the month. I am using 29 as the last day of the month.
months...
|
|
3 |
310 |