Excel Worksheet Functions - Page 101

Thread / Thread Starter	Last Post	Replies	Views
Comparing Text beginner here	by Sandy Mann	7	415
Addition help to edit a formula Hell-fire[_3_]	by JLatham	7	449
Help with editing a formula Hell-fire[_3_]	by Hell-fire[_3_]	7	500
Consolidating with empty-string ("") cells removed Thomas Toth	by Dave Peterson	7	807
qn on counting in drop down menus and protecting/hiding specific worksheets qiong	by JMB	7	332
sumproduct formula Todd	by Toppers	7	481
One more try!! klafert	by klafert	7	448
data validation with a formula LabrGuy Bob R	by LabrGuy Bob R	7	504
Advanced Sumif formula Eva	by JMB	7	764
How do I insert cells in a macro? ruby02monday	by JMB	7	425
calculating sample sizes for independent groups Ariel	by Stan Brown	7	450
Formatting Dates MEAD5432	by Rick Rothstein \(MVP - VB\)	7	690
How to ignore #DIV/0! in Sumproduct formula deeds	by Harlan Grove	7	5,685
How to find the first non-blank number in a row? RLind	by Teethless mama	7	1,454
Counting instances of text??? tpmax	by Ragdyer	7	591
Count on Multiple Criteria over whole column George	by George	7	511
formula help - maybe vlookup, not sure Ann	by Max	7	384
How to make the First alphabets in the cell to be blank. Igneshwara reddy[_2_]	by driller	7	445
Formula to return blank Debsdad	by Teethless mama	7	364
Too many nested IF functions! Skyscan	by Harlan Grove[_2_]	7	815
CHAR funtcion with double letter columns ellebelle	by MartinW	7	3,903
Using a dynamic pathname in VLOOKUP Mike D[_2_]	by T. Valko	7	1,369
row lookup formula adam	by adam	7	467
formula for Canadian postal codes LB	by Gord Dibben	7	1,191
simple, counting the last character in text JVANWORTH	by T. Valko	7	430
named range with criteria. driller	by driller	7	446
Conditional Format Formula Issue SteveMax	by T. Valko	7	499
Macro do works in excel... driller	by driller	7	626
Extending Logic beyond the numbers and into a Name! Is it Possible Dan the Man[_2_]	by Toppers	7	400
How do I insert cells in a macro? ruby02monday	by ruby02monday	7	433
Need help with =IF formula Harvey[_2_]	by Harvey[_2_]	7	451
#N/A value is returned Sai	by Dave Thomas	7	641
finding and summing data in somewhat complex matrix. Willem	by Willem	7	683
conditional formating nk	by Bob Phillips	7	560
Help to rename files Hilton	by Max	7	503
Sumproduct with OR andy62	by andy62	7	655
IF function not working in conditional formatting DruD	by David Biddulph[_2_]	7	957
Changing worksheet direction berber	by berber	7	608
Excel- option button Excel Master Wannabe	by T. Valko	7	820
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets Doctorjones_md	by Dave Peterson	7	1,213
Copying cells from one spreadsheet to another? Doug	by Gord Dibben	7	569
Calculating percentages based on the number of checked boxes in a column [email protected]	by [email protected]	7	683
Countif with 2 conditions DTTODGG	by Ron Coderre	7	670
Creating an IF / AND statement Pat[_2_]	by PCLIVE	7	407
How do I sum cells by refering to discrete values? Jive	by Jive	7	1,572
About sorting and extracting data in one column Ting Li	by Ting Li[_2_]	7	634
lookup value and date from a list with restrictions [email protected]	by T. Valko	7	496
function for repeated cells Haz	by Rick Rothstein \(MVP - VB\)	7	813
Updating Master Log records Sinner	by Sinner	7	628
Text import/ Text to Column anto	by Roger Govier	7	534
problem with vlookup ruchie	by ruchie	7	417
#div/0 errors and blank cells dinouk	by T. Valko	7	664
Comparing multiple column values MaryZZZ	by Toppers	7	586
Finding Annual Growth Rate Assad	by Thomas Hastings[_2_]	7	1,285
Worksheet protection with grouped rows? pmw5	by Gord Dibben	7	863
SUMIF Criterion with NOT Fred Holmes	by Don Guillett	7	413
Duplicate Item Numbers lehigh46	by Roger Govier	7	417
Function to find the first cell that is not zero Mark[_3_]	by Mark[_3_]	7	429
How do you display IF statement results in a different cell Neall	by Bernie Deitrick	7	1,771
Comparing Data in Excel 2003 Diamonds_Mine	by T. Valko	7	541
How do I insert a picture into a cell? Evan Lapka[_2_]	by Meebers	7	871
Counting up with numbers and text pwalters	by pwalters	7	1,753
Functions/Formulas to count multiple variables 2many#s	by 2many#s[_2_]	7	660
Using a series of named ranges in SUMPRODUCT JzP	by Toppers	7	626
Index and named ranges selecting difficulty Bruce Tharp	by ShaneDevenshire	7	591
@average function Chazbri	by ShaneDevenshire	7	505
Conditional formatting of a text box ? Steve	by Steve	7	1,040
USE IF CONDITION FOR 2DATA deen	by T. Valko	7	425
Invalid date if weekend or bank holiday grobertson	by bj	7	1,938
HELP fixing GPA formula's JohnG	by toppers	7	648
Help with function/formula please!!! Ssuzs	by David Biddulph[_2_]	7	574
=TODAY() Steved	by Teethless mama	7	443
IF(AND problem to work out commissions Amanda	by Amanda	7	434
How can I do this? Tmaxx02	by T. Valko	7	383
Dragging formulas Ben Greenwood	by clubin	7	790