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,135
Help Please-Counting Filtered Rows baz	by baz	2	416
Separate records from Vertical to Horizontal PM	by Gord Dibben	3	751
Depriciation Matrix Octavee Uhl	by Nigel Drinkwater	1	543
Calcualted Fields in Pivot Tables Nigel Drinkwater	by Kevin McCartney	1	497
Nett Date Calculation Midas NDT Sales	by Midas NDT Sales	4	456
how to cover the formula Lawrence	by Gord Dibben	7	676
TOTAL NUMBER OF ENTRIES rostroncarlyle	by Gord Dibben	5	453
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	388
how to sort date in excel pusimani	by Cathy	2	1,055
Use networkdays INCLUDE weekends, Exclude holidays ronnomad	by ronnomad	4	2,190
Graphing error using Time as X axis. pete3589	by pete3589	2	765
Cell Reference hydro1guy	by Peo Sjoblom	5	319
Pivot table displays data differently, Excel 2003 Perkyleo	by Nigel Drinkwater	1	723
What is the formula for blinking a cell with a value in Excel SN	by Satyanadh Kolluri	2	1,340
How do I change the font color based on results of an IF stateme MKLeisure	by MKLeisure	2	871
How to auto activate macro when file open ? bonzio	by Ken Johnson	1	1,143
Formula Needed... Steven Sinclair	by [email protected]	15	875
lookup pgc	by pgc	2	329
conditional data validation RickS	by RickS	6	890
How do I convert Meters to Feet and Inches? Dave S	by Niek Otten	7	1,421
Lookup (multiple variables) stevenpwhite	by stevenpwhite	2	810
Look for values on another sheet. Spanky77	by Norman Jones	1	408
Excel Formula - Reg Muralidhar.L	by Max	1	483
ISNUM ???? R-P	by R-P	7	743
Formula for determing average based on weighting John Sullivan	by [email protected]	2	815
If Statement and two metrics sony654	by sony654	5	551
Help with Formula,reulsts show in Function, not in Spreadsheet? Rowan Drummond	by Deb Pingel	1	573
How to use distribution functions? gpktm	by gpktm	3	569
grouping data Carl Hilton	by Max	3	495
Trend Line constants Ken	by Jerry W. Lewis	2	493
how to write function to find max deviation from specific number . barbdee	by Jerry W. Lewis	2	3,469
If Statement Phyllis B.	by wjohnson	5	362
Please Help !!! BONJOVI2005	by Pete	1	336
Statistical smoothing a range of numbers - match average more clos Pasko1	by Mike Middleton	1	902
vlookup:same lookup_value, different returns Biff	by javino	2	639
Look for match on two worksheets roy.okinawa	by roy.okinawa	2	561
vlookup does not work between 71% to 79% refernceing roundup numb Glennrbt	by Glennrbt	4	1,063
Macro Help Needy Novice	by Dave Peterson	3	450
need to count/average if... Need Help 123	by Need Help 123	6	642
How to run a macro as soon a a workbook (.xls) is opened? Sangamesh Acharya	by Rowan Drummond	1	935
Macro to open workbook and copy and paste values in to orig workbo Dena X	by Rowan Drummond	1	2,793
Data in cell to reference a worksheet page David Billigmeier	by eklarsen	2	573
Using Index(A:A,.........) Biff	by Biff	2	585
How do I change one repeated word in the spreadsheet to another? Largo	by wjohnson	5	5,216
Creating lookup formulas for material cost spreadsheet mn_tater	by Gord Dibben	5	935
sumproduct with 0/blank cells Matt	by Biff	4	941
"Cumulative" column based on a pivot table sum column? Robert Day	by Robert Day	2	2,275
How do I keep border permenant in a worksheet template? LostInVegas	by Gord Dibben	3	895
How do I protect hidden rows from being unhidden? Pam P	by Gord Dibben	5	1,972
TAN different to a calculator? Please help would be appreciated lo !!HELP!!	by MrShorty	5	1,028
hidden worksheet? davem	by davem	0	387
Excel formula-cell reference not working pbog	by pbog	3	1,559
Inserting a string seach within a complex function DJ_Swammi	by DJ_Swammi	3	475
Is there a way to lock two or more rows together? christy	by Gord Dibben	2	562
Is it possible to insert a picture using formulas? phil2401	by phil2401	4	795
Add a number button jeanna	by jeanna	0	299
Anyway to set numerical column name as Exel convention? Frank Cao	by Frank Cao	4	972
How do I build a reference to an external worksheet? Alexsalles	by Biff	3	488
Nested IF statement with cell range reference Joe Spicer	by Biff	5	1,047
how to copy cells data in every 7th row? Jeff	by David Billigmeier	3	1,091
Combo box list w/ data in 2nd workbook without opening both files MHCPO	by MHCPO	0	588
=if returning 0 Jim	by Pete	4	438
XLSTART doesn't open PMW DB	by Dave Peterson	1	667
Floating Total Row Trying Hard	by Dave Peterson	1	939
No refresh in copied cell Auke	by Dave Peterson	1	414
link cell in 1 wk-sht to another & keep it regardless of sorting papabear0207	by Dave Peterson	1	438
Vlookup a column then a row macshimi	by Ron Coderre	1	371
Hide Fonts scott	by Gord Dibben	1	410
How do I copy subtotaled data without the underlying details? DBergesen	by Ron Coderre	1	753
change cell size from page to page on the same worksheet Danny	by Gord Dibben	2	1,995
Sumproduct: Formula is finicky Mike C	by Mike C	4	654
COUNT OR SUM OR IF? CHRIS K	by CHRIS K	7	400
Formula Help Frick	by Sandy Mann	7	393