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	609
Invoice Sudipta Sen[_2_]	by Nicholas Perkins[_3_]	1	409
Excel 2007:Share Workbook with import live Data amit	by amit	0	889
Another Formula Question mjones	by David Biddulph[_2_]	3	493
Concatenate and IF? Hannah	by Hannah	2	492
Dynamic name range for use in data validation raphiel2063	by T. Valko	1	587
How do I increment the row and column of a cell in a formula? Dan	by T. Valko	2	524
Formula problem mjones	by T. Valko	8	504
Referencing External files with slightly different names PeteJ	by Jacob Skaria	4	753
Looking for the correct excel formula [email protected]	by Jacob Skaria	2	469
Leave final cell blank Scoober	by Jacob Skaria	2	792
Using Format Painter on multiple cells pj	by Gord Dibben	3	2,625
How do you make the INFO("directory") function work? TimR[_2_]	by Jacob Skaria	1	1,983
Offset function Eva	by T. Valko	12	1,243
Return the current Yearly Quarter based on date hozman	by T. Valko	2	5,059
Hi Nat H.	by Luizvs	2	456
Excel 2007 balks at 7 nested IFs Hal mcl	by T. Valko	5	1,731
Resize image using macro Gotroots	by Luizvs	1	2,033
Validation Drop Down List if cell meets criteria clueless	by clueless	3	2,162
data sort with excel 2002 ShankuN	by Peo Sjoblom[_3_]	1	737
Consecutive date calculation involving holidays BMoran	by Ron Rosenfeld	1	651
Create a document from a spread sheet using data from another spre Sue	by ryguy7272	1	565
Automatic deleting graph segments Xt	by Xt	0	312
Auto insert of a pivot table? Evil with a K[_2_]	by ryguy7272	1	409
days calculations Kimti	by Kimti	7	437
Need formula to round number up to always end in X.X9 Heather	by Ron Rosenfeld	6	2,129
Convert table by date to array Toon	by Herbert Seidenberg	6	978
Simple Question - Sum If?? JenC	by Glenn	5	425
Pivot Table Macro Evil with a K[_2_]	by ryguy7272	1	497
How do I set up an ordering sheet based on averages of past sales Dexter	by David Biddulph[_2_]	1	457
Hiding a cell with a formula. BMoran	by T. Valko	2	464
Conditional formula for dates BMoran	by T. Valko	6	695
vlookup against one of two options? snakey	by T. Valko	3	489
Lookup Formula question Steve Haack	by Glenn	4	479
Lookup for the first occurrence IPELLETIER	by T. Valko	4	1,793
SUMPRODUCT & Wildcards UWSPITHD	by Teethless mama	4	711
In Excel, conditional format (font red) referencing another cell? Christine Hemphill	by Jamie	39	5,423
How to count responses? Possibly use COUNTIF? UWSPITHD	by UWSPITHD	4	1,166
change year in downloaded calender template gmatt	by Dave Peterson	1	521
RECOVERING FILES--HELP ME!!! Maddie	by Eduardo	1	303
How to find lowest points Halin	by Jacob Skaria	2	764
Sales tracking report PSikes	by scottt	5	1,396
Sum same cell across multiple worksheet function does not work... R Hannah	by Stefi	1	761
Fill Formula please palups	by Jacob Skaria	5	432
Pivot Tables JSA	by TroyT	2	415
Copy data to different sheets James Merrill	by Jacob Skaria	6	572
function help! stephaniearaujo22	by TroyT	6	329
How do I formulate total before Gst? Maggie1959	by Joe User[_2_]	2	545
highlight differences Donna[_2_]	by Jacob Skaria	3	314
How to copy a spreadsheet in shared workbook Kathie	by CellShocked	3	1,999
Excel 2007 Move or Copy worksheet lionking	by CellShocked	2	1,963
If..The Statement to automatically format a name G. B. Needs Excel Help	by Ron Rosenfeld	8	542
Apply Filter to source of Pivot Table frankie.lau	by frankie.lau	2	1,644
Sumproduct Subtotal Bec	by Jacob Skaria	1	437
Worksheet formula incorrect after copying to another worksheet Karen	by Karen	2	488
How can I count unique values Irelandabroad	by Herbert Seidenberg	7	455
How do I Undo a Page-Break in excel annie	by Jacob Skaria	1	1,027
Formula Referencing Columns By Date Rob	by Rob	2	439
Sorting a column that contains both text and numbers tstobb	by Dave Peterson	4	437
2003 Exxel possum b	by ryguy7272	1	307
Sort all columns based on one colum Greg	by Bernie Deitrick	3	1,280
Formula Count dates multiple criteria GPearson	by T. Valko	3	457
Multiple Criteria Date Count formula GPearson	by T. Valko	1	573
DCOUNT - date as a field only works when entered as a number jco	by jco	9	816
Lookup function Steve	by Steve	4	400
formula help Soth	by Glenn	6	659
histogram dynamic bin count tpeter	by tpeter	0	1,427
hyperlink to website and then to information in a certain cell Ernie[_2_]	by Ernie	6	720
Autofilter Rajiv	by ryguy7272	3	422
Conditional Formatting Help mjones	by Pete_UK	3	464
Add In vs functions Schedule Guy[_2_]	by Gord Dibben	2	454
Copy/paste data across filtered rows jday	by Peo Sjoblom[_3_]	1	1,886
INDIRECT Function Paul Moles	by Pete_UK	9	598
Removing check boxes (forms toolbar) jvs	by Jacob Skaria	1	526
Help with a formula in an excel 2007 worksheet. Stilmundu	by MRT	1	361