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,091
LOOKUP, INDEX, MATCH (?) Formula PS	by PS	0	473
Formulas Shannon	by Shannon	2	302
lists urgent help needed mark stillman	by Toppers	2	306
Automate deletion process JanM	by Gord Dibben	4	480
create up and down arrows to increase and decrease value in a cell Bill	by T. Valko	1	1,441
index and sum nonadjacent cells Sam	by JE McGimpsey	10	1,647
nested color index within sumproduct George P	by Bob Phillips	2	1,560
Is there a way to reference 2 separate worksheets with validation Erik	by pdberger	1	386
Conditional Formula [email protected]	by [email protected]	0	336
Form Buttons Connected to a Macro - Want to remove the button Wksht	by Wksht	2	449
Conditional Sum Brackets { } ron	by ron	5	1,325
Conditional Formatting on calculated text gin	by T. Valko	3	695
Array reference in =ROWS() function Gary''s Student	by Gary''s Student	2	423
SUMPRODUCT - Ignore blank rows sahafi	by sahafi	8	2,447
How do I reference certain rows within array formulae? Crazy Pete	by T. Valko	11	1,563
Strange calculation in PivotTable Angus	by Roger Govier	17	904
Automatically duplicate variables Dina	by Dina	2	390
SUMIF Multiple Workbooks DMc2004	by RagDyeR	2	793
Extract text from a string ellebelle	by RagDyeR	4	887
Timezone converter Chris	by Peo Sjoblom	1	1,638
function to retrieve a list of unique characters from a column Pluggie	by RagDyeR	2	6,198
How do i merge date from multiple sheets Klapec Express	by Ron de Bruin	1	456
A change in one cell generates (todays) date in another ihatetheredskins	by Bernie Deitrick	5	428
excel [email protected]	by [email protected]	4	429
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	728
Appending or Concatenating rows by Client Dina	by Dina	2	412
Number in words [email protected]	by Rick Rothstein \(MVP - VB\)	4	653
Find 2nd, 3rd, etc Result with index/match BKO	by bj	2	1,584
IRR Guess Dkline	by Dkline	0	600
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row Harry Seymour[_2_]	by Bob Phillips	4	532
How to confirm the open dialogue box by using macro coding? Eric	by Barb Reinhardt	3	705
Averageifs & Countifs Stephanie	by Roger Govier	3	682
Summarizing data to another sheet Jon Dow[_2_]	by David Biddulph[_2_]	9	413
Extracting data inexcell 2003 John cheshire lad	by David Biddulph[_2_]	8	512
Create new list with defined ranges BKO	by BKO	0	468
Create new list with defined ranges BKO	by BKO	0	430
Multiple results BKO	by Gary''s Student	1	1,020
Match with yes or no question Donald B[_2_]	by Bob Phillips	1	582
First Input on a Form JayW	by JayW	0	376
Calendar Control John	by John	3	475
Help with function/formula please!!! Ssuzs	by David Biddulph[_2_]	7	581
Calculation time BKO	by BKO	6	430
Sumproduct and Percentile ryguy7272	by ryguy7272	4	2,138
Need to "merge" two subtotaled lists and show variances Aaron	by Aaron	0	443
how do you get the first column to have headding arrows Headdings	by Headdings	0	355
Concaenate formula- text diff lines? LJoe	by Gord Dibben	9	614
Invert a column Jakobshavn Isbrae	by Ragdyer	5	778
Splitting a Cell williamr	by FSt1	2	402
Fomat cells for IP address including leading Zeros Pete[_2_]	by Ron Rosenfeld	6	4,015
Lookup value If cell is hilighted sahafi	by JMB	1	439
blank vs. 0 when plotting a dated timescale graph [email protected]	by Peo Sjoblom	1	1,049
How do I change direction of Enter Key in EXCEL 2007 H Gallant	by H Gallant[_2_]	2	2,719
RATE - what is the internal function? RDph	by Harlan Grove[_2_]	2	882
=TODAY() Steved	by Teethless mama	7	449
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" Harry Seymour	by Bob Phillips	9	1,733
Leading Zero and the change command mmccoog	by mmccoog	2	437
Generating blank or null cells that the Histogram Data Analysis tool will ignore [email protected]	by [email protected]	2	6,362
Using Vlookup for intervals UnisourceforNPH	by Teethless mama	3	5,160
Can I merge columns from one spreadsheet into another? Petersjill	by Barb Reinhardt	9	1,124
How to index the closest data(cash flow)? [email protected]	by [email protected]	5	508
Pulling in data from another source MLK	by MLK	11	729
Numbers in words Anas	by Rick Rothstein \(MVP - VB\)	8	480
Countif with Conditions Gary	by Toppers	2	528
How do I compare a result to a range of values? UnisourceforNPH	by Gord Dibben	6	561
Email Macro specific Cells? neilcarden	by Ron de Bruin	1	1,133
Displaying percentage sign in cell Feather 52	by Roger Govier	3	1,550
delimiters and manipulation PBArich	by PBArich	0	600
Two Formulas in one cell Jim	by Vasant Nanavati	13	929
Copy a worksheet from one workbook to another Joe	by Ron de Bruin	2	437
excel lines are purple I want black Mari	by Gary''s Student	1	478
Counting Time littlejess22	by littlejess22	3	648
Help with Function: Compare text and and edit in cells CyranoDeBergarac	by CyranoDeBergarac	2	758
base de inquerito MARCIA	by MARCIA	0	557