Worksheet Functions - Page 101

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.

		Home » OfficeFrustration forum » Microsoft Excel
Worksheet Functions

Home

Page 101 of 4390

101

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
How to get a row consecutive from a sheet to another by rodante I hope I can get your help please. I want to know how to obtain consecutive data from a sheet to another sheet in the same excel book. I registered data in...	October 30th, 2005 06:20 PM by rodante	4	444
Formula not producing correct result by Jerry W. Lewis 1270.588235 is correct. You probably have H13 formatted to hide the decimal places, but its value is 42.35294118, not 42 (which would give 1260). Formats...	May 7th, 2004 04:45 AM by JE McGimpsey	1	444
Entering data in one sheet and have it appear in second Sheet? by Don A1(Second Worksheet): =First Worksheet!A1 A2(Second Worksheet): =First Worksheet!A1 B1(Second Worksheet): =First Worksheet!B1 B2(Second Worksheet): =First...	June 3rd, 2004 06:10 AM by Don	0	444
XIRR vs. IRR by Jen I would like to know which function is more accurate to use when calculating the IRR for quarterly cash flows. I know XIRR is to be used for irregular cash...	June 9th, 2004 03:20 AM by Fred Smith	6	444
Tools>options>edit>Fixed decimal places = 2 by Michael The override mentioned in the last sentence below does not work in Excel 2003. Can anyone help with this? Fixed decimal: Enter the number of decimal places...	August 27th, 2004 10:13 PM by Frank Kabel	1	444
Linking to Dynamic Named Ranges (Excel 2003) by 0013 I'm linking to dynamic named ranges (i.e. the ranges resize to include all items in a column based on a formula in the name field) in another worksheet. It...	July 28th, 2004 07:52 PM by Andy Wiggins	1	443
Multicell Array Formula and List Question by John Mansfield I have data in the range A1:B5 as follows: a 5 b 3 c 6 d 5 e 7 In the range E1:E5, I have added the following multi-cell array formula that returns the... ( 1 2)	March 21st, 2005 01:36 AM by Max	11	443
Bring Back Qualified Sum from another WB by I'm in WB Main.xls with 4100 as text in cell D6; I'm trying to bring back the qualified sum - taken from another WB names Feb2005Deposits.xls,...	April 8th, 2005 01:01 AM by Don Guillett	4	443
Excel formatting problem when pasting by Bill I have an Excel sheet with row and column formatting of different sizes and some cells merged. What I woul like to do is to copy the sheet 25 times below on...	April 4th, 2004 12:34 PM by Mark	2	443
assigning a macro to a command button by Steve I am attempting to assign a macro to a command button I have inserted in my worksheet. The online help in the program says to right click on the button and...	February 11th, 2004 11:07 PM by DME	3	443
Removing password protect workbook option by Brian I password protected a large, multi-tab workbook so that shared users would not alter the structure. Even though I have a long history of well-documented...	January 30th, 2004 04:46 PM by Norman Harker	1	443
cannot copy and paste specific function by Mary C. Lydon I am trying to copy a function from the formaula bar and paste it to each row and will not work for me. Everytime I get something pasted it has added the row...	October 5th, 2003 01:07 AM by RagDyer	2	443
Variable Print Area by Terry Bennett Thanks Greg but that doesn't work - it still prints on 2 pages. "GJones" wrote in...	November 20th, 2003 08:08 PM by Ron de Bruin	1	443
Far too many "IF"s for my own good by Jim My self-esteem is in the crapper; I simply cannot imagine being "good enough" to help, darn it. Perhaps someone will recommend you try VLOOKUP. -- Greeting...	December 31st, 2003 07:55 PM by Sandy Mann	8	443
method to copy cell format through formula/VBA? by Paul Moles Try format painter and/or paste special. Or do you actually want to link the format somehow in a formula in the combined...	January 8th, 2004 12:12 PM by Paul Moles	0	443
#N/A by Bob Phillips thanks bob..that did it..thanks for taking time to help -----Original Message----- Steve, =IF(ISNA(vlookup_formula),0,vlookup_formula) -- HTH	September 15th, 2003 05:27 PM by Bob Phillips	0	443
Problem: VLOOKUP for HYPERLINK address (in UNC format) by James Cox XP Pro, Excel 2002 I need to provide a hyperlink to Access databases on other PC's in our network - and those hyperlink addresses reside in another workbook. ...	January 7th, 2004 02:20 PM by James Cox	1	442
Copying condition formatting cells only by Richard Flint I would like to know if there is a way to copy the conditional formatting into from one cell to all the other cells in the column. However, the referenced cell...	October 21st, 2003 09:17 PM by Felipe	1	442
Sumproduct clarification by Walter Mayes Various members of this forum have stated that the arrays used in SUMPRODUCT must be the same. Excel HELP says, under remarks, in part..."Array arguments must... ( 1 2)	October 7th, 2003 10:52 AM by Walter Mayes	18	442
how can deactive cells to input data by Kaveh_Alborz help me plz if you see one of the templates like balance sheet in excel some of the cells are deactived and users just input data in special cells. so how...	January 10th, 2004 04:11 PM by Norman Harker	1	442

Page 101 of 4390

101

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 06:33 AM.