Excel Worksheet Functions - Page 343

Thread / Thread Starter	Last Post	Replies	Views
Sumif function SRobson	by SRobson	0	326
2 data sets in pivot tables SYRINX	by SYRINX	0	1,429
SUMIF function Igor[_2_]	by David Biddulph[_2_]	3	348
Date Entered +7, unless another field is greater than 0 chickalina	by chickalina	2	575
Date and time stamping with a (macro) button ArcticWolf	by Mike H	4	571
Find a color value Scott	by Scott	5	316
How to split up text Hilton	by Ron Rosenfeld	5	472
More Conditional Formatting tvh	by Stefi	1	325
How do I lock the formatting of my worksheet but still add text? Y2Kate	by sajay[_2_]	2	400
MID and FIND Function for Numbers alxcl	by ArcticWolf	2	411
Excel - Min function over 4 separate cells, but ignoring negatives griff	by griff	8	953
EXCEL SHEET SARADA	by sajay[_2_]	2	399
how to use "IF" to do nothing if a cell is blank jimpc27	by David Biddulph[_2_]	4	1,159
Counting Civette	by Pete_UK	21	1,143
seeking help angel	by angel	2	471
Text to columns with date format does not work :( Tacrier	by Rick Rothstein \(MVP - VB\)[_873_]	1	798
Conditional Formatting for Values in 3 cells tvh	by T. Valko	4	680
First Positive on Horizontal Array VCUE	by T. Valko	7	512
Formula Based on the cell its in JBoyer	by JBoyer	3	404
Locking documents in Excel after a template has been created. Borneval	by Gord Dibben	2	383
When saving, Excel prompt me for all worksheet passwords Tzardos	by Gord Dibben	1	538
Filter Data From Master Sheet Into Other Worksheets Michelle	by Max	1	1,566
Separating Text TÃ©	by pshepard	2	416
how do i calculate the average of 30+ cells over multiple workshee Ariana	by Harlan Grove[_2_]	4	761
Dropping decimal places whern transfering to AS400? Transfer to I-Series proglem	by Harlan Grove[_2_]	2	647
can't lookup a value to the left of my variable Gluefoot	by Sandy Mann	6	608
If statement error check lghovden06	by Peo Sjoblom[_2_]	1	506
How do retrieve deleted files from excel? Tracey	by David Biddulph[_2_]	1	464
Want to unlink calculations Otto Moehrbach[_2_]	by Otto Moehrbach[_2_]	0	469
SUM with nested VLOOKUPS - can i make it ignore N/As? JW73	by Peo Sjoblom[_2_]	5	469
How to extract text from middle of a string Makelei	by Ron Rosenfeld	18	5,832
Its a toughie, not sure if its possible. Chiccada	by pshepard	3	431
name separation Help with Cell question	by Rick Rothstein \(MVP - VB\)[_864_]	3	589
Finding and Adding Rich	by N Harkawat	2	327
How to show a whole worksheet on one screen? Ask MS[_2_]	by Spiky	3	447
Excel Calculation Zee	by T. Valko	4	590
Actual Language for Nesting criteria Judy Rose	by Pete_UK	1	346
Please Help Qtr Mtch KristiM	by KristiM	6	376
VLookup function duranwd	by Belinda7237	3	487
Finding selected numbers within a master list JennaB	by Dave Peterson	2	410
Nested if's and lookup rj shoe	by T. Valko	3	449
Main worksheet to automatically update figures on other worksheets Deb A	by Pete_UK	1	647
Add numbers in a column, but exclude percentages in the same colum Rich W.	by David Biddulph[_2_]	3	888
Makeing a name only show once after i pull a report Steve	by Max	3	851
Formula for adding 2 worksheets accountant	by Rich W.	1	384
Photos Sam	by Max	1	384
Is there a showif formula? Mike[_11_]	by Mike[_11_]	1	929
Moving rows with multiple criteria PAL	by Max	1	454
exact differnce between 2 dates & time, networkday give round off panks	by Gary Brown[_4_]	1	982
Separate protected worksheets feeding into one control sheet bollard	by bollard	0	466
Adding rows based on no of rows specified from a given position nanette	by Pete_UK	1	514
indirect formula syntax Graeme[_2_]	by Dave Peterson	2	418
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) ytayta555	by ytayta555	1	970
Validation in IF string papajoe	by papajoe	0	407
Enabling Macros Nikhil	by David Price	1	541
Excel 2007 nested function David Price	by David Price	2	879
Why I can copy nothing from excel to word or other programme? Henry	by Henry	0	523
Selecting a diff. worksheet but same cell references using Validat Ditch	by Pete_UK	1	434
What formula should I use? Excel User	by Excel User	2	401
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr Max	by Max	13	1,240
lookup question Jonathan Horvath	by Harlan Grove[_2_]	8	576
if then statements with calculations cmac	by Harlan Grove[_2_]	9	1,228
Is there an INDIRECT function for a RANGE? jmt	by T. Valko	3	3,318
Sum below a specific row jdunnisher	by pshepard	1	5,947
IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS BRAINOC	by pshepard	2	1,456
Searching Multiple sheets in excel BIG FRED	by pshepard	3	733
separate e-mail for change in name jenn	by jenn	4	442
Help with dates Looping through	by Pete_UK	2	335
WHat is wrong with this formula Sportinus	by bpeltzer	2	378
Summing same cells in multiple worksheets neilcarden	by Gord Dibben	1	401
XIRR Function - large IRRs KevinGH	by Fred Smith[_4_]	1	596
Summing same cells in multiple worksheets neilcarden	by neilcarden	0	408
spreadsheet colum combination Old Bob	by Gord Dibben	10	740
Converting specific text to numbers then sum Mule	by T. Valko	8	477
Hyper link between spread sheets Bill	by Dave Peterson	2	653