Excel Worksheet Functions - Page 40

Thread / Thread Starter	Last Post	Replies	Views
Is there a formula to convert numbers to written text in Excel? LZC	by David McRitchie	3	2,865
Convert data type of cells to Text,Number,Date and Time Kevin	by Frank Kabel	1	2,865
Stock Reconciliation rajeev	by rajeev	1	2,864
I cant see my excel spreadsheet but only in Print Preview? Karyn H	by Dave Peterson	1	2,864
how to remove #DIV/0! kuansheng	by kuansheng	7	2,863
Calculate Loan Term Joe User[_2_]	by Joe User[_2_]	0	2,863
Electricity Bill Sheet XKruodo	by XKruodo	6	2,863
Convolution Neal Carron	by Dana DeLouis[_3_]	6	2,861
Calculate End Date (excluding weekends and holidays) guitaronmyback	by Rick Rothstein	6	2,861
make cell contents equal to null value - not blank, but empty mpierre	by Peo Sjoblom	1	2,860
Box-Jenkins techniques & Time Series karim	by [email protected]	3	2,856
Rang reference incrementing by more than one on formula drag Kai Cunningham[_2_]	by T. Valko	2	2,855
Using SUMIF with a drop down. Steve	by Steve	3	2,855
Formula to Pick Out Characters within a Text String Peanut	by T. Valko	7	2,854
Using If then to change cell colors in Excel 2007 Randy	by David Biddulph[_2_]	5	2,854
Cell color changes when date gets closer Ralph	by RagDyeR	2	2,854
Calculating days & time left from start date/time to end date/time marie	by Sloth	7	2,854
7+ Nested if Statement using indirect function klysell	by Harlan Grove[_2_]	6	2,853
#num error using IRR Frank Situmorang[_2_]	by Frank Situmorang[_2_]	4	2,852
How do I calculate total pay from [h]:mm times pay rate per hour? Rufus	by Rufus	2	2,852
countif a date is greater than today Keith	by Keith	3	2,851
Replacing special characters in Excel 2007 Jeff	by Sean Timmons	3	2,851
Excel false positives for circular refs and not updating calculations Kerry[_2_]	by Kerry[_2_]	2	2,850
Comparing two columns and return a third casedk	by Pete_UK	3	2,850
Excluding Hidden Rows from calculations Terry Bennett	by Peo Sjoblom	3	2,849
How to number lines (rows) on both sides of spreadsheet crb.e4xplor	by JLatham	6	2,849
SUMPRODUCT multiple criteria (with a twist) GD	by Ranjith Rajaratnam	13	2,844
putting images into a dropdown list Melanie	by Max	3	2,844
Inverse prediction in regression Ernie Lippert	by Jerry W. Lewis	1	2,843
Forecast of Inventory - Explaination of Calcuations tippytoe	by tippytoe	3	2,842
Rank where lowest value is highest rank mile3024	by Alan	2	2,841
How do I append 20 worksheets in single sheet. Rahul	by ryguy7272	2	2,840
Formula needed Connie Martin	by Connie Martin	22	2,840
Finding MIN value in a column between Two Dates in different columns ML Srini	by T. Valko	3	2,840
why are my columns not adding correctly Cathie	by Fred Smith	4	2,840
I can't reference a cell as the criteria in the AVERAGEIFS functio Evan	by T. Valko	2	2,839
Excel will not add cells automatically together when selected? Dom23	by Bob Phillips	2	2,838
char(10) and double quotes JohnE	by Dave Peterson	2	2,837
Assign Macro to a Cell Bob Myers	by ryguy7272	2	2,836
Select rows which satisfy 2 criteria Colin Hayes	by Colin Hayes	16	2,836
vlookup data hidden within worksheet	by	0	2,835
sample vs. population proportion using a z-score in excel Christopher[_3_]	by Christopher[_3_]	4	2,835
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY South texas man	by South texas man	4	2,835
if cell blank color "red" Steved	by Steved	5	2,834
Can I hide my running totals when there is no change? cprince	by Debra Dalgleish	2	2,834
Using INDIRECT & R1C1 Ref style Bassman62	by T. Valko	5	2,834
Count partial dates ringoranger	by Ron Rosenfeld[_2_]	1	2,833
Format cells to change a number from a positive to negative jagfan123456	by lk	4	2,832
CELL EQUALS LAST NONBLANK CELL IN A COLUMN Vicky	by T. Valko	5	2,831
Weekly Transaction Processing Ralph Howarth	by Ralph Howarth	4	2,830
Freezing multiple rows/columns in Excel 2007 Pro gary	by Roger Govier	3	2,829
How to keep the drop down arrow on data lists when not selected? Diamondgirl	by T. Valko	3	2,828
Is it possible to search tabs in excel? Ste1978	by Don Guillett	2	2,828
Inserting comma(,) after every two digits of a number from right t Senapati	by Jacob Skaria	2	2,828
Excel 2007 Pivot Table - Group Field function is not always availa JLW1	by JLW1	1	2,827
counting the occurrence of specific text within a date range John	by Dave Peterson	4	2,826
how do I insert picture into cell so vlookup can return picture? ah	by JE McGimpsey	1	2,825
Cascading drop down boxes in Excel Bryn	by Gary''s Student	1	2,824
Force entry in one cell based on value of another cell Kebbon	by [email protected]	3	2,822
Find/Replace carriage return & line feed characters in Excel. Mary Cullen	by Peo Sjoblom	1	2,821
Comment with date stamp Keyrookie	by Keyrookie	10	2,820
How do you alphabetize street addresses within a column? Rosemarie	by David Biddulph[_2_]	4	2,818
automatic color change in cells using a drop down list kennethwt	by Gord Dibben	1	2,818
how can i estimate garch parameters(gamma,alpha and beta)in excel garch estimatio	by garch estimatio	0	2,817
how to change a formula for a large group of cells Jen	by Ron Moore	1	2,817
keep formula delete contents carspjcars	by Gord Dibben	4	2,816
Pull out numbers only in cell Clay	by David McRitchie	3	2,815
assigning a unique value Dino	by Harlan Grove	27	2,815
On a excel protected worksheet, how do I change the tab order? vikgarden	by Paul B	3	2,814
Dynamic col_index_num in VLOOKUP? tb	by San[_4_]	5	2,813
concatenate and multiply problem tipoo	by tipoo	7	2,812
Diagonal and upwards transposing morlo	by Max	3	2,812
Median with Quantity Column SDShannonS	by JoeU2004	3	2,812
Date not displaying correctly Clark	by Dave Peterson	6	2,812
How do I create a List in Excel 2000 Watch Online	by Gord Dibben	1	2,811