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,134
Help Please-Counting Filtered Rows baz	by baz	2	414
Separate records from Vertical to Horizontal PM	by Gord Dibben	3	747
Depriciation Matrix Octavee Uhl	by Nigel Drinkwater	1	542
Calcualted Fields in Pivot Tables Nigel Drinkwater	by Kevin McCartney	1	494
Nett Date Calculation Midas NDT Sales	by Midas NDT Sales	4	454
how to cover the formula Lawrence	by Gord Dibben	7	676
TOTAL NUMBER OF ENTRIES rostroncarlyle	by Gord Dibben	5	452
How to lock a row in a spreadsheet based on the value in a cell Prasad	by Debra Dalgleish	3	987
sumif criteria DOE	by Dave Peterson	2	386
how to sort date in excel pusimani	by Cathy	2	1,043
Use networkdays INCLUDE weekends, Exclude holidays ronnomad	by ronnomad	4	2,190
Graphing error using Time as X axis. pete3589	by pete3589	2	761
Cell Reference hydro1guy	by Peo Sjoblom	5	312
Pivot table displays data differently, Excel 2003 Perkyleo	by Nigel Drinkwater	1	714
What is the formula for blinking a cell with a value in Excel SN	by Satyanadh Kolluri	2	1,338
How do I change the font color based on results of an IF stateme MKLeisure	by MKLeisure	2	832
How to auto activate macro when file open ? bonzio	by Ken Johnson	1	1,140
Formula Needed... Steven Sinclair	by [email protected]	15	874
lookup pgc	by pgc	2	328
conditional data validation RickS	by RickS	6	889
How do I convert Meters to Feet and Inches? Dave S	by Niek Otten	7	1,413
Lookup (multiple variables) stevenpwhite	by stevenpwhite	2	809
Look for values on another sheet. Spanky77	by Norman Jones	1	404
Excel Formula - Reg Muralidhar.L	by Max	1	481
ISNUM ???? R-P	by R-P	7	741
Formula for determing average based on weighting John Sullivan	by [email protected]	2	812
If Statement and two metrics sony654	by sony654	5	547
Help with Formula,reulsts show in Function, not in Spreadsheet? Rowan Drummond	by Deb Pingel	1	572
How to use distribution functions? gpktm	by gpktm	3	568
grouping data Carl Hilton	by Max	3	494
Trend Line constants Ken	by Jerry W. Lewis	2	486
how to write function to find max deviation from specific number . barbdee	by Jerry W. Lewis	2	3,462
If Statement Phyllis B.	by wjohnson	5	359
Please Help !!! BONJOVI2005	by Pete	1	335
Statistical smoothing a range of numbers - match average more clos Pasko1	by Mike Middleton	1	900
vlookup:same lookup_value, different returns Biff	by javino	2	637
Look for match on two worksheets roy.okinawa	by roy.okinawa	2	512
vlookup does not work between 71% to 79% refernceing roundup numb Glennrbt	by Glennrbt	4	1,062
Macro Help Needy Novice	by Dave Peterson	3	447
need to count/average if... Need Help 123	by Need Help 123	6	640
How to run a macro as soon a a workbook (.xls) is opened? Sangamesh Acharya	by Rowan Drummond	1	930
Macro to open workbook and copy and paste values in to orig workbo Dena X	by Rowan Drummond	1	2,741
Data in cell to reference a worksheet page David Billigmeier	by eklarsen	2	572
Using Index(A:A,.........) Biff	by Biff	2	580
How do I change one repeated word in the spreadsheet to another? Largo	by wjohnson	5	5,214
Creating lookup formulas for material cost spreadsheet mn_tater	by Gord Dibben	5	934
sumproduct with 0/blank cells Matt	by Biff	4	940
"Cumulative" column based on a pivot table sum column? Robert Day	by Robert Day	2	2,253
How do I keep border permenant in a worksheet template? LostInVegas	by Gord Dibben	3	861
How do I protect hidden rows from being unhidden? Pam P	by Gord Dibben	5	1,971
TAN different to a calculator? Please help would be appreciated lo !!HELP!!	by MrShorty	5	1,025
hidden worksheet? davem	by davem	0	383
Excel formula-cell reference not working pbog	by pbog	3	1,557
Inserting a string seach within a complex function DJ_Swammi	by DJ_Swammi	3	474
Is there a way to lock two or more rows together? christy	by Gord Dibben	2	560
Is it possible to insert a picture using formulas? phil2401	by phil2401	4	773
Add a number button jeanna	by jeanna	0	297
Anyway to set numerical column name as Exel convention? Frank Cao	by Frank Cao	4	969
How do I build a reference to an external worksheet? Alexsalles	by Biff	3	486
Nested IF statement with cell range reference Joe Spicer	by Biff	5	1,032
how to copy cells data in every 7th row? Jeff	by David Billigmeier	3	1,087
Combo box list w/ data in 2nd workbook without opening both files MHCPO	by MHCPO	0	584
=if returning 0 Jim	by Pete	4	436
XLSTART doesn't open PMW DB	by Dave Peterson	1	664
Floating Total Row Trying Hard	by Dave Peterson	1	937
No refresh in copied cell Auke	by Dave Peterson	1	413
link cell in 1 wk-sht to another & keep it regardless of sorting papabear0207	by Dave Peterson	1	437
Vlookup a column then a row macshimi	by Ron Coderre	1	369
Hide Fonts scott	by Gord Dibben	1	408
How do I copy subtotaled data without the underlying details? DBergesen	by Ron Coderre	1	750
change cell size from page to page on the same worksheet Danny	by Gord Dibben	2	1,946
Sumproduct: Formula is finicky Mike C	by Mike C	4	654
COUNT OR SUM OR IF? CHRIS K	by CHRIS K	7	399
Formula Help Frick	by Sandy Mann	7	391