Excel Worksheet Functions - Page 534

Thread / Thread Starter	Last Post	Replies	Views
How can I shrink a file size w/ a pivot table and many formulas? ExcelSuperUser	by Roger Govier	3	1,098
LOOKUP, INDEX, MATCH (?) Formula PS	by PS	0	482
Formulas Shannon	by Shannon	2	311
lists urgent help needed mark stillman	by Toppers	2	309
Automate deletion process JanM	by Gord Dibben	4	492
create up and down arrows to increase and decrease value in a cell Bill	by T. Valko	1	1,465
index and sum nonadjacent cells Sam	by JE McGimpsey	10	1,670
nested color index within sumproduct George P	by Bob Phillips	2	1,584
Is there a way to reference 2 separate worksheets with validation Erik	by pdberger	1	407
Conditional Formula [email protected]	by [email protected]	0	339
Form Buttons Connected to a Macro - Want to remove the button Wksht	by Wksht	2	466
Conditional Sum Brackets { } ron	by ron	5	1,344
Conditional Formatting on calculated text gin	by T. Valko	3	708
Array reference in =ROWS() function Gary''s Student	by Gary''s Student	2	428
SUMPRODUCT - Ignore blank rows sahafi	by sahafi	8	2,472
How do I reference certain rows within array formulae? Crazy Pete	by T. Valko	11	1,577
Strange calculation in PivotTable Angus	by Roger Govier	17	918
Automatically duplicate variables Dina	by Dina	2	406
SUMIF Multiple Workbooks DMc2004	by RagDyeR	2	810
Extract text from a string ellebelle	by RagDyeR	4	966
Timezone converter Chris	by Peo Sjoblom	1	1,646
function to retrieve a list of unique characters from a column Pluggie	by RagDyeR	2	6,224
How do i merge date from multiple sheets Klapec Express	by Ron de Bruin	1	464
A change in one cell generates (todays) date in another ihatetheredskins	by Bernie Deitrick	5	436
excel [email protected]	by [email protected]	4	441
Calculated Field Total formula not working snigam	by snigam	0	607
arrange excel by street address instead of alphabetically by name Ray	by sahafi	9	737
Appending or Concatenating rows by Client Dina	by Dina	2	425
Number in words [email protected]	by Rick Rothstein \(MVP - VB\)	4	662
Find 2nd, 3rd, etc Result with index/match BKO	by bj	2	1,592
IRR Guess Dkline	by Dkline	0	618
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row Harry Seymour[_2_]	by Bob Phillips	4	538
How to confirm the open dialogue box by using macro coding? Eric	by Barb Reinhardt	3	735
Averageifs & Countifs Stephanie	by Roger Govier	3	702
Summarizing data to another sheet Jon Dow[_2_]	by David Biddulph[_2_]	9	424
Extracting data inexcell 2003 John cheshire lad	by David Biddulph[_2_]	8	516
Create new list with defined ranges BKO	by BKO	0	479
Create new list with defined ranges BKO	by BKO	0	446
Multiple results BKO	by Gary''s Student	1	1,024
Match with yes or no question Donald B[_2_]	by Bob Phillips	1	587
First Input on a Form JayW	by JayW	0	395
Calendar Control John	by John	3	490
Help with function/formula please!!! Ssuzs	by David Biddulph[_2_]	7	593
Calculation time BKO	by BKO	6	434
Sumproduct and Percentile ryguy7272	by ryguy7272	4	2,194
Need to "merge" two subtotaled lists and show variances Aaron	by Aaron	0	453
how do you get the first column to have headding arrows Headdings	by Headdings	0	360
Concaenate formula- text diff lines? LJoe	by Gord Dibben	9	633
Invert a column Jakobshavn Isbrae	by Ragdyer	5	797
Splitting a Cell williamr	by FSt1	2	430
Fomat cells for IP address including leading Zeros Pete[_2_]	by Ron Rosenfeld	6	4,038
Lookup value If cell is hilighted sahafi	by JMB	1	456
blank vs. 0 when plotting a dated timescale graph [email protected]	by Peo Sjoblom	1	1,063
How do I change direction of Enter Key in EXCEL 2007 H Gallant	by H Gallant[_2_]	2	2,762
RATE - what is the internal function? RDph	by Harlan Grove[_2_]	2	886
=TODAY() Steved	by Teethless mama	7	464
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" Harry Seymour	by Bob Phillips	9	1,771
Leading Zero and the change command mmccoog	by mmccoog	2	457
Generating blank or null cells that the Histogram Data Analysis tool will ignore [email protected]	by [email protected]	2	6,428
Using Vlookup for intervals UnisourceforNPH	by Teethless mama	3	5,190
Can I merge columns from one spreadsheet into another? Petersjill	by Barb Reinhardt	9	1,134
How to index the closest data(cash flow)? [email protected]	by [email protected]	5	515
Pulling in data from another source MLK	by MLK	11	743
Numbers in words Anas	by Rick Rothstein \(MVP - VB\)	8	488
Countif with Conditions Gary	by Toppers	2	549
How do I compare a result to a range of values? UnisourceforNPH	by Gord Dibben	6	577
Email Macro specific Cells? neilcarden	by Ron de Bruin	1	1,141
Displaying percentage sign in cell Feather 52	by Roger Govier	3	1,558
delimiters and manipulation PBArich	by PBArich	0	613
Two Formulas in one cell Jim	by Vasant Nanavati	13	947
Copy a worksheet from one workbook to another Joe	by Ron de Bruin	2	457
excel lines are purple I want black Mari	by Gary''s Student	1	487
Counting Time littlejess22	by littlejess22	3	674
Help with Function: Compare text and and edit in cells CyranoDeBergarac	by CyranoDeBergarac	2	775
base de inquerito MARCIA	by MARCIA	0	560