|
|
Which formula? by
Canon
Office 2007
I am looking for a formula that will do the following;
If cell B6 equals Belmont, then cell B7 should equal 8.00, if cell B6 equals
SPS, then cell...
|
|
4 |
113 |
|
|
|
Smallest positive value by
danpt
Can someone help me with a formula that will return the smallest positive
value in a given unsorted range?
Thanks
|
April 29th, 2009 02:22 AM
by danpt 
|
2 |
112 |
|
|
|
#value error by
jake
Please Help.
I've been using this formula
=SUMPRODUCT(--(G26:G59=AX9),--(AW9:AW36=AW44),AZ9:AZ36)*COUNTIF(G26:G59,AX9)
It keeps returning a #VALUE! error and...
|
|
1 |
107 |
|
|
|
Word Table to Excel by
Richard
I'm trying to get an address list that is in a Word 2003 table and copy it
into Excel 2003. The address cell in the table is at least two lines. Is
there a...
|
April 29th, 2009 01:01 AM
by Richard
|
0 |
135 |
|
|
|
Drop Down Shading by
Graeme Wallace
Hi,
I wish to create a means of automating my cell shading - ie, I have a
spreadsheet which uses a cell shaded either "red", "yellow" or "green"
depending...
|
April 29th, 2009 12:40 AM
by Pete_UK
|
3 |
92 |
|
|
|
envelope mail merge by
[email protected]
I merged excel to word document to print out delivery address. I see
all the addresses have been merged, but when I click merge to printer,
it only prints the...
|
|
0 |
101 |
|
|
|
Creating a Summary Sheet by
Needing Help
I am fairly new to Excel and have been asked to create the following:
A spreadsheet with information such as:
Cust No, Job Description, Job Status, Start...
|
|
4 |
123 |
|
|
|
Pasting Excel file for .html table by
DAVETGC
I have been using my old version of Excel for years to past a table onto my
Adobe PageMill 3.0 to create a .html table document. Unfortunately, when I...
|
April 28th, 2009 10:53 PM
by DAVETGC
|
0 |
137 |
|
|
|
Vlookup function macro by
Jack
i have a series of tables that i need to select from, Below is a sample of
the if statement i have written. I need to copy this to multiple cells. Is
there...
|
April 28th, 2009 10:51 PM
by Jack
|
2 |
102 |
|
|
|
"Print what" default by
ruddyruss
On my pc at home, when I print using excel 2007 it defaults to "Active
Sheet(s)". At work on a different PC, excel 2007 defaults to "Entire
Workbook". Why...
|
|
0 |
90 |
|
|
|
Using conditional formatting by
Ayo
I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green
and I...
|
|
8 |
79 |
|
|
|
Import Access data into Excel 2007 by
rick
When I do an external data link to an Access query, I only get one row of
data, but the query has over 50 records. Anyone have this problem?
|
April 28th, 2009 09:34 PM
by rick
|
0 |
101 |
|
|
|
Summarize data by
Chris
I have several worksheets with exactly the same layout, but different data
based on educational programmes. I want to summerize the data in one sheet,
but...
|
April 28th, 2009 09:24 PM
by dlw
|
1 |
122 |
|
|
|
Back up all Excel files by
Rich
Using Excel 2003, how can I copy all of my excel files to an external drive?
Does that *.xls work in some way?
Thanks,
|
|
1 |
112 |
|
|
|
|
|
0 |
119 |
|
|
|
convert number into a decimal by
Wanna Learn
Hello I have a spreadsheet in column b there is a number when I try
to format the number to a percentange I get the wrong answer. example
column...
|
April 28th, 2009 08:19 PM
by FSt1
|
3 |
94 |
|
|
|
|
April 28th, 2009 08:13 PM
by Bob I
|
1 |
82 |
|
|
|
Counter in macro by
orquidea
I set a loop which is supposed to go over all the list in file Switch
Accounts. There is a list of 10 different companies and retrieve the data
from the...
|
|
0 |
130 |
|
|
|
Printing multiple copies in Excel 2003 by
Fred
Our office is having problems printing multiple copies of a worksheet,
sometimes.
Windows XP SP3, Office 2003 SP3, all updates are current and installed...
|
April 28th, 2009 08:03 PM
by Fred
|
0 |
133 |
|
|
|
|
|
0 |
122 |
