Excel Worksheet Functions - Page 1165

Thread / Thread Starter	Last Post	Replies	Views
Formula error Chris	by Chris	0	528
average, array and offsets Darin1979	by Darin1979	0	961
How do you calculate the nth root of a number in Excel 2003? William	by Frank Kabel	2	3,315
drop down help rob102_uk	by JulieD	1	501
Formula to reference column heading JimDandy	by Frank Kabel	1	2,454
Difference Miranda	by Frank Kabel	2	698
Create a formula that determines a date-sensitive File-Name from w stan-the-man	by stan-the-man	0	687
How can a UDF be called from a formula? GuyH	by GuyH	0	518
Finding the max of a column where values less than a specified number Mark Silka	by Paul Corrado	1	1,102
logical test - within a range esslingerdav	by LanceB	4	3,639
how to convert total hours (HH:MM) into decimal number Greg T	by Paul Corrado	1	4,852
Automatically insert fill colour when data is added? suzi	by LanceB	2	798
Freez in excell dummie	by dummie	3	513
DSum function Mark	by Mark	2	829
VALUE issue Pat	by Max	2	478
Automatically insert fill colours? suzi	by Frank Kabel	1	580
formulating if; then; enter list striker92s	by Max	2	520
Can you average data in 1 column based on a range of values in another? kman24	by R.VENKATARAMAN	2	2,322
Daily Macro to Download Data, Order and paste in order Iarla	by Don Guillett	1	2,281
how do i get rid of hidden apostrophes in cells? brokenmonkey	by SSHO_99	4	2,837
Where's the bug? Jim May	by Bob Phillips	1	383
#VALUE! issue Pat	by Max	1	526
If Statement possibly? Matt Brown via OfficeKB.com	by Arvi Laanemets	1	535
Nexsted if across 3 columns Felicity Geronimo	by Felicity Geronimo	4	1,054
better/faster way than sum products? alex	by alex	2	630
Sumif Help Please John	by ehntd	3	399
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	584
How do I convert the result of LARGE to the cell (or column) refe. Liam Judd	by Frank Kabel	1	768
Problem with LOOKUP & VLOOKUP ramsdesk	by ramsdesk	0	601
displaying formula result kalz	by kalz	4	769
To view different sheets using a drop down list Laila	by Micke	2	872
change operating cells dynamically according to the value of a fixed cell Zuohong	by Zuohong	2	965
How can I combine IF, COLUMN, and LARGE formulas in a single cell? Liam Judd	by Frank Kabel	1	1,164
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	794
How do I extract the last name in Excel, from a list of names lik. RobertC	by Frank Kabel	4	1,064
Template / date question macamarr	by Frank Kabel	1	659
Replace a sheetname with a cell reference to link to another work. lindaw2323	by Frank Kabel	1	846
How to populate formula in range of vertical cells to next colum Robert	by Robert	0	1,201
How do I create an "IF" statement with more than 7 levels? Jack of All Trades	by tjtjjtjt	1	835
Linking dates with a calendar... mcboots	by mcboots	2	707
How to change text in multiple cells from Uppercase to proper cas. Excel help	by R.VENKATARAMAN	1	1,817
How can I sort an entire spreadsheet from a list prod sorter	by Myrna Larson	4	2,520
Count and then average Al	by tjtjjtjt	4	565
I need help with a formula! SGT Banuelos	by Myrna Larson	2	398
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen	by akrr-rasmussen	1	2,396
how do you group and ungroup rows or columns in new Excel? moocowcreamer	by RagDyer	2	1,534
SUMIF with multi-column sum_range Kevin B	by Kevin B	2	815
Page break macro lehigh46	by lehigh46	2	951
How use group and ungroup functions while worksheet is protected Gabriel De la Garza	by George King	1	2,193
How do I make a formula for precentages? doddlebugger	by Gord Dibben	4	570
Is it possible to specify multiple condition with SUMIF? Daniel	by Kevin	1	974
how do I open an excel document chico1410	by Myrna Larson	1	927
Can I expand a drop down list? jlbreyer	by Debra Dalgleish	5	2,000
coloring issue TheKamel	by akrr-rasmussen	2	489
How do I round time? cpme	by Ron Rosenfeld	3	856
How do I write a formula to subtract a # from a total ONLY if the. JP	by Gord Dibben	2	928
If I have X,Y data how do I sum the Y values using a set of bins based on x values ScottBerger	by Myrna Larson	1	1,335
Insert Leading Zeros hkslater	by Myrna Larson	7	1,108
How do I count my data that are between specific values? LDC	by Myrna Larson	3	749
Is it possible to do a conditional subtotal in Excel? LTS_Bgobien	by LTS_Bgobien	6	1,103
Controlling Linked Data to Workbooks Myrna	by Myrna	0	926
Totals based on dates DJ Dusty	by Domenic	1	749
need help using count if Lionheartilly	by Frank Kabel	1	372
How can I use SUMIF and AND to test for two conditons before summ. Neal	by Frank Kabel	1	489
how do i use the sumif function in non cons cells Kimbo	by Frank Kabel	1	555
Excel mjiverson121	by Frank Kabel	3	396
Auto-fill won't work spelunker64	by Frank Kabel	1	1,260
matching data formula? Todd	by Todd	1	837
How to resize a comment box, by embedding code into a function? JJ	by Debra Dalgleish	13	2,612
Formula Please Steved	by Steved	5	456
please help with timekeeping in excel Sicarii	by Sicarii	0	628
linking cells tricksydixie	by Gord Dibben	2	528
Hmmmm Upgrade Problem sh0t2bts	by Frank Kabel	1	407
Formula and Conditionl Formatting Help Phyliss	by Frank Kabel	3	713
Column #'s instead of letters in_detroit	by Don Guillett	2	515