|
|
Cross/Multi-posted on purpose...... by
CLR
Hi All,
SameStuffDifferentDay..........my posts are still all missing from this
newsgroup, and have been cut 'way back from the other groups.......as soon
as...
|
|
4 |
160 |
|
|
list sorting by
jake
I have a long list, about 2,000 rows with 8 columns, and I
am trying to get a random sample from this list. I then
want this random sample to be drawn from...
|
|
1 |
326 |
|
|
SUMIF based on Today() function by
Andrew Holmes
I would like to be able to calculate sales figures in one
column based on a comparison of today's date with the
date received information put in the sheet by...
|
October 2nd, 2003 07:33 PM
by Biff
|
1 |
313 |
|
|
autosum by
is it possible to autosum from 2 different sheets
|
October 2nd, 2003 07:50 PM
by Paul B
|
1 |
185 |
|
|
Dsum vs SumIf performance by
Susan Lammi
I need to do a conditional sum on a column of numbers and have two choices
I can see.
the condition is the combination of two other cells (adjacent...
|
|
1 |
324 |
|
|
Hyperlinks by
Ross
Are you able to create a hyperlink between two workbooks
and specify which sheet the hyperlink should go to?
|
October 2nd, 2003 08:07 PM
by Ross
|
2 |
131 |
|
|
|
October 2nd, 2003 08:24 PM
by eijaz
|
6 |
555 |
|
|
Application of "Rank" formula to a table by
MY
I have a table in Excel that has column headings from B1 to J1. In
Column A (starting A2), I have dates going down. The table is
populated with numbers...
|
|
1 |
218 |
|
|
Template Update Help by
ND
I have created a template to use as a form when filling
in a database and it works wonderfully when I am adding a
new record, however, I am not able to update...
|
October 2nd, 2003 09:19 PM
by ND
|
1 |
625 |
|
|
TRIM Macro by
Danny
Can somebody help me write a macro to TRIM extra spaces? I
tried the example in the built excel help (see below) but
it won't work. I need the macro if I...
|
October 2nd, 2003 10:24 PM
by Danny
|
2 |
172 |
|
|
Is there a way to NOT reduce fractions? by
atom
I have a formula that divides the numbers in two cells. The result is
displayed as a fraction. How can I keep the numbers from being reduced.
i.e. I DON'T want...
|
|
2 |
78 |
|
|
How do I calculate in a % (taxes)? by
Treg
I recently made a recipt template and I was wondering how
I can get a tax total to show up? I just need to know
what formula (x 7.75%) to use to get the tax...
|
October 2nd, 2003 11:06 PM
by treg
|
3 |
145 |
|
|
Countif Function by
Joe Gieder
I'm trying to count the number of cells that are greater
than "26 wks". When I use Countif('Priced BOM'!
S3:S82,"=26 wks") I also get the cells with 3 wks,...
|
|
2 |
92 |
|
|
excel Function/macro by
Lance Masunaga
Is it possible to run a macro and a function
simultaneousely. Example. When you run a macro if a
certain cell has a specific data in it then do this, if
not...
|
October 2nd, 2003 11:26 PM
by Jill
|
1 |
98 |
|
|
worksheet delay response by
Alice Thomson
When opening an existing excel file for the first time
there is a 30 second delay before any changes are seen or
can be used. The delay does not occur in a new...
|
October 2nd, 2003 11:38 PM
by Jill
|
1 |
93 |
|
|
Excell Worksheet by
tONY
How can i build a clear Button in my worksheet to clear
the unprotected cells of the partialy protected page.
Do I have to have Marcros incorporated with or...
|
October 2nd, 2003 11:42 PM
by Jill
|
1 |
88 |
|
|
Summing marked cells by
Sam
I need to include "marked" cells in a formula. Ideally,
when a cell is shaded a color or marked in a similar
manner, this would cause the cell to be included...
|
October 2nd, 2003 11:59 PM
by Jill
|
2 |
261 |
|
|
=IF function by
Raffi
I could really use some help with a function in Excel.
Example: A1 has the number 5. in cell A2 I want to use a
formula to calculate the following. If the...
|
|
2 |
128 |
|
|
Number days between 2 dates by
Kreiss
I'm looking to find a way to tell how many days are
between two dates. I found function, "Days 360", but that
doesn't give me a true number since it's based...
|
October 3rd, 2003 01:48 AM
by GB
|
6 |
553 |
|
|
Bold/Underline in formula by
mate
I have the following:
="with effect from November 2003 to the sum of £" &ROUND(E33,2) &"."
I need the 'Nov 03' and the result of '&round' to be bold...
|
October 3rd, 2003 02:24 AM
by GB
|
3 |
113 |