|
|
|
|
4 |
103 |
|
|
Sortin method advice please by
Zipadeedoodaa
I am new to excel and would like some advice please.
I am treasurer for a forthcoming concert. All the seats are numbered in the
concert hall. As the bookings...
|
|
2 |
67 |
|
|
Array formula needed by
ZipCurs
I want to perform an sumproduct type of function with on column of data (1 x
n) and the minimum value in each row of a 2 x n matrix. Is there a simple
formula...
|
|
4 |
109 |
|
|
Keeping Control Buttons Still by
ZipCurs
I have created an interface sheet with a number of control buttons on it. I
do not want the buttons to move or change size. I have set the properties...
|
December 14th, 2005 11:41 PM
by ZipCurs
|
1 |
83 |
|
|
|
June 25th, 2009 02:46 AM
by zipidy
|
0 |
97 |
|
|
header/footer by
zipper
How do you use the & key in header, the & doesn't appear
|
|
1 |
50 |
|
|
Currency vs. Accounting Format by
zippy
I see the differece between these formats, but I'm wondering why or
when one should be used over the other? Thanks for your ideas.
|
July 19th, 2006 02:59 AM
by zippy
|
0 |
58 |
|
|
Splitting information in cells by
Zippy
I need to split information in one cells into various cells. EG B1 holds an
address, 11 One Street, Kookoo, 1111. I want to divided that info into A1-
11...
|
August 15th, 2008 01:38 PM
by tech1NJ
|
7 |
58 |
|
|
|
|
1 |
80 |
|
|
Remove Password by
Zita
I want to remove a password from a workbook so it opens without one. It is
unshared file.
|
|
3 |
73 |
|
|
Macros and security by
Zita
I have check boxes in my excel sheet.
When I click a box and save as (I think enabeling macros), the next time I
open it, I cannot change the check unless I...
|
January 15th, 2010 08:26 PM
by Zita
|
0 |
77 |
|
|
cannot paste link using equal sign by
zizu
I cannot make a paste link between 2 worksheets in excel 2003 if I use equal
sign (=). For example I have data is in Sheet1!A1, and I want to copy it to...
|
|
1 |
66 |
|
|
Date/time Duration by
zjay
How do I make a formula in excel which will allow me to calculate the
duration in hours and minutes of two different dates and times? IE: 1/1/05
01:00 to...
|
|
1 |
69 |
|
|
|
October 15th, 2007 03:02 PM
by zjopa
|
0 |
48 |
|
|
|
|
1 |
251 |
|
|
|
|
5 |
180 |
|
|
|
October 27th, 2005 01:34 PM
by Ian
|
3 |
109 |
|
|
|
|
5 |
46 |
|
|
|
|
1 |
69 |
|
|
SUMIF for Dates / Months ? by
ZMAN
Hi, I have a spreadsheet that has every day of the year (1/1/2004 to
12/31/2004) and I am trying to sum a column next to it to get only
totals for each month. ...
|
August 26th, 2005 02:07 AM
by ZMAN
|
5 |
154 |