Excel Worksheet Functions - Page 236

Thread / Thread Starter	Last Post	Replies	Views
Wroking with rounded or trunc calculation Wendy - Payroll	by Wendy - Payroll	3	710
sumproduct , array or countif? cjjoo	by duane	5	578
INT Function Dan (WA)	by Dan (WA)	6	354
.csv file - excel 2003 giddne	by giddne	2	328
Calculate difference (mins) between 2 Times Max	by Max	6	662
Countif function for instances of text string contained Garbunkel	by Paul Sheppard	1	805
Defined Named cells lined to a Function Procedure swiftcode	by swiftcode	4	456
return a range of cells from a vertical lookup vickyb_au	by Alvin	2	594
Date entry gone haywire in Excel! umtraveller	by Paul B	3	387
Compare Side by Side with 3 simulatanous sheets scrolling John Louis	by John Louis	0	635
Sumproduct? cjjoo	by Sandy Mann	9	739
Multiple protections GuyB	by GuyB	2	348
Mulitplie workbooks - known duplicate records - need to consolidat triniti	by triniti	2	356
Copying a column to a new sheet so that cells match. Nadeem	by Nadeem	0	632
auto row insert Tsurphr	by Tsurphr	0	588
Calculating the maximum value in a range of cells in a closed work Barb Reinhardt	by Barb Reinhardt	1	463
Unique Value without using FILTER Amit Dhawan	by Ron Rosenfeld	3	685
Can I search the whole workbook and not just a sheet? Kitty	by Ron de Bruin	2	552
Lookup Functions nick	by nick	3	477
Conditional Formatting & Dynamic Range james	by james	2	1,501
How can I do a lowess fit in Excel? Klara	by Klara	3	1,265
Schedule/Date Calculation lkoyne	by Ron Rosenfeld	3	335
Excel - matching data Peter	by Peter	2	438
assign value to text shellie	by Bob Phillips	1	399
In Excel allow freeze pane in any column plus any row vlado	by Dave Peterson	1	1,697
Formula chooser? JKG	by JKG	3	405
How do I concactinate two columns of digits? OMKP	by Duke Carey	2	470
grouping and give colours cjjoo	by David McRitchie	6	483
List Box Multi Select Option ann_nyc	by ann_nyc	0	714
Drop data from workbook after specified time yardcow	by Ian	1	410
How do I change numbers from positive to negitive Debi	by comotoman	2	645
Converting decimals into hh:mm Shandy720	by Arvi Laanemets	4	658
Custom number format - Accounting [email protected]	by [email protected]	0	983
need to calculate time multiplied scheins	by Niek Otten	6	342
How can I use a circular function to add 4 to a column of cells? Tricia	by Niek Otten	3	430
Excel expression {=SUm(if(istext(c8:k8),1,0))} Mike	by Mike	2	551
How to select cells (located in a column) for formulas in a row automatically? Dmitry Kopnichev	by Herbert Seidenberg	3	460
Can I email a single sheet in a workbook? mjdbus00	by Ron de Bruin	1	918
Removing a FIXED Function Amy Sandlin	by Peo Sjoblom	1	351
If correct, add 1 sparky3883	by BenjieLop	2	457
Blank field formatted as date Emily8	by Dave Peterson	5	644
Cell Fomula Ninfa	by Peo Sjoblom	3	357
Text size in validation drop-down list box Jon	by Biff	1	845
reformat columns to rows? RickyDee	by CLR	1	349
Pivot Sort ??? Eric	by Eric	4	617
Using Auto Filter Stealy Dan 1	by Debra Dalgleish	3	492
Limit on number of conditions? Amy F.	by Amy F.	3	299
Making Array Formula, please assist! Macinslaw	by Biff	3	438
sequential numbering of copies printed brian	by Jay	2	520
Hide (limit viewers) to column(s) on a protected worksheet. RAINCITY.1788	by Henrik	1	390
Random numbers john liem	by Harlan Grove	11	819
Formula to capture data on a date and preserve it Jeff	by Jeff	0	639
MEDIAN() as array function? Henrik	by Henrik	6	998
function function	by RagDyer	2	334
Excel Math Wizards scain2004	by Bernie Deitrick	3	371
Corporated into the same fromula please. Steved	by Aladin Akyurek	5	379
If(and spread sheet syntax saziz	by saziz	3	333
HOW DO I MOVE ONE ROW TO ANOTHER PAGE USING A FORMULA. nancyk4544	by Max	1	487
selecting data from a list box LilyDog7	by Dave Peterson	6	511
How do I search for specific text and sum the cell to the right? PacRat2001	by Biff	3	1,024
Simple Question cjjoo	by Biff	2	430
Easier Way? scott45	by Max	2	428
Bonuses and Penalties in Grade Books Kahlan	by BenjieLop	5	383
Excel function same description but different result heng	by Rowan Drummond	1	402
Hour() function Steven	by [email protected]	4	526
Counting the number of formulas on a sheet Werner Rohrmoser	by Andy Brown	1	463
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT GRYSYF	by [email protected]	5	1,741
Excel macro to multiply by same value Recycler29	by Paul B	7	547
ctrl+F in Excel 2003 shida	by shida	0	477
PrintDate "as in MS Word" irresistible007	by Jim May	2	508
Can I group data on different rows together and then sort the grou Stephanie	by CLR	4	784
Formula Help Rehanna	by Ron Rosenfeld	4	399
Filtering numbers???? kewlrunnings	by Ron Rosenfeld	3	623
look up formula Sue	by Bob Phillips	6	409
VB Script in Ecell Dennis Evans	by Bob Phillips	1	340