Worksheet Functions - Page 700

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 to calculate the difference between two different times. by Highbury 1[_2_] How to tell the time? I have an Excel 2007 workbook that I require to be able to â€˜countdownâ€™ the time remaining until the scheduled start time of a...	February 24th, 2009 06:27 PM by Luke M	1	60
How do I delete multiple of wooksheets by jd How do I delete multiple of wooksheets	February 24th, 2009 06:17 PM by Susan	1	76
Sum a column that contains if statement that reference cells with by abusymomforever I have tried every fx, combination of functions, formulas, etc and nothing seems to work. Here is what I have and please someone tell me how to get a... ( 1 2)	February 24th, 2009 06:17 PM by T. Valko	13	224
column width by nurse amy what is the equivalent of 1 inch in column width	February 24th, 2009 06:10 PM by mdmackillop[_20_]	1	82
if function or lookup??? across a range of cells in a row. by jwbuyer I have data in a row, that I need to find out when any of the cells in that row equal either 0, or #N/A. I am having trouble experimenting with both the if...	February 24th, 2009 05:41 PM by Shane Devenshire[_3_]	2	65
I have lost the ability to auto Sum... by Shane Devenshire[_3_] If you don't put a question in the body of the email, the web interface will not allow us to replay in the same thread, we get the following message: "An...	February 24th, 2009 05:22 PM by Shane Devenshire[_3_]	0	82
Function With Lookup by Dias Hi I have a Workbook with a code that insert automatically a ws and fill the name of that ws in a Master sheet in Column B with a link for that ws. Wat I´m...	February 24th, 2009 05:20 PM by Dias	8	104
Changing entire row based on 1 MAX cell value (Conditional Formatt by SunshineinFt.Myers[_2_] I have a spreadsheet that has several row with number value going across; I only want to find the max in one column going down and if its the max number I...	February 24th, 2009 05:18 PM by Shane Devenshire[_3_]	2	86
find a value in a table based on 2 different criteria by Picman I need to look up a value in a table based on 2 different criteria. The first is the item code, and the second is the month. The "B", "C" and "D" column... ( 1 2)	February 24th, 2009 04:38 PM by ~L	17	132
Change Alignment Defaults by Victoria Hello, Can anyone tell me if there is a way to change the alignment and text wrap defaults within Excel? Thank you, Victoria	February 24th, 2009 04:09 PM by Victoria	4	92
Excel 2007 - VLOOKUP always returns #N/A by Patrick I have just migrated to Excel 2007. The function VLOOKUP always returns #N/A when it was not the case with Excel 2003. Are there any settings I have to change...	February 24th, 2009 04:01 PM by Niek Otten	4	99
Advanced Filter for Text String by Daren Hello, I have text values in 2 columns of cells that contain the word Saturday in any length of values...e.g, The First Saturday, That Saturday was Nice. I...	February 24th, 2009 03:44 PM by Shane Devenshire[_3_]	6	80
Count cells with a date in them by Caroline Hello, I would like to count cells in a column that have dates in them -any date, I do not want to count cells with text or anything that's not a date. I'm...	February 24th, 2009 03:35 PM by Shane Devenshire[_3_]	3	66
Adding only part of a column by kajones I have a spreadsheet that I use to track weekly performance. I have a cell established for the given work week. I enter all of my weekly data on Monday...	February 24th, 2009 03:28 PM by kajones	2	56
Help With Cell Function by clralph I have a form that is filled out by our salesmen. I cannot remember what to use when they type in one cell for it to show up in another cell. The CELL and...	February 24th, 2009 03:22 PM by Shane Devenshire[_3_]	3	45
Change operator from cell value by Gareth.Evans Hi, i am trying to change to operator of a formula based on the value of a cell. For example: A1 = 3 A2 = A3 = 10 Formula: IF(A1&A2&A3,"yes","no") The i...	February 24th, 2009 02:30 PM by Glenn[_6_]	5	84
consecutive numbering by rafonss I would like to start numbering 1 - 500 in a column and 1 - 30 in a row. Is there some way to do this with a function?	February 24th, 2009 02:16 PM by Glenn[_6_]	5	73
Time functions by srpavar I have a time in A1 as 07:30AM as start time, B1 as 15:30PM as end time and in C1 column I enter the actual time like 13:00PM, that means he goes early by...	February 24th, 2009 09:31 AM by David Biddulph	4	86
Time function by srpavar I have a time in A1 as 07:30 AM as start time, B1 as 15:30 PM as end time and in C1 column I enter the actual time like 13:00 PM, that means he goes early by...	February 24th, 2009 09:30 AM by David Biddulph	1	64
Macros by Lois Hi. I have 2 questions: 1. how does one know the Visual Basic codes to create a macro? 2. I have a workbook with a macro that is set to protect all the sheets...	February 24th, 2009 08:20 AM by Simon Lloyd[_116_]	2	66

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