Worksheet Functions - Page 1055

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
COUNT.IF, how to include single cells by Anders I have 400 rows of data. One column has the text "Y" or "N". I want to calculate the number of "Y" with COUNT.IF. However I don't want to include alla rows in...	October 29th, 2005 11:04 PM by Anders	8	95
Chart Help Needed by Jim Hello, While creating a chart the Value Y Axis has a range of 0 through 350 (I do not have these numbers on my spreadsheet). I would like to edit the...	October 29th, 2005 11:16 PM by Don Guillett	1	54
Formulas and/or formating by stevenap I have a simple spreadsheet that shows ten teams in rows with point totals. How do I set this up so that the team with the highest total points is always on...	October 29th, 2005 11:18 PM by stevenap	4	92
Help with PV calculations by PJF I have an application that makes a single payment 2 years after the signing of a contract. I need to calculate the PV of that payment asof the date...	October 30th, 2005 01:04 AM by PJF	2	66
PV of uneven stream of cash flows by PJF I apologize for reposting this question but I may not have originally stated the problem adequately. I have an application that makes a single payment 2 years...	October 30th, 2005 01:16 AM by Bruno Campanini	8	113
Multiple IF functions by questionsforms I'm trying to create an IF function to calculate some payroll taxes. Here's the formula that I came up...	October 30th, 2005 03:12 AM by paul	2	81
Need No Blanks List based on two conditions by Chaturanga Hello, I'm looking for a worksheet formula that will produce a list of no blank values in a third column. First column contains the text values (30 rows) and...	October 30th, 2005 03:12 AM by Stefano Condotta	9	124
how to calulate time in hours cbetween two different dates? by shonkoo I use Excel 2003. I cannot find out time in hours between two different dates, for example - time in hours between 2300 hrs/ 23.10.05 and 0800 hrs/26.10.05....	October 30th, 2005 03:30 AM by Mladen_Dj	3	199
Count multiple data by date by Racorfrank I have data that increases on a daily basis and is input on the shop floor from a drop-down list. Some of the data that is collected includes day, the type of...	October 30th, 2005 04:11 AM by Biff	3	87
Display row number of the last value in a column by ramana Hi everybody, I have a conditional formula in column A(A1:A1000) if the condition is satisfied then the cell returns a value, if the condition is not...	October 30th, 2005 04:18 AM by Biff	4	83
Need know what are valid SUMPRODUCTS arguments and functions by sparham After running a query on a dbase, I'm trying to determine the number of items it returned for given items. My formula is as follows: =SUMPRODUCT(--('Refresh...	October 30th, 2005 09:32 AM by Aladin Akyurek	2	73
3D Count in all worksheets by [email protected] I have 12 worksheets starting from Jan. to Dec.. There are staff names in the A column in each worksheet and most of them are in the same row on each...	October 30th, 2005 09:47 AM by [email protected]	2	70
how would you do A40-20 = aA20, the value 20 is in another cell by John ferguson I have 4 columns of data, X co-ordinates, y co-ordinates, frame number, and track number. The number of co-ordinates varies per track. I want to take the first...	October 30th, 2005 10:30 AM by Niek Otten	1	78
sorting master sheet messes up cells in other sheets linked to it by Kt Sheet 1 complete list of names all pupils and fees per month Sheet 2/sheet per instructor - list of pupils per instructor with names and fees linked from sheet...	October 30th, 2005 10:36 AM by Kt	0	154
list generating by Melissa hi I am in need of help: I have a list of times and names that change with every new schedule....ex: my list is generated on a daily basis and there...	October 30th, 2005 11:25 AM by Max	1	81
Sharing and Solver by David French I have just discovered there is an issue if a Worksheet/Workbook is shared and you want to utilize Solver. It appears it can't be done. Is there some way...	October 30th, 2005 12:02 PM by Tushar Mehta	1	109
how do I prevent a RAND number from changing by DAVIDT Using RAND or RANDBETWEEN to randomly select a number from a specific range allows a new random number to be calculated when any other cell is filled and...	October 30th, 2005 12:21 PM by Max	1	231
link between sheets get messed when master sheet is sorted by Kt Sheet 1 complete list of names all pupils and fees per month Sheet 2/sheet per instructor - list of pupils per instructor with names and fees linked from sheet...	October 30th, 2005 12:24 PM by Max	1	96
sorting master sheet messes up cells in other sheets linked to it by Kt Sheet 1 complete list of names all pupils and fees per month Sheet 2/sheet per instructor - list of pupils per instructor with names and fees linked from sheet...	October 30th, 2005 12:25 PM by Max	1	143
Moving cells by Larry How do I? If I have a row of cells and I click on the left cell it will automaticly move all the exsisting values in the adjoining cells to the right one cell....	October 30th, 2005 04:17 PM by Don Guillett	1	65

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