Excel Worksheet Functions - Page 531

Thread / Thread Starter	Last Post	Replies	Views
SUMPRODUCT AND TEXT INM FORMULA BEEM	by BEEM	13	997
Convert average daily yield to APY Greg	by joeu2004	4	1,151
Excel VLookup Cinny	by Roger Govier	1	369
Functions/Formulas to count multiple variables 2many#s	by 2many#s[_2_]	7	688
IF Statement bob	by Rick Rothstein \(MVP - VB\)	4	410
How do I sort rows containing graphics? Faetan	by Gord Dibben	4	641
Sum A Range only if no text is present in the range AdmiralAJ	by AdmiralAJ	3	808
how do i make bootstrap pendidik	by pendidik	0	550
Need to summarzie a "status" flag MLK	by MLK	2	661
how do i sum of decimal digit in absolute terms dhir	by David Biddulph[_2_]	3	961
Find and Delete Karen[_2_]	by driller	2	528
COUNTIF with AND logic Mitchell_Collen via OfficeKB.com	by Rick Rothstein \(MVP - VB\)	8	965
how can i automate the copy-insertion of a specific number of rows driller	by driller	0	429
pop up calendar using MS DateTime Picker andy62	by andy62	4	1,133
If statement help needed ah	by Roger Govier	16	1,092
how do I look for duplicate house addresses in a column in Excel? Kevin S	by Jovan Timotijevic[_2_]	3	460
Merging 2 lists with a twist dee	by Roger Govier	4	540
"Begins with" Amber	by T. Valko	12	905
get a list of ticked add-in Dan	by Dan	2	589
Duplicate Work Order Numbers chickalina	by chickalina	2	621
spell check in excel 2007 Bonnie	by Bonnie	0	759
Turn off recalculate to send data into TM1 and vice versa. bhinbest	by bhinbest	0	829
Positive or negative sign in a calculated cell Michel Khennafi	by Michel Khennafi	5	1,085
vlookup format problem Patio	by Gary''s Student	1	588
getting numbers divisible by 4 from random numbers in ascending order ramana	by T. Valko	6	2,552
Relative reference for named tabs? Dave in Fair Oaks	by Gord Dibben	6	604
Excel / Access User Conference Damon Longworth	by Damon Longworth	0	493
trouble locking specific cells [email protected]	by Gord Dibben	2	520
SUMPRODUCT #VALUE! error Chris Slowe	by Chris Slowe	2	544
copy part of large WS to another sheet Aurise	by Gord Dibben	3	430
Trouble with Index & Match Arturo	by Peo Sjoblom	3	524
How to use the if statement for Macro coding? Eric	by Eric	3	1,315
TAN INVERSE ? Ahsan	by Mike H	3	1,876
How to open a new instance of EXCEL and .xls file Launchnet	by Launchnet via OfficeKB.com	10	1,392
Formulas in Excel Worksheet jeannie v	by Jovan Timotijevic[_2_]	6	376
Digit to Text Subhashis Bhowmick[_2_]	by Rick Rothstein \(MVP - VB\)	3	480
Conditional Formatting nabanco	by nabanco	2	374
Cell Wrap nabanco	by Pete_UK	4	375
find and replace Karen[_2_]	by Karen[_2_]	2	314
while loop Arun Kumar Saha	by JLatham	2	508
Help with formula please luvgreen	by luvgreen	2	339
Cell reference Issue Jerry Foley	by JLatham	2	416
Poll: Calc cost pro rata (nested IF's and macro to find empty row) herbwarri0r	by herbwarri0r	2	788
Pivot Table Quesiton Tina	by Tina	6	523
Auto Filter Range Subhashis Bhowmick[_2_]	by David Biddulph[_2_]	3	503
DCF Mark Costello	by Mark Costello[_2_]	3	475
=B1/A1 yhtak	by Max	4	433
reorder data ellebelle	by ellebelle	0	527
transfer date to number artisdepartis	by artisdepartis	4	934
getting numbers that are divisible by 4 ramana	by joeu2004	4	1,699
sum alternate rows anand	by Max	4	1,628
On File open - how to stop conversion of postcodes to numbers DragonRider from Downunder	by DragonRider from Downunder[_2_]	4	625
Sorting Arun Kumar Saha	by Jovan Timotijevic[_2_]	1	392
Needing to return multiple values from single column [email protected]	by Max	1	1,373
lookup formula StephenAccountant	by T. Valko	9	653
converting number to words Prashant Mhapankar	by Bernd P	3	454
IF/COUNT Statements Help [email protected]	by Teethless mama	5	498
sum column a if column b, c, d, and e are equal jj	by jj	4	1,556
Hard return ttribble	by Gord Dibben	4	627
Conditional Formatting bug? johnston	by johnston	14	1,059
Index and named ranges selecting difficulty Bruce Tharp	by ShaneDevenshire	7	620
Keep formatting while using drop-down list SLW612	by ShaneDevenshire	3	2,055
If Function, looking for formats in values ManBoy86	by Jovan Timotijevic[_2_]	2	366
Pull value from column heading Cecilia	by Dave Peterson	1	772
formula using several colums jv	by Don Guillett	13	927
Need to add to a SUMPRODUCT formula Karen	by Bernard Liengme	2	374
option buttons help kb	by kb	2	550
Excell dragging formula to change sheet/tab not column/row MG	by Gord Dibben	4	4,070
Snedkeys "{F9}", true does not work clara	by [email protected]	2	417
Totaling Different Cell Values ManBoy86	by ManBoy86	4	464
Changing row height in the same worksheet Jess	by Gord Dibben	2	529
How to summarise information from 4 work sheets black_magic	by Gord Dibben	1	708
Sum numbers based on specified criteria R.Miller	by FSt1	5	634
Is there a 255 character limit in pivot table cells? RH-at-PDCO	by Dave Peterson	1	2,056
can I ignore words when sorting excel columns? Tomk	by FSt1	1	646