Excel Worksheet Functions - Page 531

Thread / Thread Starter	Last Post	Replies	Views
SUMPRODUCT AND TEXT INM FORMULA BEEM	by BEEM	13	982
Convert average daily yield to APY Greg	by joeu2004	4	1,134
Excel VLookup Cinny	by Roger Govier	1	347
Functions/Formulas to count multiple variables 2many#s	by 2many#s[_2_]	7	660
IF Statement bob	by Rick Rothstein \(MVP - VB\)	4	390
How do I sort rows containing graphics? Faetan	by Gord Dibben	4	561
Sum A Range only if no text is present in the range AdmiralAJ	by AdmiralAJ	3	789
how do i make bootstrap pendidik	by pendidik	0	532
Need to summarzie a "status" flag MLK	by MLK	2	637
how do i sum of decimal digit in absolute terms dhir	by David Biddulph[_2_]	3	935
Find and Delete Karen[_2_]	by driller	2	489
COUNTIF with AND logic Mitchell_Collen via OfficeKB.com	by Rick Rothstein \(MVP - VB\)	8	940
how can i automate the copy-insertion of a specific number of rows driller	by driller	0	397
pop up calendar using MS DateTime Picker andy62	by andy62	4	1,103
If statement help needed ah	by Roger Govier	16	1,055
how do I look for duplicate house addresses in a column in Excel? Kevin S	by Jovan Timotijevic[_2_]	3	432
Merging 2 lists with a twist dee	by Roger Govier	4	513
"Begins with" Amber	by T. Valko	12	888
get a list of ticked add-in Dan	by Dan	2	567
Duplicate Work Order Numbers chickalina	by chickalina	2	603
spell check in excel 2007 Bonnie	by Bonnie	0	744
Turn off recalculate to send data into TM1 and vice versa. bhinbest	by bhinbest	0	810
Positive or negative sign in a calculated cell Michel Khennafi	by Michel Khennafi	5	1,069
vlookup format problem Patio	by Gary''s Student	1	546
getting numbers divisible by 4 from random numbers in ascending order ramana	by T. Valko	6	2,473
Relative reference for named tabs? Dave in Fair Oaks	by Gord Dibben	6	571
Excel / Access User Conference Damon Longworth	by Damon Longworth	0	465
trouble locking specific cells [email protected]	by Gord Dibben	2	495
SUMPRODUCT #VALUE! error Chris Slowe	by Chris Slowe	2	521
copy part of large WS to another sheet Aurise	by Gord Dibben	3	403
Trouble with Index & Match Arturo	by Peo Sjoblom	3	507
How to use the if statement for Macro coding? Eric	by Eric	3	1,288
TAN INVERSE ? Ahsan	by Mike H	3	1,840
How to open a new instance of EXCEL and .xls file Launchnet	by Launchnet via OfficeKB.com	10	1,297
Formulas in Excel Worksheet jeannie v	by Jovan Timotijevic[_2_]	6	356
Digit to Text Subhashis Bhowmick[_2_]	by Rick Rothstein \(MVP - VB\)	3	456
Conditional Formatting nabanco	by nabanco	2	346
Cell Wrap nabanco	by Pete_UK	4	352
find and replace Karen[_2_]	by Karen[_2_]	2	285
while loop Arun Kumar Saha	by JLatham	2	482
Help with formula please luvgreen	by luvgreen	2	324
Cell reference Issue Jerry Foley	by JLatham	2	398
Poll: Calc cost pro rata (nested IF's and macro to find empty row) herbwarri0r	by herbwarri0r	2	764
Pivot Table Quesiton Tina	by Tina	6	499
Auto Filter Range Subhashis Bhowmick[_2_]	by David Biddulph[_2_]	3	477
DCF Mark Costello	by Mark Costello[_2_]	3	461
=B1/A1 yhtak	by Max	4	416
reorder data ellebelle	by ellebelle	0	510
transfer date to number artisdepartis	by artisdepartis	4	918
getting numbers that are divisible by 4 ramana	by joeu2004	4	1,670
sum alternate rows anand	by Max	4	1,544
On File open - how to stop conversion of postcodes to numbers DragonRider from Downunder	by DragonRider from Downunder[_2_]	4	591
Sorting Arun Kumar Saha	by Jovan Timotijevic[_2_]	1	369
Needing to return multiple values from single column [email protected]	by Max	1	1,341
lookup formula StephenAccountant	by T. Valko	9	629
converting number to words Prashant Mhapankar	by Bernd P	3	437
IF/COUNT Statements Help [email protected]	by Teethless mama	5	472
sum column a if column b, c, d, and e are equal jj	by jj	4	1,490
Hard return ttribble	by Gord Dibben	4	609
Conditional Formatting bug? johnston	by johnston	14	1,037
Index and named ranges selecting difficulty Bruce Tharp	by ShaneDevenshire	7	591
Keep formatting while using drop-down list SLW612	by ShaneDevenshire	3	2,042
If Function, looking for formats in values ManBoy86	by Jovan Timotijevic[_2_]	2	333
Pull value from column heading Cecilia	by Dave Peterson	1	735
formula using several colums jv	by Don Guillett	13	905
Need to add to a SUMPRODUCT formula Karen	by Bernard Liengme	2	356
option buttons help kb	by kb	2	511
Excell dragging formula to change sheet/tab not column/row MG	by Gord Dibben	4	4,030
Snedkeys "{F9}", true does not work clara	by [email protected]	2	409
Totaling Different Cell Values ManBoy86	by ManBoy86	4	439
Changing row height in the same worksheet Jess	by Gord Dibben	2	509
How to summarise information from 4 work sheets black_magic	by Gord Dibben	1	687
Sum numbers based on specified criteria R.Miller	by FSt1	5	613
Is there a 255 character limit in pivot table cells? RH-at-PDCO	by Dave Peterson	1	2,002
can I ignore words when sorting excel columns? Tomk	by FSt1	1	626