Excel Worksheet Functions - Page 112

Thread / Thread Starter	Last Post	Replies	Views
can hidden sheets be prevented from opening without a password? unclepablo54	by Nicholas Perkins[_3_]	2	621
Invoice Sudipta Sen[_2_]	by Nicholas Perkins[_3_]	1	411
Excel 2007:Share Workbook with import live Data amit	by amit	0	894
Another Formula Question mjones	by David Biddulph[_2_]	3	499
Concatenate and IF? Hannah	by Hannah	2	503
Dynamic name range for use in data validation raphiel2063	by T. Valko	1	588
How do I increment the row and column of a cell in a formula? Dan	by T. Valko	2	528
Formula problem mjones	by T. Valko	8	507
Referencing External files with slightly different names PeteJ	by Jacob Skaria	4	764
Looking for the correct excel formula [email protected]	by Jacob Skaria	2	470
Leave final cell blank Scoober	by Jacob Skaria	2	794
Using Format Painter on multiple cells pj	by Gord Dibben	3	2,629
How do you make the INFO("directory") function work? TimR[_2_]	by Jacob Skaria	1	2,002
Offset function Eva	by T. Valko	12	1,255
Return the current Yearly Quarter based on date hozman	by T. Valko	2	5,075
Hi Nat H.	by Luizvs	2	458
Excel 2007 balks at 7 nested IFs Hal mcl	by T. Valko	5	1,745
Resize image using macro Gotroots	by Luizvs	1	2,044
Validation Drop Down List if cell meets criteria clueless	by clueless	3	2,172
data sort with excel 2002 ShankuN	by Peo Sjoblom[_3_]	1	749
Consecutive date calculation involving holidays BMoran	by Ron Rosenfeld	1	658
Create a document from a spread sheet using data from another spre Sue	by ryguy7272	1	568
Automatic deleting graph segments Xt	by Xt	0	316
Auto insert of a pivot table? Evil with a K[_2_]	by ryguy7272	1	416
days calculations Kimti	by Kimti	7	440
Need formula to round number up to always end in X.X9 Heather	by Ron Rosenfeld	6	2,139
Convert table by date to array Toon	by Herbert Seidenberg	6	988
Simple Question - Sum If?? JenC	by Glenn	5	435
Pivot Table Macro Evil with a K[_2_]	by ryguy7272	1	512
How do I set up an ordering sheet based on averages of past sales Dexter	by David Biddulph[_2_]	1	458
Hiding a cell with a formula. BMoran	by T. Valko	2	468
Conditional formula for dates BMoran	by T. Valko	6	699
vlookup against one of two options? snakey	by T. Valko	3	492
Lookup Formula question Steve Haack	by Glenn	4	484
Lookup for the first occurrence IPELLETIER	by T. Valko	4	1,798
SUMPRODUCT & Wildcards UWSPITHD	by Teethless mama	4	712
In Excel, conditional format (font red) referencing another cell? Christine Hemphill	by Jamie	39	5,480
How to count responses? Possibly use COUNTIF? UWSPITHD	by UWSPITHD	4	1,167
change year in downloaded calender template gmatt	by Dave Peterson	1	522
RECOVERING FILES--HELP ME!!! Maddie	by Eduardo	1	304
How to find lowest points Halin	by Jacob Skaria	2	766
Sales tracking report PSikes	by scottt	5	1,400
Sum same cell across multiple worksheet function does not work... R Hannah	by Stefi	1	764
Fill Formula please palups	by Jacob Skaria	5	438
Pivot Tables JSA	by TroyT	2	416
Copy data to different sheets James Merrill	by Jacob Skaria	6	585
function help! stephaniearaujo22	by TroyT	6	330
How do I formulate total before Gst? Maggie1959	by Joe User[_2_]	2	546
highlight differences Donna[_2_]	by Jacob Skaria	3	325
How to copy a spreadsheet in shared workbook Kathie	by CellShocked	3	2,007
Excel 2007 Move or Copy worksheet lionking	by CellShocked	2	1,973
If..The Statement to automatically format a name G. B. Needs Excel Help	by Ron Rosenfeld	8	543
Apply Filter to source of Pivot Table frankie.lau	by frankie.lau	2	1,659
Sumproduct Subtotal Bec	by Jacob Skaria	1	440
Worksheet formula incorrect after copying to another worksheet Karen	by Karen	2	491
How can I count unique values Irelandabroad	by Herbert Seidenberg	7	463
How do I Undo a Page-Break in excel annie	by Jacob Skaria	1	1,031
Formula Referencing Columns By Date Rob	by Rob	2	453
Sorting a column that contains both text and numbers tstobb	by Dave Peterson	4	439
2003 Exxel possum b	by ryguy7272	1	308
Sort all columns based on one colum Greg	by Bernie Deitrick	3	1,285
Formula Count dates multiple criteria GPearson	by T. Valko	3	466
Multiple Criteria Date Count formula GPearson	by T. Valko	1	584
DCOUNT - date as a field only works when entered as a number jco	by jco	9	826
Lookup function Steve	by Steve	4	401
formula help Soth	by Glenn	6	660
histogram dynamic bin count tpeter	by tpeter	0	1,434
hyperlink to website and then to information in a certain cell Ernie[_2_]	by Ernie	6	721
Autofilter Rajiv	by ryguy7272	3	423
Conditional Formatting Help mjones	by Pete_UK	3	466
Add In vs functions Schedule Guy[_2_]	by Gord Dibben	2	455
Copy/paste data across filtered rows jday	by Peo Sjoblom[_3_]	1	1,902
INDIRECT Function Paul Moles	by Pete_UK	9	609
Removing check boxes (forms toolbar) jvs	by Jacob Skaria	1	532
Help with a formula in an excel 2007 worksheet. Stilmundu	by MRT	1	362