Worksheet Functions - Page 4379

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
ISBLANK function??? by Zilla Say I have this 1 2 A f1 f2 B ? ? How do I leave B1 and B2 blank if their corresponding f1 and f2 functions in A1 and A2 respectively...	February 22nd, 2007 07:42 PM by T. Valko	3	51
Transposing a whole table by Zilla I'm awayre of the transpose function. But is there a way to transpose a "whole" table so ALL its rows become columns, and all its columns become rows? -- -...	February 22nd, 2007 03:33 PM by Max	2	52
Skipping cells for SUMIF or COUNTIF functions?? by Zilla Anyway to use the above functions to, say, work every other nth cell in a row or column? Say I just want to process A1, A4, A7, etc. (every 3rd cell, n=3), or...	February 28th, 2007 03:43 PM by JE McGimpsey	9	57
Cell/worksheet protection with macros enabled by Zilla I'm using a VBA macro courtesy of Debra D. on this NG to temproraily resize the column for a drop-down list. All work fine. Now I've lock some of these cells...	March 6th, 2007 01:07 AM by Zilla	7	49
Help debugging a VLOOKUP and MATCH combo by Zilla I'm experiencing a programmer's nightmare... I have a function that sometimes works, and sometimes NOT. I'd rather it work or not 100%. If anyone is willing...	March 18th, 2007 06:11 PM by T. Valko	2	103
Formula editor??? by Zilla Is there a formula "editor" in Excel, except for the little window in the toolbar? For example, I may have a long formula for one row that repeats $C$10. Now I...	February 21st, 2007 01:22 AM by Gord Dibben	2	59
Pasting formulas but not the links help needed by [email protected] How can I paste a formula onto a seperate spreadsheet from a template I made but not have the link from the template included in the formula?	August 31st, 2006 04:12 PM by Zilla	2	51
indirect function with r1c1 style by Zim =INDIRECT("'"&R2C2&"'!R81C3",FALSE) This is the formula I am trying to use. What I am trying to accomplish is to return the value of Cell (R81C3) on...	April 8th, 2009 04:10 PM by Zim	4	62
how to find a special total from a combination of numbers by Zima I want to find a specific total from a combination of numbers on a spreadsheet. How can i go about this in excel	May 7th, 2007 05:02 PM by Harlan Grove[_2_]	4	69
Help Needed - Formula by zimmeml2 I need a formula that will count the TOTAL number of characters in an individual cell - that can then be applied to a range of cells to find all cells that...	December 4th, 2003 05:10 PM by Charles Maxson	5	189
why does =GAMMAINV(0,5;389;1) return #NUM! ? by zimmerp why does =GAMMAINV(0,5;389;1) return #NUM! ? This function is supposed to return num only when parametres are less than or equal 0. Excel solves...	December 10th, 2005 01:39 PM by Jerry W. Lewis	3	102
Using a lookup to return multiple values in one cell?? by zim_zimmer Ok, basically I want to do a lookup to return some figures... I know all the VLOOKUP, etc... trouble is I don't just want to return one figure. It may be 1...	July 7th, 2006 01:00 PM by Bernie Deitrick	1	59
Date/time calculation by zina13 Hi, I am new in Excel. So, It must be an easy question... I have a date/time a cell with date/time values: A1: 9/3/04 11:13 I need to create column...	September 13th, 2004 06:35 PM by zina13	4	214
counting instances of predefined text in a row by Zing Hi Sorry am new to this. Can someone please tell me how I can get the total at the end of a row that text like Mid, Har,Yor, Sto is entered into cells. I...	January 17th, 2010 05:51 PM by Gil	3	142
Cell border by [email protected] What's the method for Cell Border in the code module.	November 28th, 2006 10:07 AM by Bob Phillips	1	49
Copy pages, delete certain values by zinzah Hi. Trying to create a multiple page workbook. Start with 3 pages. Pages 2 and 3 have data that does not change and is used by page 1 with VLOOKUP. I have been...	July 22nd, 2004 01:51 AM by zinzah	4	303
Reference a ToggleButton in Cell Formula by zinzah I am trying to reference the status of a Toggle Button in a formula within a cell. I am trying to have a cell recalculate based upon whether the value of...	July 22nd, 2004 02:45 PM by Vasant Nanavati	3	248
"Delocalized" date format by zio69 I would like to manipulate dates in an excel worksheet (that is avoiding VBA, I guess i could accomplish my goal with VBA) in a way that would make my...	March 6th, 2009 12:58 PM by Bernard Liengme[_2_]	8	92
changing August 31, 2007 into 31.08.2007 by ziom I'm struggling with changing the date in cell like August 31, 2007 into 31.08.2007, and the range Aug 1, 2007 - Aug 31, 2007 into a european format date. I...	September 17th, 2007 06:44 AM by ziom	4	60
what is the fomula for the MACD? by Zip I'm trying to calculate a trendline using the MACD but I don't know the formula. If someone knows it, I would appreciate it. Thanks.	December 2nd, 2006 03:23 AM by Ron Rosenfeld	1	50

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