Excel Worksheet Functions - Page 19

Thread / Thread Starter	Last Post	Replies	Views
How do I make a formula for precentages? doddlebugger	by Gord Dibben	4	554
How use group and ungroup functions while worksheet is protected Gabriel De la Garza	by George King	1	2,139
Page break macro lehigh46	by lehigh46	2	920
SUMIF with multi-column sum_range Kevin B	by Kevin B	2	790
how do you group and ungroup rows or columns in new Excel? moocowcreamer	by RagDyer	2	1,493
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen	by akrr-rasmussen	1	2,288
I need help with a formula! SGT Banuelos	by Myrna Larson	2	388
Count and then average Al	by tjtjjtjt	4	538
How can I sort an entire spreadsheet from a list prod sorter	by Myrna Larson	4	2,325
How to change text in multiple cells from Uppercase to proper cas. Excel help	by R.VENKATARAMAN	1	1,758
Linking dates with a calendar... mcboots	by mcboots	2	690
How do I create an "IF" statement with more than 7 levels? Jack of All Trades	by tjtjjtjt	1	804
How to populate formula in range of vertical cells to next colum Robert	by Robert	0	1,164
Replace a sheetname with a cell reference to link to another work. lindaw2323	by Frank Kabel	1	814
Template / date question macamarr	by Frank Kabel	1	624
How do I extract the last name in Excel, from a list of names lik. RobertC	by Frank Kabel	4	1,025
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	772
How can I combine IF, COLUMN, and LARGE formulas in a single cell? Liam Judd	by Frank Kabel	1	1,114
change operating cells dynamically according to the value of a fixed cell Zuohong	by Zuohong	2	936
To view different sheets using a drop down list Laila	by Micke	2	854
displaying formula result kalz	by kalz	4	700
Problem with LOOKUP & VLOOKUP ramsdesk	by ramsdesk	0	579
How do I convert the result of LARGE to the cell (or column) refe. Liam Judd	by Frank Kabel	1	741
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	548
Sumif Help Please John	by ehntd	3	367
better/faster way than sum products? alex	by alex	2	605
Nexsted if across 3 columns Felicity Geronimo	by Felicity Geronimo	4	981
If Statement possibly? Matt Brown via OfficeKB.com	by Arvi Laanemets	1	513
#VALUE! issue Pat	by Max	1	508
Where's the bug? Jim May	by Bob Phillips	1	370
how do i get rid of hidden apostrophes in cells? brokenmonkey	by SSHO_99	4	2,795
Daily Macro to Download Data, Order and paste in order Iarla	by Don Guillett	1	2,229
Can you average data in 1 column based on a range of values in another? kman24	by R.VENKATARAMAN	2	2,145
formulating if; then; enter list striker92s	by Max	2	503
Automatically insert fill colours? suzi	by Frank Kabel	1	539
VALUE issue Pat	by Max	2	453
DSum function Mark	by Mark	2	793
Freez in excell dummie	by dummie	3	504
Automatically insert fill colour when data is added? suzi	by LanceB	2	753
how to convert total hours (HH:MM) into decimal number Greg T	by Paul Corrado	1	4,624
logical test - within a range esslingerdav	by LanceB	4	3,596
Finding the max of a column where values less than a specified number Mark Silka	by Paul Corrado	1	1,047
How can a UDF be called from a formula? GuyH	by GuyH	0	509
Create a formula that determines a date-sensitive File-Name from w stan-the-man	by stan-the-man	0	644
Difference Miranda	by Frank Kabel	2	657
Formula to reference column heading JimDandy	by Frank Kabel	1	2,285
drop down help rob102_uk	by JulieD	1	482
How do you calculate the nth root of a number in Excel 2003? William	by Frank Kabel	2	3,238
average, array and offsets Darin1979	by Darin1979	0	907
Formula error Chris	by Chris	0	515
Listing of Sheet names Will Fleenor	by Norman Jones	1	695
How to auto-refresh Pivot data when open Excel file? Julie	by Myrna Larson	3	2,229
Data Filter - Not all rows in spreadsheet will display in Autofilt Excel Help	by Ron de Bruin	1	1,088
how do I use "inv sine" in a worksheet Elimits	by Bernie Deitrick	1	659
calculate percentages carlton	by JE McGimpsey	1	3,137
How to figure roots in Excel? Brion Kidder	by Bernard Liengme	3	1,273
how to move user defined function Grant	by Bernard Liengme	1	2,027
Nested Formula Jeannette	by Tim C	3	477
Help!: lead sheet data needs to fill appropriate subject sheets carebear	by carebear	0	1,151
Formula to make Excel count business days/skip weekends? Inga	by N Harkawat	1	2,024
Format Cell Colour scottymelloty	by Biff	2	807
what is the formula for changing the same cell on different sheet. scotty	by scotty	4	793
Calculate commissions Pete Petersen	by JE McGimpsey	6	1,078
looking up nearest value geooil	by geooil	0	371
Help with calculation Jim	by Jim	0	608
formula using both vlookup & hlookup xFreeAdvice	by xfreeadvice	2	1,006
Excel - option to extend function in cell to column kjoshua777	by Gord Dibben	2	2,470
Uppercase in a whole sheet Manu Palao	by Gord Dibben	4	552
formulating if; then; enter list striker92s	by Biff	1	583
change one sheet, and automatically the others Dummie	by Gord Dibben	1	597
how to increase the number by 1 from the cell above? the worker	by Gord Dibben	2	4,294
Inserting Multiple Rows with Formulas ShineboxNJ	by Dave Peterson	2	3,708
Weird wrapping in cell Meagnon	by Dave Peterson	2	701
How do I include cell data in subject line of email address/hyperl gvinnola	by Dave Peterson	1	1,253
how is possible working on work sheet by two person in the netwo. Ben	by Myrna Larson	1	863