|
|
Number of entries in drop down box by
theslaz
I have a drop down box in my spreadsheet that I use for listing the
builders that I work with/for. It appears that the max. number of
entries is 12. Can I...
( 1 2)
|
|
17 |
599 |
|
|
Merging Colums by
Spatzz
Hi i have a sheet with data in the following format
Column1 Column2 Column3 etc
Y
Y
...
( 1 2)
|
May 20th, 2007 02:01 AM
by Spatzz
|
17 |
192 |
|
|
Validating times by
Jack Isaacs
Hello All
This really follows on from my previous post. I have a worksheet that will
be used for simple data entry of name, address, etc etc. - 1 column per...
( 1 2)
|
October 6th, 2007 10:09 AM
by MartinW
|
17 |
220 |
|
|
Upgrade to 2007 by
PA
We have been using Office 2002 for 4 years, with approxiately 6000 users,
have a large selection of macros used by many of our users.
The question we are...
( 1 2)
|
|
17 |
248 |
|
|
|
|
16 |
548 |
|
|
projecting sales for month by
Karen Smith
i know formula but can't get it to work;
I have to take the sales for the day multiply it by the accounting day and
then divide it by total number of days but...
( 1 2)
|
|
16 |
317 |
|
|
|
|
16 |
199 |
|
|
|
May 9th, 2008 02:02 AM
by Max
|
16 |
293 |
|
|
Help with macro by
Theslaz
I have a workbook with 5 pages ( I apologize if those are not the right
terms )
1 for "Reference tables"
1 for "Invoice data Entry"
1 for "Job Pending &...
( 1 2)
|
|
16 |
268 |
|
|
|
September 26th, 2006 01:54 AM
by Max
|
16 |
159 |
|
|
copy with format by
horst
I have a sheet with various formattings (background and text colored,
large and small texts, borders etc.).
When I copy and paste it into another sheet I get...
( 1 2)
|
|
16 |
147 |
|
|
Strange border format. by
Rodney
In my sheet, I have a bunch of cells that have dotted borders,
I cannot change this under format.
When I add a column alongside, that part of the column offers...
( 1 2)
|
May 10th, 2005 07:55 AM
by Alan
|
16 |
365 |
|
|
help with formula by
Scudo
In cell I8 I put a 1 or 2
If I put 1 then I want cell M7 tp show £150
If I put 2 then i want cell M7 to show £125 and cell M8 to show £125
As a variation if...
( 1 2)
|
|
16 |
214 |
|
|
|
|
16 |
374 |
|
|
Friday by
Winston
Hi
How do I calculate the following problem
If today does not equal friday then go back to last friday.
Can anyone HELP?
Regards
( 1 2)
|
|
16 |
251 |
|
|
|
August 29th, 2006 05:19 PM
by Epinn
|
16 |
247 |
|
|
Averages by
Zygy
Is there a formula by which when I have say e.g. four entries in a column
on lines 31,32,33 & 34 I can obtain a average of these entries in line 35?
If there...
( 1 2)
|
June 19th, 2006 10:01 PM
by CLR
|
16 |
173 |
|
|
A cell appears "######". What's this? by
marlen_athens
I write down a type, for example "55,000", which is by default a general
type. From the menu Format, Cells, Number , I try to make it as an
accounting...
( 1 2)
|
|
16 |
318 |
|
|
Formula? by
omocron
First, let me apologise for my lack of Excel knowlege. I have tried to teach
myself to create this formula on my Excel 2002, however....I give. I humbly...
( 1 2)
|
February 18th, 2010 03:57 AM
by JLatham
|
16 |
513 |
|
|
help on a macro by
gls858
I recorded macro that imports a text file and adds headers
to the columns. When I run the macro it opens a new workbook
and inserts the text file.
Is is...
( 1 2)
|
March 18th, 2005 10:56 PM
by gls858
|
15 |
302 |