Worksheet Functions - Page 14 - OfficeFrustration

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 14 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
The last day by Ron de Bruin Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last... ( 1 2 3)	June 2nd, 2010 09:01 PM by Billns	20	2,085
How to omit blank cells when calculating weighted averages by Suzy Hello, new to Excel and need help with function. I am calculating grades for my students, and if they were absent, I do not want them penalized. What function... ( 1 2 3)	March 18th, 2010 10:00 PM by T. Valko	20	1,687
Vlookup by LWilson Is it possible to have a sum in a Vlookup? ( 1 2 3)	December 31st, 2009 10:30 PM by T. Valko	20	383
calculate percent between 10.0 and 12.0 for data in multiple sheet by wissam Hi, I have data of blood test results for patients in an excel file, with each patient's data being placed on one worksheet. For instance: Data for PatientA... ( 1 2 3)	February 3rd, 2010 03:02 AM by wissam	20	483
Referencing another workbook using a variable for the sheet? by Doug =sheet1!A1 Is it possible to make the "sheet1" portion of this formula tied to a cell in the destination workbook so that if I type "sheet2" in cell A3 of my... ( 1 2 3)	May 28th, 2010 06:45 PM by Doug	20	1,881
Help with a formmula change in a "flag" parameter! by Danny Boy The formula I have below in Column R works just fine. It creates a flag for me (in Column R) that lets me know one of two things: â€œClient Failed to Enroll... ( 1 2)	May 28th, 2010 08:16 AM by Steve Dunn	19	593
How to find a particular word? by Jack Hello, everybody! I have a dictionary that I created in excel and that is becoming too large to find particular words. I have one problem with finding. I... ( 1 2)	December 2nd, 2009 12:04 PM by Ron Rosenfeld	19	206
IF ISERROR INDIRECT MATCH Formula Question??? by grateful =IF(ISERROR((INDIRECT("'August 31, 2008'!H"&MATCH(C4,'August 31, 2008'!C:C,FALSE)) + (INDIRECT("'August 28, 2009'!H"&MATCH(C4,'August 28, 2009'!C:C,FALSE)) +... ( 1 2)	September 21st, 2009 03:01 AM by grateful	19	355
IF STATEMENT by sbain I have an if statement that says =if(ISBLANK(C3:F3),ROUNDUP(B3,0),b3+.01) First off, the statement does not seem to evaluate the "roundup" part, meaning that... ( 1 2)	June 3rd, 2010 10:35 AM by Steve Dunn	19	1,657
referencing named formula using INDIRECT function by [email protected] Hi, I'm having some problems using the INDIRECT function to reference a named formula on a different sheet. I want to be able to put the name of the sheet in... ( 1 2)	May 11th, 2005 09:48 AM by Rob Hick	19	590
Hiding cells on condition by Pennington I am trying to hide a range of cells when the value in another cell is FALSE and show the range of cells when the value is TRUE. My code is as follows but it... ( 1 2)	April 21st, 2005 12:30 AM by William	19	266
If Formula by natei6 =IfSUM(D6:D1240/24,SUM(D6:D12/24),IfSUM(D6:D1240/24,("40:00:00"))) I'm working on a time sheet, and I keep getting an error on this formula, it asks for... ( 1 2)	March 18th, 2004 06:07 PM by Frank Kabel	19	392
IPMT Function DOESN'T WORK! by Saar I have read all the answers, and even the snide remark to dave on 3/17. Also his answer to it and agree with him. I did his assignment exactly as laid out. ... ( 1 2)	March 22nd, 2004 08:28 AM by Harlan Grove	19	241
count blank cells by Annette I'm thinking this might be easy, but maybe I'm wrong! I want to count the number of blank cells found in column E ... I have will information in column D with... ( 1 2)	April 28th, 2004 05:05 AM by Harlan Grove	19	699
Last updated time for cell by Lawrence M. Seldin, CMC, CPC I have looked in this newsgroup, however, I am new to Excel. I have cell that gets automated by a data feed. I want to know, when a cell has last been... ( 1 2)	May 11th, 2004 12:58 PM by Lawrence M. Seldin, CMC, CPC	19	503
NETWORKDAYS but counting the hours not the days... by Jamesy PLEASE PLEASE HELP, What I need are the excat hours/minutes between 2 dates, my date format is as follows: - a) 24/06/04 12:15:11 b) 25/06/04 13:10:03 The... ( 1 2)	July 2nd, 2004 11:35 PM by Myrna Larson	19	250
Concatenating various cells by Angela Let me set this up. A1=smpt: B2:B300= a list of user names C3:C300= blank column for combined cells D3:D300=a column of cells that... ( 1 2)	September 13th, 2004 02:57 PM by JulieD	19	540
Help w/ IF THEN formula by Anna Can anyone help me with this problem??? Cell A B C D 10 10 11 11 12 11 13 12 14 11 R 15 11 16 11 ( 1 2)	September 17th, 2004 11:35 AM by Ron Rosenfeld	19	608
Array functions ARGHH! by Marc Fleury I'm pretty sure I need an array function for this, but nothing I do works. My data is basically two colums: A B 0 0 0 2 1 0 1 0 ( 1 2)	March 16th, 2005 09:43 PM by Wazooli	19	295
Help with LOOKUP (golf handicaps) by Tom Ogilvy =INDEX(C1:IV1,1,MATCH(9.99999999999999E+307,C1:IV1,1)) placed in B1, then drag fill down the column. It will return an error if C:IV is empty, so you could... ( 1 2)	December 15th, 2003 11:21 PM by John Wilson	19	547

Page 14 of 4390

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 02:05 PM.