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,088
LOOKUP, INDEX, MATCH (?) Formula PS	by PS	0	471
Formulas Shannon	by Shannon	2	299
lists urgent help needed mark stillman	by Toppers	2	302
Automate deletion process JanM	by Gord Dibben	4	470
create up and down arrows to increase and decrease value in a cell Bill	by T. Valko	1	1,406
index and sum nonadjacent cells Sam	by JE McGimpsey	10	1,634
nested color index within sumproduct George P	by Bob Phillips	2	1,553
Is there a way to reference 2 separate worksheets with validation Erik	by pdberger	1	380
Conditional Formula [email protected]	by [email protected]	0	334
Form Buttons Connected to a Macro - Want to remove the button Wksht	by Wksht	2	443
Conditional Sum Brackets { } ron	by ron	5	1,324
Conditional Formatting on calculated text gin	by T. Valko	3	694
Array reference in =ROWS() function Gary''s Student	by Gary''s Student	2	417
SUMPRODUCT - Ignore blank rows sahafi	by sahafi	8	2,443
How do I reference certain rows within array formulae? Crazy Pete	by T. Valko	11	1,561
Strange calculation in PivotTable Angus	by Roger Govier	17	902
Automatically duplicate variables Dina	by Dina	2	388
SUMIF Multiple Workbooks DMc2004	by RagDyeR	2	757
Extract text from a string ellebelle	by RagDyeR	4	885
Timezone converter Chris	by Peo Sjoblom	1	1,632
function to retrieve a list of unique characters from a column Pluggie	by RagDyeR	2	6,184
How do i merge date from multiple sheets Klapec Express	by Ron de Bruin	1	451
A change in one cell generates (todays) date in another ihatetheredskins	by Bernie Deitrick	5	426
excel [email protected]	by [email protected]	4	428
Calculated Field Total formula not working snigam	by snigam	0	599
arrange excel by street address instead of alphabetically by name Ray	by sahafi	9	726
Appending or Concatenating rows by Client Dina	by Dina	2	410
Number in words [email protected]	by Rick Rothstein \(MVP - VB\)	4	650
Find 2nd, 3rd, etc Result with index/match BKO	by bj	2	1,582
IRR Guess Dkline	by Dkline	0	598
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row Harry Seymour[_2_]	by Bob Phillips	4	527
How to confirm the open dialogue box by using macro coding? Eric	by Barb Reinhardt	3	702
Averageifs & Countifs Stephanie	by Roger Govier	3	679
Summarizing data to another sheet Jon Dow[_2_]	by David Biddulph[_2_]	9	410
Extracting data inexcell 2003 John cheshire lad	by David Biddulph[_2_]	8	509
Create new list with defined ranges BKO	by BKO	0	467
Create new list with defined ranges BKO	by BKO	0	424
Multiple results BKO	by Gary''s Student	1	1,017
Match with yes or no question Donald B[_2_]	by Bob Phillips	1	578
First Input on a Form JayW	by JayW	0	374
Calendar Control John	by John	3	472
Help with function/formula please!!! Ssuzs	by David Biddulph[_2_]	7	578
Calculation time BKO	by BKO	6	426
Sumproduct and Percentile ryguy7272	by ryguy7272	4	2,134
Need to "merge" two subtotaled lists and show variances Aaron	by Aaron	0	441
how do you get the first column to have headding arrows Headdings	by Headdings	0	353
Concaenate formula- text diff lines? LJoe	by Gord Dibben	9	610
Invert a column Jakobshavn Isbrae	by Ragdyer	5	776
Splitting a Cell williamr	by FSt1	2	397
Fomat cells for IP address including leading Zeros Pete[_2_]	by Ron Rosenfeld	6	4,009
Lookup value If cell is hilighted sahafi	by JMB	1	390
blank vs. 0 when plotting a dated timescale graph [email protected]	by Peo Sjoblom	1	1,048
How do I change direction of Enter Key in EXCEL 2007 H Gallant	by H Gallant[_2_]	2	2,711
RATE - what is the internal function? RDph	by Harlan Grove[_2_]	2	880
=TODAY() Steved	by Teethless mama	7	447
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" Harry Seymour	by Bob Phillips	9	1,727
Leading Zero and the change command mmccoog	by mmccoog	2	403
Generating blank or null cells that the Histogram Data Analysis tool will ignore [email protected]	by [email protected]	2	6,357
Using Vlookup for intervals UnisourceforNPH	by Teethless mama	3	5,154
Can I merge columns from one spreadsheet into another? Petersjill	by Barb Reinhardt	9	1,122
How to index the closest data(cash flow)? [email protected]	by [email protected]	5	504
Pulling in data from another source MLK	by MLK	11	724
Numbers in words Anas	by Rick Rothstein \(MVP - VB\)	8	477
Countif with Conditions Gary	by Toppers	2	525
How do I compare a result to a range of values? UnisourceforNPH	by Gord Dibben	6	553
Email Macro specific Cells? neilcarden	by Ron de Bruin	1	1,131
Displaying percentage sign in cell Feather 52	by Roger Govier	3	1,548
delimiters and manipulation PBArich	by PBArich	0	596
Two Formulas in one cell Jim	by Vasant Nanavati	13	924
Copy a worksheet from one workbook to another Joe	by Ron de Bruin	2	433
excel lines are purple I want black Mari	by Gary''s Student	1	475
Counting Time littlejess22	by littlejess22	3	644
Help with Function: Compare text and and edit in cells CyranoDeBergarac	by CyranoDeBergarac	2	756
base de inquerito MARCIA	by MARCIA	0	555