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,106
LOOKUP, INDEX, MATCH (?) Formula PS	by PS	0	484
Formulas Shannon	by Shannon	2	316
lists urgent help needed mark stillman	by Toppers	2	314
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	349
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	435
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,582
Strange calculation in PivotTable Angus	by Roger Govier	17	918
Automatically duplicate variables Dina	by Dina	2	416
SUMIF Multiple Workbooks DMc2004	by RagDyeR	2	812
Extract text from a string ellebelle	by RagDyeR	4	966
Timezone converter Chris	by Peo Sjoblom	1	1,649
function to retrieve a list of unique characters from a column Pluggie	by RagDyeR	2	6,233
How do i merge date from multiple sheets Klapec Express	by Ron de Bruin	1	475
A change in one cell generates (todays) date in another ihatetheredskins	by Bernie Deitrick	5	441
excel [email protected]	by [email protected]	4	444
Calculated Field Total formula not working snigam	by snigam	0	615
arrange excel by street address instead of alphabetically by name Ray	by sahafi	9	746
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	628
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row Harry Seymour[_2_]	by Bob Phillips	4	540
How to confirm the open dialogue box by using macro coding? Eric	by Barb Reinhardt	3	745
Averageifs & Countifs Stephanie	by Roger Govier	3	703
Summarizing data to another sheet Jon Dow[_2_]	by David Biddulph[_2_]	9	430
Extracting data inexcell 2003 John cheshire lad	by David Biddulph[_2_]	8	521
Create new list with defined ranges BKO	by BKO	0	483
Create new list with defined ranges BKO	by BKO	0	446
Multiple results BKO	by Gary''s Student	1	1,027
Match with yes or no question Donald B[_2_]	by Bob Phillips	1	587
First Input on a Form JayW	by JayW	0	405
Calendar Control John	by John	3	490
Help with function/formula please!!! Ssuzs	by David Biddulph[_2_]	7	596
Calculation time BKO	by BKO	6	439
Sumproduct and Percentile ryguy7272	by ryguy7272	4	2,194
Need to "merge" two subtotaled lists and show variances Aaron	by Aaron	0	454
how do you get the first column to have headding arrows Headdings	by Headdings	0	363
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,039
Lookup value If cell is hilighted sahafi	by JMB	1	459
blank vs. 0 when plotting a dated timescale graph [email protected]	by Peo Sjoblom	1	1,073
How do I change direction of Enter Key in EXCEL 2007 H Gallant	by H Gallant[_2_]	2	2,768
RATE - what is the internal function? RDph	by Harlan Grove[_2_]	2	894
=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,772
Leading Zero and the change command mmccoog	by mmccoog	2	460
Generating blank or null cells that the Histogram Data Analysis tool will ignore [email protected]	by [email protected]	2	6,442
Using Vlookup for intervals UnisourceforNPH	by Teethless mama	3	5,192
Can I merge columns from one spreadsheet into another? Petersjill	by Barb Reinhardt	9	1,141
How to index the closest data(cash flow)? [email protected]	by [email protected]	5	520
Pulling in data from another source MLK	by MLK	11	752
Numbers in words Anas	by Rick Rothstein \(MVP - VB\)	8	488
Countif with Conditions Gary	by Toppers	2	550
How do I compare a result to a range of values? UnisourceforNPH	by Gord Dibben	6	584
Email Macro specific Cells? neilcarden	by Ron de Bruin	1	1,141
Displaying percentage sign in cell Feather 52	by Roger Govier	3	1,561
delimiters and manipulation PBArich	by PBArich	0	613
Two Formulas in one cell Jim	by Vasant Nanavati	13	951
Copy a worksheet from one workbook to another Joe	by Ron de Bruin	2	458
excel lines are purple I want black Mari	by Gary''s Student	1	487
Counting Time littlejess22	by littlejess22	3	676
Help with Function: Compare text and and edit in cells CyranoDeBergarac	by CyranoDeBergarac	2	782
base de inquerito MARCIA	by MARCIA	0	565