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	403
Separate records from Vertical to Horizontal PM	by Gord Dibben	3	722
Depriciation Matrix Octavee Uhl	by Nigel Drinkwater	1	533
Calcualted Fields in Pivot Tables Nigel Drinkwater	by Kevin McCartney	1	484
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	978
sumif criteria DOE	by Dave Peterson	2	379
how to sort date in excel pusimani	by Cathy	2	1,018
Use networkdays INCLUDE weekends, Exclude holidays ronnomad	by ronnomad	4	2,175
Graphing error using Time as X axis. pete3589	by pete3589	2	746
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,330
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,127
Formula Needed... Steven Sinclair	by [email protected]	15	861
lookup pgc	by pgc	2	318
conditional data validation RickS	by RickS	6	881
How do I convert Meters to Feet and Inches? Dave S	by Niek Otten	7	1,392
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	715
Formula for determing average based on weighting John Sullivan	by [email protected]	2	793
If Statement and two metrics sony654	by sony654	5	537
Help with Formula,reulsts show in Function, not in Spreadsheet? Rowan Drummond	by Deb Pingel	1	560
How to use distribution functions? gpktm	by gpktm	3	530
grouping data Carl Hilton	by Max	3	473
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,436
If Statement Phyllis B.	by wjohnson	5	352
Please Help !!! BONJOVI2005	by Pete	1	331
Statistical smoothing a range of numbers - match average more clos Pasko1	by Mike Middleton	1	880
vlookup:same lookup_value, different returns Biff	by javino	2	622
Look for match on two worksheets roy.okinawa	by roy.okinawa	2	494
vlookup does not work between 71% to 79% refernceing roundup numb Glennrbt	by Glennrbt	4	1,044
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	891
Macro to open workbook and copy and paste values in to orig workbo Dena X	by Rowan Drummond	1	2,707
Data in cell to reference a worksheet page David Billigmeier	by eklarsen	2	562
Using Index(A:A,.........) Biff	by Biff	2	569
How do I change one repeated word in the spreadsheet to another? Largo	by wjohnson	5	5,145
Creating lookup formulas for material cost spreadsheet mn_tater	by Gord Dibben	5	907
sumproduct with 0/blank cells Matt	by Biff	4	925
"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,932
TAN different to a calculator? Please help would be appreciated lo !!HELP!!	by MrShorty	5	993
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	761
Add a number button jeanna	by jeanna	0	294
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	479
Nested IF statement with cell range reference Joe Spicer	by Biff	5	1,014
how to copy cells data in every 7th row? Jeff	by David Billigmeier	3	1,041
Combo box list w/ data in 2nd workbook without opening both files MHCPO	by MHCPO	0	562
=if returning 0 Jim	by Pete	4	430
XLSTART doesn't open PMW DB	by Dave Peterson	1	651
Floating Total Row Trying Hard	by Dave Peterson	1	924
No refresh in copied cell Auke	by Dave Peterson	1	407
link cell in 1 wk-sht to another & keep it regardless of sorting papabear0207	by Dave Peterson	1	424
Vlookup a column then a row macshimi	by Ron Coderre	1	361
Hide Fonts scott	by Gord Dibben	1	403
How do I copy subtotaled data without the underlying details? DBergesen	by Ron Coderre	1	718
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	380