Excel Worksheet Functions - Page 386

Thread / Thread Starter	Last Post	Replies	Views
Replace Comma with Dash [email protected]	by Rick Rothstein \(MVP - VB\)[_336_]	3	1,588
Converting time to decimal NoodNutt	by NoodNutt	4	611
Wrap Text Mark	by Teethless mama	1	326
Adding new rows in between rows... MarshaMarsha	by Blue Max	7	441
How to ignore the signs and make the functions work Igneshwara reddy[_2_]	by T. Valko	3	3,063
translate degrees to latitude longitude Math Teacher	by Fred Smith[_4_]	3	1,071
Future Value Array Formula AdmiralAJ	by Fred Smith[_4_]	1	441
How do I stop a worksheet from scrolling? rcomer123	by rcomer123	4	1,212
Complex formula/equation Shaun H. in the United States[_2_]	by Ashish Mathur[_2_]	2	487
Formulas Affected by Insert Row MJS	by MJS	7	500
Splitting data into multiple fields. DamselNTX	by Ron Rosenfeld	3	467
Autofill a Sheet Reference JOJO193	by David McRitchie	7	999
NETWORKDAYS() saved as =#N/A in XL2007 Sean	by amcnelis	15	1,118
How to get linked file from worksheet to = "blank" seno	by Pete_UK	4	385
Text Wrap Steved	by Steved	5	349
copy if data matches [email protected]	by [email protected]	3	604
Problem with Function sgreene	by Dave	12	1,178
making a UDF that runs solver maria bernal	by Mike Middleton	1	820
Advanced Filter Critera using formula not working KKPeters	by Max	5	1,077
excel 2003 value change narp	by pdberger	7	461
funcion de distribucion empirica Sonia	by Mayte	1	2,307
Compare values of two columns Diane	by Marcelo	5	604
Is there away to shorten Steved	by Steved	2	554
count special characters Gaurav[_2_]	by Rick Rothstein \(MVP - VB\)[_332_]	3	1,572
vlookup across multiple pages Chris	by Chris	2	526
Reformatting data and consolidating lcotner	by lcotner	2	526
Reducing numbers by one in defined areas over several sheets Colin Hayes	by Colin Hayes	12	835
SUMIF (Excel 97) Phendrena	by Sandy Mann	3	476
How do I use count, sum, or avg formulas on autofiltered results. Hospice Volunteer Services	by Mike H	1	418
Combine Pivot Tables April I''m not quite sure...	by ryguy7272	1	6,503
Problem with Index function Steve M	by David Biddulph[_2_]	3	374
formula Shaun H. in the United States	by Shaun H. in the United States[_2_]	2	322
creating columns based on date range childofthe1980s	by childofthe1980s	0	436
vlookup and validation lists Riptide	by Mayte	1	379
Anyone know how to set up an employee turnover worksheet? Pennywise	by Mayte	1	2,033
Counting & Displaying Henn9660	by Henn9660	4	352
nested conditional subtotals RayB	by Bernie Deitrick	2	403
Conditional formatting and validation Krissy	by Brad Vogt	6	461
Selecting date range for counts bokey	by bokey	5	603
error in excell 2007 Mike7of_9	by euro bum	9	518
Shared Workbook is "locked for editing" susu	by susu	0	1,316
HELP ON SUMPRODUCT() Eddy Stan	by Teethless mama	4	539
How do I use Hyperlinks inside an Excel cell's comment field? Conner17007	by Gary''s Student	1	1,827
Adding to an existing formula JPS	by Gary''s Student	2	1,682
'if then' color changes....................... TWWARD	by Max	4	460
Comparing two lists using two columns from each spreadsheet sdj78	by ryguy7272	1	710
=sheet grahame	by FSt1	1	341
How to sum every 2nd or 3rd row Mario[_3_]	by ryguy7272	2	553
How do I get a calendar in a drop down in a cell Anne	by ryguy7272	1	356
Removing numbers to the left mpenkala	by Ron Rosenfeld	8	459
A total Formula (Help) Tia[_3_]	by David Biddulph[_2_]	2	405
Excel data table from Adobe - formatting Pat Adams	by David Biddulph[_2_]	9	456
excel grahame	by Fred Smith[_4_]	2	392
Number formating in CONCATENATE formula (Part 2) V Padale	by V Padale[_2_]	4	753
Comparing two lists using two columns from each spreadsheet sdj78	by sdj78	0	490
Matching columns and removing duplicates Adam	by Adam	10	1,050
How to add entry in the list for drop down in excel? Drop down list in Excel sheet	by Max	1	3,206
Stop unique values been entered LLoyd	by Max	1	381
Why is it that when I link a cell to one from another worksheet, kymposs	by Max	4	419
i want sum something using two criteria WaqB	by Mike H	1	342
Display Numbers in Lac, Crore Format vimal	by vimal	0	1,251
ATPBAEN.XLA Link created when using XIRR ExcelMonkey	by ExcelMonkey	0	443
How do i use the If function to Lookup in a chart kethrydrake	by T. Valko	1	314
Return the 2 lowest numbers within a range mpenkala	by T. Valko	6	508
using text as a "true" condition in an if function. diggyroo	by T. Valko	5	837
What excel snyntax and or function will add leading spaces Sharon	by Dave Peterson	3	2,275
Lookup value then return result from other column, varying row num Justin	by Max	5	1,201
Linking Cells, Incorrect Result Susan at DEINC	by Bernard Liengme[_2_]	1	358
Figuring out inventory levels JSF	by FSt1	2	2,273
Counting dates tonyalt3	by Ron Rosenfeld	5	316
Unzip fuction in excel Willy	by JP[_4_]	1	461
How can I add a similar amount to a full column of prices Colbirds	by Gord Dibben	4	677
is there a quick easy way to input time? typographically challenged	by Gord Dibben	2	4,974
I need help to create a complicated formula. Gwynne	by Gwynne	2	383
Date Formatting theresa317	by daddylonglegs	3	294