Worksheet Functions - Page 111

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
Need to calcualte difference between 2 time fields by Paul D Need to calcualte difference between 2 time fields, and round up to the next minute with a numberic result. i.e. A1 = Start Time (Format Time) = 8:34:32 B1 =...	May 26th, 2004 05:44 PM by Frank Kabel	3	429
Automatically Insert DATE, so that DATE will NOT change by Cie I'm using the following formula =IF(L8"",TEXT(TODAY(),"mm/dd/yy"),"") My problem is, everytime I go back to this spreadsheet, the date will change to the...	April 4th, 2005 05:51 PM by Bernie Deitrick	4	429
Unable to Copy COUNTA() with cell references by EugenioB In sheet A I have a number of columns, only partially full of cell entries. The cells without entries are simply blank. Lower down in sheet A, below the...	February 16th, 2005 01:07 PM by Bernie Deitrick	1	429
Cash verification by Arthur I have created a batch summary verification sheet for balancing payments received in a payment center. I have one cell for cash totals (cash on hand) and one...	September 22nd, 2004 01:57 PM by JulieD	5	429
Match & Index Combined Row & Multiple extractions by Ronald Cayne I am looking up a text string in a1 and seeing if I have a match in a row For example row B EXAMPLE If I have a match in B2-Z25 I use the index command to...	June 25th, 2004 03:33 AM by Ronald Cayne	7	429
how many worksheets it has in MS Excel? by canadian how many worksheets it has in MS Excel?	November 16th, 2008 12:47 PM by MartinW[_3_]	2	428
how to use the fill function (serial no)while we are in filtered field by sreenoo dhanpal we are unable to give or fill the column with serial numbers by using the fill option while we are in filter mode means selected one of the filter option of...	May 28th, 2004 06:52 PM by Bernie Deitrick	1	428
Need a way to do random drawing with weighted chances by PMD Hi All: I am trying to do a monthly drawing that will be generated from a report. In column "A" is the person's name and in column "B" is a number that will...	August 12th, 2004 04:09 PM by HJ	5	428
Function syntax to compare cell contents by ES I am trying to create a macro to compare the contents of cells in two columns. I tried using the 'EXACT' syntax, but it doesn't seem to work for the...	May 18th, 2005 03:53 PM by Don Guillett	2	428
Difference between regression in VBA and a worksheet function by Nick M Hello All, I had a semi-embarracing expierence today: the small bit of VBA I wrote to run a regression on two columns of data was returning different values...	April 6th, 2004 06:08 PM by Michael R Middleton	1	428
Data Validation with letters and numbers by Jason I need to ender data validation for cells B4:D189 to restrict only strings starting with "(C". Of course the strings I enter could be different lengths, so I...	February 26th, 2004 10:26 PM by Frank Kabel	1	428
Entering numbers by Jorr I'm entering long numbers on an Excel 2000 spreadsheet in a cell set for number format. When I enter a long number, such as a credit card number (16 digits)...	September 16th, 2003 05:25 PM by FBC	1	428
"Intelligent" copy to cells below by cindee I want to copy a cell to the blank cell below it and continue to copy until another value is found, then I want to copy that new value into all the blank...	October 2nd, 2003 12:31 AM by J.E. McGimpsey	1	428
VLOOKUP Question by Jeff Armstrong I have a VLOOKUP function that retrieves information from a list. There will be times that the information trying to be retrieved won't be in the list. This...	March 10th, 2004 11:40 AM by Andy B	4	428
Extracting a word from text in an excel field by Peo Sjoblom If it is always delimited by a space =RIGHT(A1,LEN(A1)-SEARCH("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))) Beware if you have names...	December 11th, 2003 05:22 PM by Amit Shanker	1	428
Frontline Systems Solver by T Crosby I'm reading a magazine which refers to an Excel add in tool called "Frontline Systems Solver". Is this "Solver" different than the standard Solver/backsolver...	January 14th, 2004 02:47 PM by T Crosby	3	428
Limit to number of nested "IF" functions by Michael P. I've noticed that if I have too many IF's in one function, Excel 2000 refuses to calculate. Example: IN CELL N2 ......	January 16th, 2004 12:36 AM by Norman Harker	3	428
Normal Distribution by Have you tried using the statistical analysis tools? Perform an analysis of variance (anova) Correlation analysis tool Covariance analysis tool Descriptive...	April 1st, 2004 01:34 PM by Jerry W. Lewis	4	428
emailing protected Excel worksheets by R Maule when attaching a password protected Excel worksheet to an email, the password protection is not transferring. have attempted using Microsoft Outlook with the...	September 17th, 2003 07:59 PM by Ron de Bruin	1	427
Examples needed by JM Anyone know a site (library) in MS with examples?	September 15th, 2003 06:51 PM by [email protected]	1	427

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