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	558
How use group and ungroup functions while worksheet is protected Gabriel De la Garza	by George King	1	2,147
Page break macro lehigh46	by lehigh46	2	925
SUMIF with multi-column sum_range Kevin B	by Kevin B	2	791
how do you group and ungroup rows or columns in new Excel? moocowcreamer	by RagDyer	2	1,497
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen	by akrr-rasmussen	1	2,296
I need help with a formula! SGT Banuelos	by Myrna Larson	2	388
Count and then average Al	by tjtjjtjt	4	548
How can I sort an entire spreadsheet from a list prod sorter	by Myrna Larson	4	2,378
How to change text in multiple cells from Uppercase to proper cas. Excel help	by R.VENKATARAMAN	1	1,759
Linking dates with a calendar... mcboots	by mcboots	2	691
How do I create an "IF" statement with more than 7 levels? Jack of All Trades	by tjtjjtjt	1	808
How to populate formula in range of vertical cells to next colum Robert	by Robert	0	1,170
Replace a sheetname with a cell reference to link to another work. lindaw2323	by Frank Kabel	1	815
Template / date question macamarr	by Frank Kabel	1	628
How do I extract the last name in Excel, from a list of names lik. RobertC	by Frank Kabel	4	1,031
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	776
How can I combine IF, COLUMN, and LARGE formulas in a single cell? Liam Judd	by Frank Kabel	1	1,121
change operating cells dynamically according to the value of a fixed cell Zuohong	by Zuohong	2	938
To view different sheets using a drop down list Laila	by Micke	2	858
displaying formula result kalz	by kalz	4	702
Problem with LOOKUP & VLOOKUP ramsdesk	by ramsdesk	0	580
How do I convert the result of LARGE to the cell (or column) refe. Liam Judd	by Frank Kabel	1	743
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	551
Sumif Help Please John	by ehntd	3	376
better/faster way than sum products? alex	by alex	2	607
Nexsted if across 3 columns Felicity Geronimo	by Felicity Geronimo	4	982
If Statement possibly? Matt Brown via OfficeKB.com	by Arvi Laanemets	1	515
#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,801
Daily Macro to Download Data, Order and paste in order Iarla	by Don Guillett	1	2,234
Can you average data in 1 column based on a range of values in another? kman24	by R.VENKATARAMAN	2	2,220
formulating if; then; enter list striker92s	by Max	2	504
Automatically insert fill colours? suzi	by Frank Kabel	1	540
VALUE issue Pat	by Max	2	454
DSum function Mark	by Mark	2	798
Freez in excell dummie	by dummie	3	506
Automatically insert fill colour when data is added? suzi	by LanceB	2	760
how to convert total hours (HH:MM) into decimal number Greg T	by Paul Corrado	1	4,687
logical test - within a range esslingerdav	by LanceB	4	3,601
Finding the max of a column where values less than a specified number Mark Silka	by Paul Corrado	1	1,055
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	649
Difference Miranda	by Frank Kabel	2	658
Formula to reference column heading JimDandy	by Frank Kabel	1	2,308
drop down help rob102_uk	by JulieD	1	483
How do you calculate the nth root of a number in Excel 2003? William	by Frank Kabel	2	3,245
average, array and offsets Darin1979	by Darin1979	0	913
Formula error Chris	by Chris	0	515
Listing of Sheet names Will Fleenor	by Norman Jones	1	696
How to auto-refresh Pivot data when open Excel file? Julie	by Myrna Larson	3	2,236
Data Filter - Not all rows in spreadsheet will display in Autofilt Excel Help	by Ron de Bruin	1	1,092
how do I use "inv sine" in a worksheet Elimits	by Bernie Deitrick	1	664
calculate percentages carlton	by JE McGimpsey	1	3,138
How to figure roots in Excel? Brion Kidder	by Bernard Liengme	3	1,275
how to move user defined function Grant	by Bernard Liengme	1	2,031
Nested Formula Jeannette	by Tim C	3	478
Help!: lead sheet data needs to fill appropriate subject sheets carebear	by carebear	0	1,156
Formula to make Excel count business days/skip weekends? Inga	by N Harkawat	1	2,028
Format Cell Colour scottymelloty	by Biff	2	808
what is the formula for changing the same cell on different sheet. scotty	by scotty	4	794
Calculate commissions Pete Petersen	by JE McGimpsey	6	1,083
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,016
Excel - option to extend function in cell to column kjoshua777	by Gord Dibben	2	2,495
Uppercase in a whole sheet Manu Palao	by Gord Dibben	4	553
formulating if; then; enter list striker92s	by Biff	1	585
change one sheet, and automatically the others Dummie	by Gord Dibben	1	621
how to increase the number by 1 from the cell above? the worker	by Gord Dibben	2	4,468
Inserting Multiple Rows with Formulas ShineboxNJ	by Dave Peterson	2	3,864
Weird wrapping in cell Meagnon	by Dave Peterson	2	718
How do I include cell data in subject line of email address/hyperl gvinnola	by Dave Peterson	1	1,255
how is possible working on work sheet by two person in the netwo. Ben	by Myrna Larson	1	865