Worksheet Functions - Page 556

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
Vlookup inside a formula by willemeulen[_4_] Is it possible to use a vlookup funciont inside a formula? :Bgr -- willemeulen Blink1 Willem van der Meulen BSc Soil & Water Eng...	May 14th, 2009 10:33 AM by Mike H	1	76
Lookup and return any missing numbers if applicable by Chel Is it possible to write a formula that will autopopulate a column with any missing numbers. I believe it should be something really simple, but I can't get...	May 14th, 2009 08:45 AM by bosco_yip[_2_]	2	78
How do I get a cell to highlight when a deadline date approaching by Frustratedfemale26 I am trying to set up a spreadsheet that is at this present moment in time getting the better of me. I know what I want it to do, but cant seem to get it to...	May 14th, 2009 08:45 AM by Jacob Skaria	2	73
Copy format by LiAD Hi, I have several spreadsheets where I import data using macros into a series of tables. Several operations are then performed on the data. The new...	May 14th, 2009 08:42 AM by LiAD	4	67
Round to .05 or .09 by Bruce How can I round prices to the nearest 0.05 or 0.09? Eg 1 5.01 to 4.99 Eg 2 4.44 to 4.45 Regards, Bruce	May 14th, 2009 07:56 AM by Harlan Grove[_2_]	4	117
GL Codes by Jonny54321 I have a 2008 trial balance (on its own worksheet) and in Column A consists of all the GL codes. In my 2007 trial balance (on its own worksheet), I also have...	May 14th, 2009 05:08 AM by Jacob Skaria	1	84
lookup formula unexpected results by David Ryan[_3_] Hi Folks hope someone can help. One of you guys usually can. So thanks in advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel...	May 14th, 2009 03:56 AM by Teethless mama	1	133
lookup formula unexpected results by David Ryan[_3_] Hi Folks hope someone can help. One of you guys usually can. So thanks in advance The following formula provides unexpected results. =IF(ISERROR(LOOKUP('Hotel...	May 14th, 2009 03:28 AM by Jacob Skaria	3	131
Eliminating Blank rows by Lversteeg I am hoping someone can help me!!!! I have on one sheet a product selector for my sales team. I have added a column where they can put an "x" into if...	May 14th, 2009 03:27 AM by Bernie Deitrick	3	141
Reverse SumProduct function by ajkajkajk Does anyone know how to create an array that multiplies 2 numbers together but selecting the first number in one array multiplied by the last in the other...	May 14th, 2009 02:35 AM by Lori	9	154
Returning a value if false by James W I have a spreadsheet that I am working on. It has a row that has either an X or an O for about 30 days. I am trying to write a formula that will review that...	May 14th, 2009 02:31 AM by James W[_2_]	2	91
mortgage payment calculation by kacky What is the excel formula to calculate a mortgage payment? also is there a formula which can solve the amount of principal paid in a defined period? for...	May 14th, 2009 02:06 AM by JoeU2004	6	153
Find the lowest4 numbers of the last 6 in a range by Pjmcc64 Is there a formula that will look at the last 6 non blank number values in a range, and return the average of the four lowest? The numbers are in a row that...	May 14th, 2009 02:03 AM by Harlan Grove[_2_]	4	88
EXCEL FIND A SPECIFIC TOTAL by KUNA Is there a formula or look up function within excel that will do the following: Locate within a range of cells the cells that when summed together equal a...	May 14th, 2009 01:45 AM by Lori	4	96
Calculating a value but omitting cells with empty data by Andrew Chalk I want to calculate a value based on several cells in say row 4. However, I do not want to include values in any columns that do not also have a non-missing...	May 14th, 2009 01:29 AM by Harlan Grove[_2_]	3	66
Excel, two text fields equal the number 1 per occurance by Don McLean I am in need of help with an excel function. Here is some sample data. Don coffee James coffee Joe tea Sally coffee Don tea Sally... ( 1 2)	May 14th, 2009 01:02 AM by Harlan Grove[_2_]	11	247
How to copy formulas sheet to sheet in excell by Kathy how do I copy a sum in a cell on sheet 1 that the sum changes as data is entered to sheet 2 and always have the updated sum of sheet 1?	May 14th, 2009 12:58 AM by Bernard Liengme[_2_]	1	123
Summing Values/Outputs of IF formulae by shadesoflife Would anyone be able to advise me how to go about summing the values/outputs that result from the use of a IF formula? Background - I used a IF formula to... ( 1 2)	May 13th, 2009 10:54 PM by T. Valko	10	164
Evaluate based on Actual Month by RJJ I am (with the help of this forum) successfully pulling data from a range of cells. The range I set up was data for the month of May. What should I preceed a...	May 13th, 2009 10:34 PM by Ken Wright	7	115
Round formula by GIDRA I have this formula (below). Is there an easier way to do it...	May 13th, 2009 09:03 PM by Tony7659	3	124

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