Worksheet Functions - Page 547

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
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...	February 19th, 2005 01:11 PM by Dave Peterson	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	February 19th, 2005 02:38 PM by Ken Wright	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...	February 19th, 2005 05:02 PM by Ron de Bruin	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...	February 19th, 2005 05:57 PM by Don Guillett	7	123
Want to change the color of a true/false logical statement with i. by gregspainting Trying to change the color of the results generated from a if:then, true/false logical statement with in a formula. I would be happy if I could change the...	February 19th, 2005 06:42 PM by Gord Dibben	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...	February 19th, 2005 08:22 PM by Jolly Rogers	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...	February 19th, 2005 08:57 PM by Peo Sjoblom	1	79
How to leave the title row in MS Excel fixed? by morisn Hello. I've seen this before but cannot figure out how to do it myself. I would like to have a way to leave the title bar of an Excel 2002 spreadsheet fixed in...	February 19th, 2005 09:42 PM by Debra Dalgleish	3	315
$$ by RTD Construction what and how do you use the $$ in excell	February 19th, 2005 10:11 PM by Myrna Larson	2	82
How do I mark an item as paid so it is not included in a column t. by BradLewBooks i am trying to keep track of all the invoices i receive from my distributors, i run a bookshop. I am trying to creat a column which gives me a total amount...	February 19th, 2005 10:22 PM by Myrna Larson	3	123
Using VLOOKUP with multiple first column matches by John Simons I have a need to extract data from a data table that has multiple matching first column entries. I need to be able to separate the results based on...	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...	February 20th, 2005 04:09 AM by Myrna Larson	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...	February 20th, 2005 05:04 AM by Myrna Larson	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...	February 20th, 2005 05:09 AM by nbrcrunch	3	175
How do I create a formula to retun a value of 0 (zero) when a VLO. by Adam at GTOFL When searching multiple tables with a V or HLOOKUP formula, I want a search that doe not find anything to result in a zero instead of an error (#N/A) I have...	February 20th, 2005 06:15 AM by Ola	4	87
Want to input one character to cause related string to display in. by Peace of Christ be with you I have a table with a long list of places (stores) in one column, the mileage from my home in the 2nd column and the money $ amount I can claim as a business...	February 20th, 2005 06:33 AM by Peace of Christ be with you	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...	February 20th, 2005 08:01 AM by Sarah Ward	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

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed