|
|
Matching Criteria in adjacent columns by
frankjh19701[_5_]
Here's this one:
I want to have a formula that will return the value of a cell that is
adjacent to specific criteria in the adjacent cells next to it....
( 1 2)
|
March 30th, 2007 11:02 AM
by Max
|
10 |
814 |
|
|
Drop-Down List by
Doctorjones_md
I wasn't really sure how to phrase this one -- this isn't your Typical
Drop-Down List.
I have a SELECT statement which queries SQL Server 2005 and displays...
|
|
3 |
270 |
|
|
Pivot Table - Reference is not valid by
Sinner
I have a list in a file name abc.xls. I have defined the list with a
name say XYZ.
I have another file Summary.xls with a pivot table that I'm using to
give me...
|
March 31st, 2007 04:18 PM
by Sinner
|
0 |
170 |
|
|
External app with switches in link by
Scott[_4_]
Is it possible to launch an external application with its switches, from
within a "=HYPERLINK"? Something link this;
=HYPERLINK("C:\Program...
|
|
1 |
223 |
|
|
Spammed by Fax?? Read inside by
Nick
Spammed by fax?
Is your fax machine being loaded up with useless offers and unwanted advertising?
Tired of someone using your paper & ink for their own...
|
April 6th, 2007 09:18 AM
by Nick
|
0 |
188 |
|
|
Automatically update data across worksheets by
Lancashire Lass
I have an Excel worksheet containing 4 worksheets. The main data is in Sheet 1. I need to update certain cells in Sheet 1 regularly and those cells are...
|
|
1 |
220 |
|
|
|
April 14th, 2007 12:29 PM
by Max
|
1 |
170 |
|
|
|
April 14th, 2007 02:40 PM
by Yaff
|
0 |
147 |
|
|
|
|
2 |
189 |
|
|
Links sent via Email not working by
Richard
I have just set up a source and destination workbook on my pc. The results
were excellant. I then emailed both to a colleague with who their is no
common...
|
April 18th, 2007 12:48 PM
by Richard
|
0 |
139 |
|
|
Enable Command Button base on UserName by
Doctorjones_md
I have a Command Button on a worksheet that I only want to display if a
specified User Opens the workbook.
I have the following code:
(in a UserName...
|
|
6 |
270 |
|
|
|
|
0 |
152 |
|
|
How can I count the number of links? by
Mr Clone enolC
My spread sheet has a column of hyperlinks. About 100 of them. They
are jobs I've applied for from the job sites. Is there a way I can
search through the...
|
|
1 |
169 |
|
|
|
April 22nd, 2007 11:54 AM
by FloMM2
|
1 |
443 |
|
|
p value by
Ali
I would appreciate it if some one tells me what functions or add-ins to
use to calculate P-value.
Regards
|
|
3 |
194 |
|
|
|
|
0 |
194 |
|
|
|
|
0 |
190 |
|
|
Importing Access Queries by
Bill
Hi All,
I'm trying to import a data from a query in an access mdb file but can only
see a few of the queries. There is no reason that I can spot why some are...
|
|
1 |
173 |
|
|
link trouble by
brownti via OfficeKB.com
I have a worksheet that has about 1700 links to another worksheet on it.
When the file is in use the values that are linked will not change, however
they could...
|
|
0 |
160 |
|
|
formatting in links by
chumley
I am using a named range as a link in an Excel chart title. Is there any way
to maintain the formatting used in the original cells in the range?
|
|
0 |
151 |