Excel Worksheet Functions - Page 388

Thread / Thread Starter	Last Post	Replies	Views
How do i make a sum formula ignore #div/0! errors in the range shat	by AG	6	2,322
Calculating Dates Using Different Values for NETWORKDAYS Kelly	by Bob Phillips	9	716
calculate days JR	by Curt	4	540
Auto calculate for date + days forward to yield new date John Sullivan	by Otto Moehrbach	1	3,804
How do I copy only values of cells when they are enterd? Nakeeb	by Otto Moehrbach	1	404
How do I create a tip calculator chart? Sandpigg	by Otto Moehrbach	1	1,922
sumproduct doesn't work Bonkers	by Bonkers	9	795
If function Yvonne	by Yvonne	2	347
Using the answer IF "true" in another formula? Yvonne	by Yvonne	1	357
how can I add a picture into protected worksheet? Chusena	by Hernandez, Roberto	1	860
Inserting new rows max	by Herbert Seidenberg	3	581
engineering functions isa982	by [email protected]	3	621
Could any one Explain this Formula John	by Biff	8	528
FIFA World Cup 2006 Office Pool Sibwhistle	by Sibwhistle	3	1,095
How to create a 'dynamic' formula? Bill	by Ragdyer	11	764
Conditional Formatting Q John	by John	5	428
can i prevent duplications in cells Jackie	by Gord Dibben	6	774
Zero Values in Charts Stilla	by Stilla	3	629
Add items to context menu Fred Jacobowitz	by Dave Peterson	1	840
Change hrs&minutes into mins Indie	by Bob Phillips	4	385
Multi-Column Dynamic Named Range...Is there an easier way? Ken Johnson	by Ken Johnson	6	1,643
copy value of cell from last entry in column Jay Trull	by Paul B	1	812
VLOOKUP Returns Erroneous Value When Control Data is Variable The Hawk	by Biff	5	562
I want any date 90 days or older from current date change color Big Abalone	by Ragdyer	5	1,477
Simultaneously updating Charts in Multiple sheets J Shrimps, Jr.	by Jim Cone	1	672
merge 2 spreadsheets info to 1 JulesVern	by broro183	1	732
Dont include in sum if cell contains this value exutable	by Ragdyer	3	1,400
Take fraction out of the figure 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	3	462
Formula not Return Required Answer Q John	by John	1	696
Chop off parts of the statement 0-0 Wai Wai ^-^	by Niek Otten	1	439
Dialog box with worksheet information Raza	by Bob Phillips	3	340
Average Non-Adjacent Cells in Budget Spreadsheet OPB3	by Aladin Akyurek	5	1,165
Transfer data relevent to date KandK	by Ron de Bruin	1	432
Transfer only information under todays date KandK	by Ron de Bruin	1	418
Fill in Date problem Lisa	by Bryan Hessey	4	306
Subsequence of characters paulinoluciano	by Dave Peterson	5	354
Invalid Formula with the use of Indirect 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	5	495
I want data to show in the cell only when the info is inserted Rebecca	by davesexcel	1	337
How do I get a combo box to calculate percentages in Excel? Pattid175	by davesexcel	4	786
Deriving mathematical equations damo	by David J. Braden	1	551
retrieving old messages from this newsgroup T Harris	by PY & Associates	3	309
How to best monitor threads on this site John James	by Dave Peterson	13	1,068
Transferring contents and color of cell Les	by Dave Peterson	3	383
Automatic filtering and coping result to a seperate sheet Richard P	by Richard P	2	399
Oooh, I guarantee you are going to have fun with this one. Clueless	by Ragdyer	6	327
filtering via135	by via135	11	834
lookup value and return result in column to left Mark M	by Ragdyer	3	932
shortcut key to move to beginning of new row bob engler	by Ragdyer	2	648
Splitting firstName from Surname Althea	by Althea	5	671
Conditional Formatting JohnGuts	by JohnGuts	2	363
Removing The N/A from showing in open fields Killer	by Aladin Akyurek	5	356
how to catch the second or more cell with vlookup Valley	by Ken Johnson	8	681
need formula advice CdnMichael	by Gord Dibben	1	360
can we convert "2 days 16 hrs" to " 64hrs" using excel functions chris	by Fred Smith	5	1,323
listing data without blank rows Shooter	by Dannycol	17	1,885
Excel Coding Error! Killer	by Ragdyer	9	562
Excel sheet scroll bar options Donna	by Donna	5	1,186
Timesheet MyKidsBank	by Biff	1	479
Normal Text in Formula exutable	by Arvi Laanemets	4	410
counting problems Metolius Dad	by JMB	1	291
Auto Filter with Protected Worksheet JohnGuts	by broro183	4	766
Last non-blank cell in a row? Tasos	by Tasos	2	342
Linking sheets into one major sheet? Ellymoo	by Ellymoo	8	799
How to use a very big formula Revathi	by Martin	1	331
HOW TO PREPARE SUMMARY OF DIFFERENT ITEMS IN ANOTHER WORKSHEET? Viswanathan Balaji	by Viswanathan Balaji	0	534
Hide used names in drop downbox. Robb27	by Robb27	13	1,145
to compare sales plan vs actuals from two different worksheets? Prabhu Gowda	by Prabhu Gowda	0	696
Create a conditional formula to replace dot	by Pete_UK	2	430
Speed up calculation of a worksheet that contains formula vennila	by Pete_UK	2	661
how can i recover an old saved spreadsheet VDTCJT	by VDTCJT	3	905
calculation to ignore a 0 (zero) value seedy3	by seedy3	3	977
Change font/cell color by Formula exutable	by Otto Moehrbach	4	940
Use VLookup for range of cells, but with a twist [email protected]	by xlbo	1	403
VLookup across Workbooks? PH NEWS	by PH NEWS	0	791
transposing question... cherrynich	by cherrynich	2	412