|
|
Lookup Question by
Mackay 1979
Hi,
I need to be able to match 3 columns of data against a data range.
my data consists of four columns:
Ref; Area; Release; Linked Work #
I need to be...
|
|
2 |
76 |
|
|
Help on Large Function by
Master
Hi!
I'm currently using the LARGE function to return the top 5 numbers in a set
of cells. Now the problem is that the formula sometimes returns the...
|
February 19th, 2005 01:45 PM
by Ola
|
8 |
109 |
|
|
Maximum Calculation Speed by
Ola
What is the best tool to compare the Calculation speed between two formulas?
Ola Sandstrom
I just found: http://www.acoustics-noise.com/calcsped.htm
|
|
3 |
181 |
|
|
"Excel Function Dictionary" new URL? by
Markus L
http://homepage.ntlworld.com/noneley/ (Peter Noneley's excellent Excel
Function Dictionary) is not accessible any more. Couldn't find a new URL.
Hope somebody...
|
|
1 |
100 |
|
|
Result not being returned by
Pat
=IF(OR($J740,$K$22="QS"),0,$J74)
the above formula should display the value from J74 when QS is displayed in
K22
Could someone tell me why I am not getting a...
|
February 19th, 2005 05:45 PM
by RagDyeR
|
8 |
129 |
|
|
TODAY function? by
Michelle Tucker
I am creating a macro which will insert a row, then insert text in the first
two cells. In the 3rd cell I want it to insert todays date. But if I use the
TODAY...
|
|
7 |
123 |
|
|
|
|
2 |
150 |
|
|
macro for "entering data" by
Jolly Rogers
Can anyone suggest a good macro to allow me to select (touch) any cell in
a given range, and have the alpha character "X" (capitalized) appear in
the cell when...
|
|
4 |
95 |
|
|
Number is in a text format by
dbl
Hi I have the following formula in cell B9
=INDEX(Sheet1!H:H,MATCH(B12,Sheet1!A:A,0),1)
Which brings the result I need, but when I have other cells that link...
|
|
1 |
79 |
|
|
|
|
3 |
315 |
|
|
$$ by
RTD Construction
what and how do you use the $$ in excell
|
|
2 |
82 |
|
|
|
|
3 |
123 |
|
|
|
February 20th, 2005 01:27 AM
by Ragdyer
|
2 |
286 |
|
|
Need to find oldest date in ever changing list. by
Alan Anderson via OfficeKB.com
My worksheet has Date.Ordered in COL-A and Date.Filled in COL-F. I can
find the oldest date in Date.Ordered by using the SMALL function. However,
when I...
|
|
5 |
130 |
|
|
Lookup Functions by
Sharon
Hello,
I am trying to use a lookup function to calculate the following:
To determine the amount of foreign currency due a custorm
My Excel looks like...
|
|
6 |
159 |
|
|
Weeknum Goes Missing by
Peter W
Hi
I am using WEEKNUM function in a series of MACRO routines. Problem is they
work really well than sometimes for no apparent reason I get the #NAME...
|
|
3 |
175 |
|
|
|
February 20th, 2005 06:15 AM
by Ola
|
4 |
87 |
|
|
|
|
6 |
170 |
|
|
Find and Go to Value by
Sarah Ward
Hi there
I'm running a macro that someone at my work wrote who's now left, and I'm
struggling with one line of it. I know what it does - it identifies the...
|
|
1 |
82 |
|
|
Replace Symbol "Code(63)" by
Andri
I have transferred Supplier Contacts from Outlook to Xls format.
But in Address Column, there are a lot of that symbol that i wish to delete.
How to use the...
|
February 20th, 2005 09:17 AM
by Andri
|
4 |
122 |