Excel Worksheet Functions - Page 531

Thread / Thread Starter	Last Post	Replies	Views
SUMPRODUCT AND TEXT INM FORMULA BEEM	by BEEM	13	990
Convert average daily yield to APY Greg	by joeu2004	4	1,141
Excel VLookup Cinny	by Roger Govier	1	355
Functions/Formulas to count multiple variables 2many#s	by 2many#s[_2_]	7	677
IF Statement bob	by Rick Rothstein \(MVP - VB\)	4	401
How do I sort rows containing graphics? Faetan	by Gord Dibben	4	638
Sum A Range only if no text is present in the range AdmiralAJ	by AdmiralAJ	3	797
how do i make bootstrap pendidik	by pendidik	0	541
Need to summarzie a "status" flag MLK	by MLK	2	655
how do i sum of decimal digit in absolute terms dhir	by David Biddulph[_2_]	3	954
Find and Delete Karen[_2_]	by driller	2	520
COUNTIF with AND logic Mitchell_Collen via OfficeKB.com	by Rick Rothstein \(MVP - VB\)	8	953
how can i automate the copy-insertion of a specific number of rows driller	by driller	0	424
pop up calendar using MS DateTime Picker andy62	by andy62	4	1,121
If statement help needed ah	by Roger Govier	16	1,077
how do I look for duplicate house addresses in a column in Excel? Kevin S	by Jovan Timotijevic[_2_]	3	448
Merging 2 lists with a twist dee	by Roger Govier	4	532
"Begins with" Amber	by T. Valko	12	904
get a list of ticked add-in Dan	by Dan	2	584
Duplicate Work Order Numbers chickalina	by chickalina	2	615
spell check in excel 2007 Bonnie	by Bonnie	0	757
Turn off recalculate to send data into TM1 and vice versa. bhinbest	by bhinbest	0	820
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	579
getting numbers divisible by 4 from random numbers in ascending order ramana	by T. Valko	6	2,549
Relative reference for named tabs? Dave in Fair Oaks	by Gord Dibben	6	592
Excel / Access User Conference Damon Longworth	by Damon Longworth	0	483
trouble locking specific cells [email protected]	by Gord Dibben	2	506
SUMPRODUCT #VALUE! error Chris Slowe	by Chris Slowe	2	538
copy part of large WS to another sheet Aurise	by Gord Dibben	3	427
Trouble with Index & Match Arturo	by Peo Sjoblom	3	517
How to use the if statement for Macro coding? Eric	by Eric	3	1,303
TAN INVERSE ? Ahsan	by Mike H	3	1,875
How to open a new instance of EXCEL and .xls file Launchnet	by Launchnet via OfficeKB.com	10	1,378
Formulas in Excel Worksheet jeannie v	by Jovan Timotijevic[_2_]	6	364
Digit to Text Subhashis Bhowmick[_2_]	by Rick Rothstein \(MVP - VB\)	3	466
Conditional Formatting nabanco	by nabanco	2	365
Cell Wrap nabanco	by Pete_UK	4	372
find and replace Karen[_2_]	by Karen[_2_]	2	305
while loop Arun Kumar Saha	by JLatham	2	497
Help with formula please luvgreen	by luvgreen	2	336
Cell reference Issue Jerry Foley	by JLatham	2	414
Poll: Calc cost pro rata (nested IF's and macro to find empty row) herbwarri0r	by herbwarri0r	2	781
Pivot Table Quesiton Tina	by Tina	6	510
Auto Filter Range Subhashis Bhowmick[_2_]	by David Biddulph[_2_]	3	500
DCF Mark Costello	by Mark Costello[_2_]	3	470
=B1/A1 yhtak	by Max	4	430
reorder data ellebelle	by ellebelle	0	519
transfer date to number artisdepartis	by artisdepartis	4	927
getting numbers that are divisible by 4 ramana	by joeu2004	4	1,693
sum alternate rows anand	by Max	4	1,613
On File open - how to stop conversion of postcodes to numbers DragonRider from Downunder	by DragonRider from Downunder[_2_]	4	615
Sorting Arun Kumar Saha	by Jovan Timotijevic[_2_]	1	380
Needing to return multiple values from single column [email protected]	by Max	1	1,368
lookup formula StephenAccountant	by T. Valko	9	653
converting number to words Prashant Mhapankar	by Bernd P	3	447
IF/COUNT Statements Help [email protected]	by Teethless mama	5	484
sum column a if column b, c, d, and e are equal jj	by jj	4	1,543
Hard return ttribble	by Gord Dibben	4	622
Conditional Formatting bug? johnston	by johnston	14	1,050
Index and named ranges selecting difficulty Bruce Tharp	by ShaneDevenshire	7	613
Keep formatting while using drop-down list SLW612	by ShaneDevenshire	3	2,054
If Function, looking for formats in values ManBoy86	by Jovan Timotijevic[_2_]	2	356
Pull value from column heading Cecilia	by Dave Peterson	1	765
formula using several colums jv	by Don Guillett	13	916
Need to add to a SUMPRODUCT formula Karen	by Bernard Liengme	2	369
option buttons help kb	by kb	2	544
Excell dragging formula to change sheet/tab not column/row MG	by Gord Dibben	4	4,062
Snedkeys "{F9}", true does not work clara	by [email protected]	2	416
Totaling Different Cell Values ManBoy86	by ManBoy86	4	456
Changing row height in the same worksheet Jess	by Gord Dibben	2	525
How to summarise information from 4 work sheets black_magic	by Gord Dibben	1	705
Sum numbers based on specified criteria R.Miller	by FSt1	5	628
Is there a 255 character limit in pivot table cells? RH-at-PDCO	by Dave Peterson	1	2,042
can I ignore words when sorting excel columns? Tomk	by FSt1	1	646