Worksheet Functions - Page 49 - 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 49 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Formula to compare two dates by Thomas Hi I am looking for a formula that compares two dates in a worksheet. I have inserted the current date in cell L1 (using NOW()) and would like to compare this...	October 6th, 2003 02:48 PM by Thomas	4	363
Cond. Format - Absolute Reference by Allen Scott I want to copy condidtional formatting over a range of cells. The condiditonal formatting requires an absolute cell reference. Is there a way to set the...	October 6th, 2003 03:02 PM by Bob Phillips	2	412
Formula Calculating Minus Values by Russ I have the Excel Application for calculating production run values. The only thing is that at times it brings negative results. Example being total run time...	October 6th, 2003 03:06 PM by Jack	2	446
Selective Duplication of entries into separate worksheet based on content by Paul Arnold Simple to those in the know..... I am looking for a means (if possible!) of programming Excel to duplicate a row (in its entirety) to another worksheet but...	October 6th, 2003 03:46 PM by Bob Phillips	5	155
FWD: Prove correction patch by Nicola Liuzzi	October 6th, 2003 03:49 PM by Nicola Liuzzi	0	116
IRR Function (formula) convert to annual if monthly data by Troy If the cashflows are monthly....it appears some people are converting this to an annual amount by multipling by 12. If this is correct then why does the IRR...	October 6th, 2003 04:27 PM by Troy	0	487
Extracting Averages by Bill Hi, I have a large excel data worksheet which has the basic look: Item: PointA PointB PointC PointD PointE #01 01-Feb 04-Feb 05-Feb 13-Feb...	October 6th, 2003 05:30 PM by Bernard V Liengme	1	334
VLOOKUP - Getting a reference by Rodrigo I am currently using VLOOKUP the way it was meant to be used (to return the value "Y" from a specified column and the same row of the value "X" on the first...	October 6th, 2003 06:36 PM by Peo Sjoblom	2	242
calculating hourly rate using [h]:mm:ss format by Tat I am trying to calculate the hourly rate by dividing gross pay by the total number of hours worked. In order to add time worked, I custom formatted it...	October 6th, 2003 06:45 PM by Peo Sjoblom	1	344
Limit number of charaters in a cell by Michael Coffee I am importing data from a DB, then running a macro to change the appearance of the data. I need part of that macro to cut the number of characters in a...	October 6th, 2003 06:52 PM by Ron de Bruin	1	241
Look at this important update for Windows by Rich Randle	October 6th, 2003 07:04 PM by Microsoft	1	115
Conditional format Count by Danny See Oct. 3, 2003 8:51AM posting in this newsgroup. Find Cell Color Index -----Original Message----- How to count the no of cells when the conditional...	October 6th, 2003 07:09 PM by Danny	0	114
WOW! SEPARATE NUMBER QUESTION! by T.T. Thanks to all who answered me and totally solved my problem! Regards, Tom T.	October 6th, 2003 08:47 PM by Ken Wright	3	111
Help!!!!!!!! by Steve I am trying to link combo boxes so depending on what i pick in 1 list will detemine what list is presented in the other. I have been told to do the...	October 6th, 2003 09:03 PM by Steve	2	97
Time format help by Dave Hi all, I have a spreadsheet (Excel 2002), and column H contains the formula =MINUTE(F6-E6) to generate a time period from start and finish. in Cell H78, I...	October 6th, 2003 09:12 PM by Dave	3	110
Formula returning 0 doesn't plot right by Kartan i've got 1 column that's dates, and another that's values taken on those dates. sometimes i miss a date, so the data is blank. fortunately, when i graph...	October 6th, 2003 09:20 PM by Kartan	0	97
The cell currently being evaluated contains - TIA by TecFX What am I doing wrong here? I have tried this as a straight formula and as an array formula using the Office System 2003 version of Excel. I would like the...	October 6th, 2003 09:28 PM by TecFX	4	131
Printing multiple Worksheets as 1 print job by Chuck I'm working on a problem for 1 of my customers where they have a spreadsheet w/ multiple tabs (Worksheets) they want to be able to use the duplexing & stapling...	October 6th, 2003 10:27 PM by Beth Unglesbee	1	516
Excel printing problem by KIH When trying to print from excel to a HP5SI Tecktronic printer a couple of users receive the follow message: "Printing outside margins". It does not happen with...	October 6th, 2003 10:50 PM by KIH	0	294
Dates and Averages by Bill Hi, I have a large excel data worksheet which has the basic look: Item: PointA PointB PointC PointD PointE #01 01-Feb 04-Feb 05-Feb 13-Feb...	October 6th, 2003 11:28 PM by Bill	0	390

Page 49 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 09:41 PM.