Excel Worksheet Functions - Page 900

Thread / Thread Starter	Last Post	Replies	Views
EXCEL.SUM OF DIFFERENT COLUMS AND LINES ON DIFFERENT SHEET REPEAT mark d davis	by Ron Coderre	6	1,118
Help Please-Counting Filtered Rows baz	by baz	2	399
Separate records from Vertical to Horizontal PM	by Gord Dibben	3	722
Depriciation Matrix Octavee Uhl	by Nigel Drinkwater	1	531
Calcualted Fields in Pivot Tables Nigel Drinkwater	by Kevin McCartney	1	480
Nett Date Calculation Midas NDT Sales	by Midas NDT Sales	4	438
how to cover the formula Lawrence	by Gord Dibben	7	662
TOTAL NUMBER OF ENTRIES rostroncarlyle	by Gord Dibben	5	448
How to lock a row in a spreadsheet based on the value in a cell Prasad	by Debra Dalgleish	3	967
sumif criteria DOE	by Dave Peterson	2	377
how to sort date in excel pusimani	by Cathy	2	1,014
Use networkdays INCLUDE weekends, Exclude holidays ronnomad	by ronnomad	4	2,171
Graphing error using Time as X axis. pete3589	by pete3589	2	742
Cell Reference hydro1guy	by Peo Sjoblom	5	301
Pivot table displays data differently, Excel 2003 Perkyleo	by Nigel Drinkwater	1	692
What is the formula for blinking a cell with a value in Excel SN	by Satyanadh Kolluri	2	1,329
How do I change the font color based on results of an IF stateme MKLeisure	by MKLeisure	2	810
How to auto activate macro when file open ? bonzio	by Ken Johnson	1	1,126
Formula Needed... Steven Sinclair	by [email protected]	15	860
lookup pgc	by pgc	2	318
conditional data validation RickS	by RickS	6	878
How do I convert Meters to Feet and Inches? Dave S	by Niek Otten	7	1,388
Lookup (multiple variables) stevenpwhite	by stevenpwhite	2	788
Look for values on another sheet. Spanky77	by Norman Jones	1	397
Excel Formula - Reg Muralidhar.L	by Max	1	474
ISNUM ???? R-P	by R-P	7	707
Formula for determing average based on weighting John Sullivan	by [email protected]	2	793
If Statement and two metrics sony654	by sony654	5	536
Help with Formula,reulsts show in Function, not in Spreadsheet? Rowan Drummond	by Deb Pingel	1	557
How to use distribution functions? gpktm	by gpktm	3	520
grouping data Carl Hilton	by Max	3	469
Trend Line constants Ken	by Jerry W. Lewis	2	465
how to write function to find max deviation from specific number . barbdee	by Jerry W. Lewis	2	3,431
If Statement Phyllis B.	by wjohnson	5	347
Please Help !!! BONJOVI2005	by Pete	1	327
Statistical smoothing a range of numbers - match average more clos Pasko1	by Mike Middleton	1	879
vlookup:same lookup_value, different returns Biff	by javino	2	622
Look for match on two worksheets roy.okinawa	by roy.okinawa	2	493
vlookup does not work between 71% to 79% refernceing roundup numb Glennrbt	by Glennrbt	4	1,040
Macro Help Needy Novice	by Dave Peterson	3	442
need to count/average if... Need Help 123	by Need Help 123	6	631
How to run a macro as soon a a workbook (.xls) is opened? Sangamesh Acharya	by Rowan Drummond	1	886
Macro to open workbook and copy and paste values in to orig workbo Dena X	by Rowan Drummond	1	2,705
Data in cell to reference a worksheet page David Billigmeier	by eklarsen	2	558
Using Index(A:A,.........) Biff	by Biff	2	567
How do I change one repeated word in the spreadsheet to another? Largo	by wjohnson	5	5,137
Creating lookup formulas for material cost spreadsheet mn_tater	by Gord Dibben	5	904
sumproduct with 0/blank cells Matt	by Biff	4	921
"Cumulative" column based on a pivot table sum column? Robert Day	by Robert Day	2	2,230
How do I keep border permenant in a worksheet template? LostInVegas	by Gord Dibben	3	847
How do I protect hidden rows from being unhidden? Pam P	by Gord Dibben	5	1,927
TAN different to a calculator? Please help would be appreciated lo !!HELP!!	by MrShorty	5	989
hidden worksheet? davem	by davem	0	370
Excel formula-cell reference not working pbog	by pbog	3	1,548
Inserting a string seach within a complex function DJ_Swammi	by DJ_Swammi	3	467
Is there a way to lock two or more rows together? christy	by Gord Dibben	2	553
Is it possible to insert a picture using formulas? phil2401	by phil2401	4	753
Add a number button jeanna	by jeanna	0	293
Anyway to set numerical column name as Exel convention? Frank Cao	by Frank Cao	4	962
How do I build a reference to an external worksheet? Alexsalles	by Biff	3	478
Nested IF statement with cell range reference Joe Spicer	by Biff	5	1,013
how to copy cells data in every 7th row? Jeff	by David Billigmeier	3	1,040
Combo box list w/ data in 2nd workbook without opening both files MHCPO	by MHCPO	0	560
=if returning 0 Jim	by Pete	4	430
XLSTART doesn't open PMW DB	by Dave Peterson	1	650
Floating Total Row Trying Hard	by Dave Peterson	1	923
No refresh in copied cell Auke	by Dave Peterson	1	406
link cell in 1 wk-sht to another & keep it regardless of sorting papabear0207	by Dave Peterson	1	417
Vlookup a column then a row macshimi	by Ron Coderre	1	361
Hide Fonts scott	by Gord Dibben	1	402
How do I copy subtotaled data without the underlying details? DBergesen	by Ron Coderre	1	717
change cell size from page to page on the same worksheet Danny	by Gord Dibben	2	1,917
Sumproduct: Formula is finicky Mike C	by Mike C	4	642
COUNT OR SUM OR IF? CHRIS K	by CHRIS K	7	395
Formula Help Frick	by Sandy Mann	7	378