Excel Worksheet Functions - Page 17

Thread / Thread Starter	Last Post	Replies	Views
highlighting results bkunes	by bkunes	13	853
how do i sort data record on two rows? anyole	by Pete_UK	13	855
Translate Formulas as Values FF	by Rick Rothstein \(MVP - VB\)[_786_]	13	863
Dividing by zero jvega	by Dave	13	1,386
Static Count blank Luke	by T. Valko	13	942
Capitalizing Text Carin	by Gord Dibben	13	833
using sumifs to sum based on month, and criteria Jonas	by Bob Phillips	13	2,708
LookUp to Display Last Value Populated a in Range sony654	by sony654	13	1,130
Date Range Conditional Formatting Lynn	by T. Valko	13	1,251
Count the number of appearance within a cell Lucy	by T. Valko	13	1,705
Filter by Date of Birth Naomi[_2_]	by Naomi[_2_]	13	1,131
Nested if function Steve M	by Fred Smith[_4_]	13	768
how to do number additions in a spread sheet faster mobilenetmomma	by mobilenetmomma	13	1,326
Calculating quarterly investment returns---XIRR or another function?? Carl LaFong	by joeu2004	13	2,484
Sumif extrapolated Starvoyager	by Max	13	764
Indirect references to an offline book ismae	by Robert_L_Ross	13	1,350
Would I use "Lookup" to pick names for a Christmas grab bag Doebaby	by Myrna Larson	13	2,669
Pls help me to solve this problem... Bradley	by Bradley	13	972
Conditional Formula w/Date=Where did I go wrong? Cbreze	by Peo Sjoblom	13	956
IF Statement Ardy	by Eduardo	13	827
Mick & Clause & Experts Please help me on this issue one more time Please work this time...	by Please work this time...	13	1,463
Learning arrays. David Farber	by David Farber	13	1,808
INDEX MATCH SMALL [email protected]	by [email protected]	13	1,759
Time In-Time Out/No. of Units Karen	by David Biddulph[_2_]	13	999
ENTERING TIME Cletus	by Roger Govier[_3_]	13	1,034
Min excluding zero values, without an array fomrula art	by T. Valko	13	4,759
Sub or function not defined wmdmurphy	by wmdmurphy	13	1,237
Find amount in row. art	by T. Valko	13	896
Count if unique Gareth.Evans	by Jarek Kujawa[_2_]	13	931
SUMPRODUCT AND TEXT INM FORMULA BEEM	by BEEM	13	985
Inventory Months Supply Question JLewis	by Glenn	13	733
Sum a column that contains if statement that reference cells with abusymomforever	by T. Valko	13	1,040
Sum Function w/ #DIV/0! Biff	by Ashish Mathur[_2_]	13	1,006
Hi, Harlan Grove, ? about negative time formula Dale G[_2_]	by Ron Rosenfeld	13	1,189
place an "x" in D2 if E2-I2 are empty of text?? Denise	by T. Valko	13	1,000
Summing a column based on the length of text in a cell in anothercolumn [email protected]	by David Biddulph[_2_]	13	851
Excel - Geomean - Ignoring Empty Cells NC2A'DAM	by David Biddulph[_2_]	13	2,393
iferror Roy Gudgeon[_2_]	by T. Valko	13	967
Letter and numeral separation º¼ÖÝÈË	by Sandy Mann	13	1,230
Returning a cell reference with a formula? Hurton	by Hurton	13	1,151
Min/Max help needed with a SumProduct JR	by Domenic	13	1,564
Want Vlookup to list multiple items with the same key? GarToms	by Dark_Templar	13	3,797
How do I format list of names formatted last,first to first last? RenieFo	by SteveG	13	1,891
excel.worksheetfunctions Max	by Max	13	930
NORMAL DISTRIBUTION FLKULCHAR	by FLKULCHAR	13	1,609
If function using Index dbl	by Biff	13	1,172
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com	by Sam via OfficeKB.com	13	2,642
IF, Match, Index ? which One do I use Barbara	by Roger Govier	13	1,183
Unique Values Only Cecil	by Peo Sjoblom	13	813
Conditional Format based on contents of cell. dave m	by Bob Phillips	13	2,114
Dates and times again Martin B	by Ron Rosenfeld	13	1,144
Nesting more than nine IF statements in Excel Alexander Walsh via OfficeKB.com	by Arvi Laanemets	13	1,435
Help with SUMIF, INDEX, LOOKUP Please !! Robert	by Domenic	13	1,867
Using Conditional Format Joe Gieder	by Joe Gieder	13	1,336
Rounding up the result cubus	by Ron Rosenfeld	13	1,107
Relative worksheet reference in 3-D formulas? [email protected]	by [email protected]	13	1,988
External References not working right. Dread_Pirate_Roberts	by Dread_Pirate_Roberts	13	1,985
Max Value of a cell cwilliams	by Toppers	13	772
LOOKUP, MATCH, INDEX? bob	by Ragdyer	13	1,466
Grey out cell Angela1979	by Max	13	1,793
removing value within a string Jane	by T. Valko	13	701
I WANT TO COUNT HOW MANY TIMES A CERTAIN LETTER APPEARS IN A ROW spring022377	by philmail	13	2,695
"Magic" Formula Big Dog	by PCLIVE	13	780
check for duplicate numbers Ash	by Roger Govier	13	1,183
calculate age from 2 dates in yy,mm,dd format in excel Jan	by Epinn	13	1,670
Conditional formatting based on text within a formula Sarah Jane	by PapaDos	13	1,922
Identify if Cell is Formula or written number Claes G	by Mike C	13	3,676
LOOKUP problem Kaylean	by terryc[_2_]	13	1,054
Can INDIRECT function reference a cell that contains a formula Steve E	by Biff	13	1,577
How to average a column of numbers that are greater than 0? JimNColorado	by StephenAccountant	13	2,065
A formula that is too complex for Excel? trex005	by Bob Phillips	13	1,169
How to best monitor threads on this site John James	by Dave Peterson	13	1,062
Hide used names in drop downbox. Robb27	by Robb27	13	1,141
formula Kim	by KL	13	663
Validation - clear blanks from drop down Hayley	by T. Valko	13	1,255