Worksheet Functions - Page 646

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
how do I fix formatting mistakes: cells and contents are wavy by superteacher Microsoft Officehome and Student 2007 brand new: had word excell powerpoint and one note. 3/24/09 I don't understand how to tell you: One day on my excell...	March 25th, 2009 03:10 AM by superteacher	0	80
Need blank cells to remain empty by Bebe I created a basic formula to calculate the number of days between two dates in a worksheet, i.e. =K2-A2. The formula worked fine in the 1st cell, accurately...	March 25th, 2009 02:23 AM by Bebe	7	90
Excel by Maurice How do I create different menu lists that are changed by the users input. These lists will calculate the price of an item based on the input. -- Maurice	March 25th, 2009 02:02 AM by Maurice	0	52
Finding a name with partial description and deleting all occurrenc by pm Hello all, I'm using an excel sheet for a fantasy baseball draft. I have 3 lists where players are listed on the same sheet. Each list is a different...	March 25th, 2009 01:30 AM by Alan	1	53
Pivot Table Percentage of Sub-Total by Michelle I have searched through all the posts and can't find the answer I am looking for. I have a pivot table where I am trying to get the percentage of the...	March 25th, 2009 01:23 AM by Herbert Seidenberg	7	85
Rental Lease Agreements by Monthly and yearly I would like to download a rental lease agreement	March 25th, 2009 01:08 AM by Monthly and yearly	0	54
Count the numbers of a particular day by Francis Hi What would be formula for calculating the number of Thursdays, excluding Christmas and New Year days when they fall on Thursday, in a fiscal year... ( 1 2)	March 25th, 2009 12:48 AM by ron	15	119
LOOKUP function syntax across a table? by Marc I am trying to structure a LOOKUP formula which looks across a table of values, and if it finds a particular value, it reports the ROW NAME's value. For...	March 25th, 2009 12:19 AM by Ashish Mathur[_2_]	6	164
Search cell for any of 6 criteria by Pierre Have cells containing numerous text strings. If the cell contains within its contents (which also has other characters:) .12 or .19 or TRS or PKI or .099 or...	March 25th, 2009 12:07 AM by Domenic[_2_]	3	81
SUMIF NOT #VALUE Question by Dax Arroway I'm trying to SUM a range Q3:Q33, but this range has values in it that get calculated from other places that will be calculated through time. In the last...	March 24th, 2009 11:58 PM by Domenic[_2_]	3	61
How to create a function to alternate names in a cell from a list? by Elias Im creating a schedule and want to have a button that alternates names from a list for the selected cell.	March 24th, 2009 10:26 PM by Gary''s Student	1	54
Need to set up bckgrnd color to link to different worksheets. by Yllwroze I have multiple sheets filtering in to a summary sheet. How can I make sure the background colors of the cells change in the summary sheet when changed in...	March 24th, 2009 10:23 PM by Gord Dibben	1	70
Excel page break titles by Andrea Is it possible to create a different repeating title for each page break?	March 24th, 2009 10:12 PM by Gord Dibben	1	58
Moving data from one spreadsheet to another by Bishop I have 2 spreadsheets: SheetA and SheetB. SheetA is a list of names. SheetB is a list of names with specific data about each name. So SheetB Column A has...	March 24th, 2009 10:04 PM by Gord Dibben	4	60
Auto populate by Oscar Hi, I'm working on a calculator for mortgage payments. On my calculator I created a column with interest rate 1.000% - 11.000% and next to it I have a...	March 24th, 2009 09:48 PM by Oscar	9	139
calculate years of service by JenniferD Does anyone know how to calculate years of service in Excel? (ex. 3 years, 4 months)	March 24th, 2009 08:33 PM by John	2	92
Seqential numbering by MrRJ Hello, I need assistance. Looking for a formula that would number the rows sequentially given a criteria of zero. Example Column A has a series of values...	March 24th, 2009 08:17 PM by MrRJ	2	50
Conditional Format Based on Date by Ron A. How can I change the fill color of a cell based on a date. I would like the cell to be green if the date in a cell is equal to or greater than 90 days from...	March 24th, 2009 08:09 PM by RagDyer	3	52
How do you Break it down by age group by Age Breakdown I am trying to do a format by age group	March 24th, 2009 07:46 PM by Pecoflyer[_254_]	1	106
how can I calculate number of days based on start and end dates? by stumped-in-excel[_2_]	March 24th, 2009 07:02 PM by Glenn[_6_]	2	57

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