|
summing name range in the same column with Dynamic name ranges
Hi all,
I have a dynamic name range in a column, say colA with name Test from A7
to the end of the column. When I set A5 = sum(test), it always gives me 0.
Any idea why?
Thanks,...
|
9 |
24.09.2006 04:19:00 |
|
|
How do I get speed given time (hh:mm:ss) and distance in Excel?
I have marathon times in hh:mm:ss format and want to get the miles/hour
speed, where miles is 26.2. How do I do that? I have Excel 2003....
|
2 |
24.09.2006 04:02:01 |
|
|
Calc minutes and seconds difference
Spreadsheet tracks race times for cross country races and needs to be able to
calculate improvement time in mm:ss (or zero if less than previous race).
Also,it would be nice to be able to enter times without using colons or have
to reference the field as h:mm:ss. The race result will always be mm:ss and
the last two digits will always be seconds, the result will never be more
than 60 ...
|
16 |
24.09.2006 03:57:02 |
|
|
Need to write 3D formula averaging total sales between 3 workshee
I need to write a 3D formula averaging January Sales for B3:B8 linking
between 3 worksheets called Sales 2002, Sales 2003, Sales 2004. Please help
me....
|
4 |
24.09.2006 02:36:00 |
|
|
"Workdays"
I have colomn with start date(Column A), Column C = duration Column B =
Column a + Column C
I would like exclude Saturday and Sunday of the week
How can I do That?
Please Help...
|
3 |
24.09.2006 00:12:39 |
|
|
how do you hide SUM(number1,[number2],...
This box is in my way when using @sum, but I am unable to find how to hide it.
how do you hide SUM(number1,[number2],......
|
7 |
24.09.2006 00:05:22 |
|
|
Macro for printing
How do I make a macro to print e.g. sheet 2, sheet 3 or sheet 100 by clicking
a button on sheet 1?
--
Ewout...
|
2 |
23.09.2006 22:33:02 |
|
|
How do I calculate exact difference between two dates in y,m,d.
I tried to callculate the difference between 14.02.1980 and 21.02.1985, but
excel does not give the exact difference in years, months and days.
I used the formula
=DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months,
"&DATEDIF(A10,B10,"MD")&"Days."...
|
9 |
23.09.2006 21:02:02 |
|
|
Inserted Comments in published workbooks
How do I, or can I, preserve the corner comment indicators in a published
workbook? I had hoped that those viewing the workbook on the net would be
able to move their cursor over the indicator to get additional cell comments
just like it works when within the XL application. Instead, the comment
indicators become bracketed # hyperlinks like this [1] placed at the end of
the cell info...
|
1 |
23.09.2006 20:21:02 |
|
|
Need a sorting solution
Hi,
I posted on the "microsoft.public.excel" group, I am hoping someone
different is reading this group.
Thanks
XP Pro
Excel '03 plus '07 beta...
I am doing a mail merge from excel. There are two pieces to a page. I need
to sort the list but when I do a two up page, page 1 has #1 and so forth.
In small quantity that is not a big deal but when you do a 1000 pieces it
adds...
|
6 |
23.09.2006 19:17:49 |
|
|
USING EXCEL, delete all text right of the "!" symbol
I am trying to delete characters in a Excel cell right of the "!" symbol. Is
there a function that can be used to do that...
|
6 |
23.09.2006 18:52:56 |
|
|
Reference previous page
I need to make a workbook with 52 pages (1 for each week) that looks at the
previous page and updates accordingly. Right now, when I create a new page I
have been using find/replace to replace all page references to the correct
page. This is very time consuming and I am hoping to make it quicker as I
have to make 12 files this same way - one for each person.
Any suggestions will be grea...
|
4 |
23.09.2006 18:49:09 |
|
|
Naming a cell
How to give same name to a cell in multiple sheets at the same time
I did try to group all the sheet at the sametime and name the cell, but it
did not work, each of my sheet have different name?
Need Help!...
|
9 |
23.09.2006 18:40:43 |
|
|
need to transpose 1422 values from a column to row
Is it possible? since we dont have 1422 columns, how would the data be
transposed?
Thanks in advance.
...
|
3 |
23.09.2006 18:32:08 |
|
|
INDIRECT function inside AND function
I have the following formula as a conditional formatting test:
=AND($E13="Y",INDIRECT("G13")="",$M13="")
The INDIRECT function is testing to see if the cell in column G of the same
row is blank. I need to use INDIRECT instead of a direct reference because
the data in column G can get cut/pasted, and I need to hold the reference
stable. But I need to copy this conditional format down ...
|
5 |
23.09.2006 18:20:01 |
|
|
Protecting Cells
I have written a spreadsheet in Excel 2003. I am attempting to protect
certain cells in the workbook. A requirement of this workbook is to be able
to hide columns. To do this I need to be able to select locked cells. I've
locked the cells that require protecting and when proteting the sheet I've
selected the option to "select locked cells". When I protect the sheet
certain cells do not p...
|
1 |
23.09.2006 17:55:02 |
|
|
will vlookup work for me?
My spreadsheet shows a row per product each customer has bought e.g. if a
customer has bought a book and a dvd from us, it will show on two rows.
How do I manipulate this data so that there is 1 row for each customer and
then detailing in two different columns what products were bought?
Each customer has a unique reference that would be the same on each
transaction - would vlookup help...
|
2 |
23.09.2006 17:13:51 |
|
|
Pivot tables hide info drop down menu
I have a pivot table and I need to hide data on the worksheet. When I access
the drop down menu, all of the categories do not appear on the list. How do
I get all items to appear in the drop down menu? What causes this?
...
|
2 |
23.09.2006 17:08:11 |
|
|
Text to date
Hi,
Hope someone can help me with this. I am trying to convert "Wed. Sep. 20,
2006 14:16" into a format recognized by excel (9/30/06 14:16). Have tried to
extract and collate the data using
"=CONCATENATE(VALUE(RIGHT(LEFT(B3,12),2))," ",RIGHT(LEFT(B3,8),3),"
",RIGHT(LEFT(B3,18),4)," ",RIGHT(B3,5))", but all my efforts are in vain when
I try to convert it to a date and time format recog...
|
3 |
23.09.2006 16:07:02 |
|
|
Using dates as function arguments in Excel
I am looking for a reliable way to use the numbers obtained when doing
arithmetic functions on dates as input for a subsequent calculation. For
example, when subtracting dates, I get an error message. This can be
corrected by resetting the format of the cell to "general," but this would
be too onerous to do every time. I also need a way to do this when
subtracting an earlier date fro...
|
3 |
23.09.2006 13:37:01 |
|
|
Simplify formula
I have a column of text that will have a column of numbers associated with
them.
I need to have the number appear on different spreadsheets when the text
appears appears next on that spreadsheet.
Text will appear on Project List sheet and may have a number next to it. An
IF function populates the other spreadsheets with the text from the Project
List sheet.
I need a formula that wil...
|
6 |
23.09.2006 13:25:13 |
|
|
copy part of a worksheet into a worksheet in the same file/keepi.
Excel 2000 My workbook contains 10 sheets. I want to copy one particular
sheet into the middle of every other sheet. I cannot copy and paste because I
lose the format, formulas, etc... I can link , but the user would have to
open the link to view, unless there is a way to keep the link expanded....
|
2 |
23.09.2006 08:13:01 |
|
|
sorting protected sheets
I have a worksheet that has a column of locked cells but all the rest are
unlocked. I want all the locked cells protected to keep multiple users from
messing up formulas. Is there a way to sort this sheet after it is
protected? I am having to unprotect the sheet everytime I want to resort the
data. thanks!
...
|
2 |
23.09.2006 08:06:01 |
|
|
Create formula
How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then
E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4?
...
|
6 |
23.09.2006 06:57:14 |
|
|
3 criteria
I have the following formula for adding numbers that match two criteria
that works fine
=SUMPRODUCT(--($E$125:$E$1084=AM4),--($AS$125:$AS$1084="yes"),$K$125:$K$1084)
I want to add a third criteria so I did this:
=SUMPRODUCT(--($E$125:$E$1084=AM4),--($E$125:$E$1084=AM34),--($AS$125:$AS$1084="yes"),$K$125:$K$1084)
and now the formula result is always 0
How can I add a third criteria to b...
|
3 |
23.09.2006 05:54:26 |