Worksheet Functions - Page 447

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 calculate exact # of months between two dates? by Mark Livingstone Hi, Right now I am using the DATEDIF(CELL1, CELL2, "m") function. However, it provides only single digit response. So, if the two dates are 20 JUNE and 20...	July 22nd, 2009 01:23 AM by Ashish Mathur[_2_]	9	225
Conditional format stoplight based on worst color by Morgimo Can you conditionally format based on a color? I want each row's stoplight color (green, yellow, red) to change based on the worst color in that row. All the...	July 21st, 2009 11:28 PM by Gord Dibben	3	94
Displays wrong result by FirstVette52 For the following formula: =MAX(VALUE(RIGHT($A$1:$A$22,8))) ....for a list of numbers L00000001, L00000002, L00000003, L00000004, L00000005 ... ...	July 21st, 2009 11:18 PM by Teethless mama	2	108
Lookup Formula by BAD I have worksheet #1 that has Name and Email Address. I have worksheet #2 that has Name and Employee ID number. I want to add a cell next to Employee ID...	July 21st, 2009 11:07 PM by Teethless mama	2	114
Date field from text field by Jack Deuce I have 2 sheets containing two dates that I need to compare. One date is in the serial date format, ie, shows as 07/21/04 (internal 39650). The other date...	July 21st, 2009 10:33 PM by Gord Dibben	3	143
automatically update a field only when data has changed by bigdog2112 I have a worksheet that users will sometimes update data in, other times not. I have a field that uses the =TODAY() function that I'd like to have updated...	July 21st, 2009 10:07 PM by Niek Otten	1	92
Include email dist. list into a Excel macro - how? by Excel problem/challenge I am trying to include an OutLook distribution list in an Excel macro. How do I do that?	July 21st, 2009 09:30 PM by Ron de Bruin	1	119
Max with Multiple Ifs by ChrisWWiese Hello All, I need a Max statement with multiple ifs. Take for instance the example below, I need only the Max IF A=1 and C = 1. I've tried formulas like...	July 21st, 2009 09:05 PM by ChrisWWiese	3	90
Array Function? by Johnnie[_2_] A B C 1 Company 1 10 Company 1 2 Company 2 10 3 Company 3 10 4 Company 2 8 5 ...	July 21st, 2009 08:38 PM by Johnnie[_2_]	4	99
why does the dateif function result in an error in Excel 2003? by Cheryl	July 21st, 2009 08:30 PM by Mike H	5	130
Alarm function, disable sound if data is erased by offdah3z Hello all, I'm trying to use an alarm function of Excel. Basically, if A9 is equal to a certain value, for example 213, I would like a sound to be played. ...	July 21st, 2009 08:13 PM by Bernard Liengme[_2_]	1	109
Remove Password by Zita I want to remove a password from a workbook so it opens without one. It is unshared file.	July 21st, 2009 07:33 PM by Gord Dibben	3	73
Drop Down Lists: Allow option of adding own data if not in drop do by ruperthouse I would like to create a drop down list for user to select from but also allow them the choice of typing in their own data if the item they want is not in...	July 21st, 2009 07:29 PM by Gord Dibben	8	105
How the data may stay on top with scroll ? by Vladimir Nikolov So I want when i scroll my worksheet, the data that i am insert into the first row, still be on the top of the worksheet. I am sorry for my bad english and i...	July 21st, 2009 07:16 PM by Eduardo	1	105
Formating a cell by Smiley Hi! I am working on a spreadsheet where I have 5 columns of time. I need to reformat all 5 columns to be the same. My time reads for example, 11:55 -...	July 21st, 2009 07:00 PM by Rick Rothstein[_2_]	5	80
permanent conversion of 1904 date format to 1900 date format by Jos I have an old spreadsheet in Windows that has the 1904 date format as basis. All my other spreadsheets are in the 1900 date format. Are there any utilities...	July 21st, 2009 06:32 PM by Harlan Grove[_2_]	3	106
Custom Format or use function? by Lisa W[_2_] I inserted numbers into a column and now want to format this column so that it changes the numbers to appear as: 196-24-0-00-00-001-00-0-01 (ie, the - appear...	July 21st, 2009 06:06 PM by Rick Rothstein[_2_]	4	105
Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo by mikevanv I am new to Office 2007, and am using the updated Conditional Formatting for the first time. I like what I'm seeing, but I don't see the default...	July 21st, 2009 05:44 PM by mikevanv	0	71
Cross Reference by fgwiii Hello, I have a need to associate several lists of 5 digit numbers with to a user on another spreadsheet. For instance I use a hidden workbook to store all...	July 21st, 2009 05:06 PM by Eduardo	1	81
Count Columns, Return Content by Leah G I need a function to return the contents of a cell based on a number given in column F. Here it is: A B C D E F * $ @ % # 3 (I would...	July 21st, 2009 05:02 PM by Mike H	6	130

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