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	596
Invoice Sudipta Sen[_2_]	by Nicholas Perkins[_3_]	1	401
Excel 2007:Share Workbook with import live Data amit	by amit	0	876
Another Formula Question mjones	by David Biddulph[_2_]	3	475
Concatenate and IF? Hannah	by Hannah	2	478
Dynamic name range for use in data validation raphiel2063	by T. Valko	1	570
How do I increment the row and column of a cell in a formula? Dan	by T. Valko	2	514
Formula problem mjones	by T. Valko	8	460
Referencing External files with slightly different names PeteJ	by Jacob Skaria	4	708
Looking for the correct excel formula [email protected]	by Jacob Skaria	2	459
Leave final cell blank Scoober	by Jacob Skaria	2	780
Using Format Painter on multiple cells pj	by Gord Dibben	3	2,615
How do you make the INFO("directory") function work? TimR[_2_]	by Jacob Skaria	1	1,946
Offset function Eva	by T. Valko	12	1,223
Return the current Yearly Quarter based on date hozman	by T. Valko	2	5,009
Hi Nat H.	by Luizvs	2	447
Excel 2007 balks at 7 nested IFs Hal mcl	by T. Valko	5	1,699
Resize image using macro Gotroots	by Luizvs	1	2,023
Validation Drop Down List if cell meets criteria clueless	by clueless	3	2,150
data sort with excel 2002 ShankuN	by Peo Sjoblom[_3_]	1	691
Consecutive date calculation involving holidays BMoran	by Ron Rosenfeld	1	634
Create a document from a spread sheet using data from another spre Sue	by ryguy7272	1	549
Automatic deleting graph segments Xt	by Xt	0	294
Auto insert of a pivot table? Evil with a K[_2_]	by ryguy7272	1	398
days calculations Kimti	by Kimti	7	425
Need formula to round number up to always end in X.X9 Heather	by Ron Rosenfeld	6	2,046
Convert table by date to array Toon	by Herbert Seidenberg	6	955
Simple Question - Sum If?? JenC	by Glenn	5	417
Pivot Table Macro Evil with a K[_2_]	by ryguy7272	1	477
How do I set up an ordering sheet based on averages of past sales Dexter	by David Biddulph[_2_]	1	450
Hiding a cell with a formula. BMoran	by T. Valko	2	452
Conditional formula for dates BMoran	by T. Valko	6	677
vlookup against one of two options? snakey	by T. Valko	3	478
Lookup Formula question Steve Haack	by Glenn	4	471
Lookup for the first occurrence IPELLETIER	by T. Valko	4	1,785
SUMPRODUCT & Wildcards UWSPITHD	by Teethless mama	4	700
In Excel, conditional format (font red) referencing another cell? Christine Hemphill	by Jamie	39	5,406
How to count responses? Possibly use COUNTIF? UWSPITHD	by UWSPITHD	4	1,155
change year in downloaded calender template gmatt	by Dave Peterson	1	507
RECOVERING FILES--HELP ME!!! Maddie	by Eduardo	1	299
How to find lowest points Halin	by Jacob Skaria	2	748
Sales tracking report PSikes	by scottt	5	1,386
Sum same cell across multiple worksheet function does not work... R Hannah	by Stefi	1	748
Fill Formula please palups	by Jacob Skaria	5	415
Pivot Tables JSA	by TroyT	2	402
Copy data to different sheets James Merrill	by Jacob Skaria	6	556
function help! stephaniearaujo22	by TroyT	6	325
How do I formulate total before Gst? Maggie1959	by Joe User[_2_]	2	535
highlight differences Donna[_2_]	by Jacob Skaria	3	297
How to copy a spreadsheet in shared workbook Kathie	by CellShocked	3	1,983
Excel 2007 Move or Copy worksheet lionking	by CellShocked	2	1,946
If..The Statement to automatically format a name G. B. Needs Excel Help	by Ron Rosenfeld	8	534
Apply Filter to source of Pivot Table frankie.lau	by frankie.lau	2	1,632
Sumproduct Subtotal Bec	by Jacob Skaria	1	429
Worksheet formula incorrect after copying to another worksheet Karen	by Karen	2	468
How can I count unique values Irelandabroad	by Herbert Seidenberg	7	445
How do I Undo a Page-Break in excel annie	by Jacob Skaria	1	1,012
Formula Referencing Columns By Date Rob	by Rob	2	428
Sorting a column that contains both text and numbers tstobb	by Dave Peterson	4	430
2003 Exxel possum b	by ryguy7272	1	304
Sort all columns based on one colum Greg	by Bernie Deitrick	3	1,260
Formula Count dates multiple criteria GPearson	by T. Valko	3	448
Multiple Criteria Date Count formula GPearson	by T. Valko	1	549
DCOUNT - date as a field only works when entered as a number jco	by jco	9	805
Lookup function Steve	by Steve	4	395
formula help Soth	by Glenn	6	644
histogram dynamic bin count tpeter	by tpeter	0	1,416
hyperlink to website and then to information in a certain cell Ernie[_2_]	by Ernie	6	706
Autofilter Rajiv	by ryguy7272	3	416
Conditional Formatting Help mjones	by Pete_UK	3	458
Add In vs functions Schedule Guy[_2_]	by Gord Dibben	2	449
Copy/paste data across filtered rows jday	by Peo Sjoblom[_3_]	1	1,872
INDIRECT Function Paul Moles	by Pete_UK	9	578
Removing check boxes (forms toolbar) jvs	by Jacob Skaria	1	508
Help with a formula in an excel 2007 worksheet. Stilmundu	by MRT	1	353