Excel Worksheet Functions - Page 1165

Thread / Thread Starter	Last Post	Replies	Views
Formula error Chris	by Chris	0	516
average, array and offsets Darin1979	by Darin1979	0	913
How do you calculate the nth root of a number in Excel 2003? William	by Frank Kabel	2	3,256
drop down help rob102_uk	by JulieD	1	485
Formula to reference column heading JimDandy	by Frank Kabel	1	2,334
Difference Miranda	by Frank Kabel	2	658
Create a formula that determines a date-sensitive File-Name from w stan-the-man	by stan-the-man	0	649
How can a UDF be called from a formula? GuyH	by GuyH	0	515
Finding the max of a column where values less than a specified number Mark Silka	by Paul Corrado	1	1,064
logical test - within a range esslingerdav	by LanceB	4	3,605
how to convert total hours (HH:MM) into decimal number Greg T	by Paul Corrado	1	4,730
Automatically insert fill colour when data is added? suzi	by LanceB	2	764
Freez in excell dummie	by dummie	3	507
DSum function Mark	by Mark	2	803
VALUE issue Pat	by Max	2	458
Automatically insert fill colours? suzi	by Frank Kabel	1	545
formulating if; then; enter list striker92s	by Max	2	510
Can you average data in 1 column based on a range of values in another? kman24	by R.VENKATARAMAN	2	2,243
Daily Macro to Download Data, Order and paste in order Iarla	by Don Guillett	1	2,234
how do i get rid of hidden apostrophes in cells? brokenmonkey	by SSHO_99	4	2,811
Where's the bug? Jim May	by Bob Phillips	1	370
#VALUE! issue Pat	by Max	1	514
If Statement possibly? Matt Brown via OfficeKB.com	by Arvi Laanemets	1	522
Nexsted if across 3 columns Felicity Geronimo	by Felicity Geronimo	4	991
better/faster way than sum products? alex	by alex	2	612
Sumif Help Please John	by ehntd	3	384
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	557
How do I convert the result of LARGE to the cell (or column) refe. Liam Judd	by Frank Kabel	1	749
Problem with LOOKUP & VLOOKUP ramsdesk	by ramsdesk	0	581
displaying formula result kalz	by kalz	4	704
To view different sheets using a drop down list Laila	by Micke	2	858
change operating cells dynamically according to the value of a fixed cell Zuohong	by Zuohong	2	939
How can I combine IF, COLUMN, and LARGE formulas in a single cell? Liam Judd	by Frank Kabel	1	1,126
Problem with LOOKUP & VLOOKUP ramsdesk	by Frank Kabel	1	779
How do I extract the last name in Excel, from a list of names lik. RobertC	by Frank Kabel	4	1,035
Template / date question macamarr	by Frank Kabel	1	634
Replace a sheetname with a cell reference to link to another work. lindaw2323	by Frank Kabel	1	821
How to populate formula in range of vertical cells to next colum Robert	by Robert	0	1,174
How do I create an "IF" statement with more than 7 levels? Jack of All Trades	by tjtjjtjt	1	808
Linking dates with a calendar... mcboots	by mcboots	2	695
How to change text in multiple cells from Uppercase to proper cas. Excel help	by R.VENKATARAMAN	1	1,762
How can I sort an entire spreadsheet from a list prod sorter	by Myrna Larson	4	2,405
Count and then average Al	by tjtjjtjt	4	555
I need help with a formula! SGT Banuelos	by Myrna Larson	2	391
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen	by akrr-rasmussen	1	2,300
how do you group and ungroup rows or columns in new Excel? moocowcreamer	by RagDyer	2	1,499
SUMIF with multi-column sum_range Kevin B	by Kevin B	2	793
Page break macro lehigh46	by lehigh46	2	926
How use group and ungroup functions while worksheet is protected Gabriel De la Garza	by George King	1	2,149
How do I make a formula for precentages? doddlebugger	by Gord Dibben	4	559
Is it possible to specify multiple condition with SUMIF? Daniel	by Kevin	1	939
how do I open an excel document chico1410	by Myrna Larson	1	905
Can I expand a drop down list? jlbreyer	by Debra Dalgleish	5	1,951
coloring issue TheKamel	by akrr-rasmussen	2	481
How do I round time? cpme	by Ron Rosenfeld	3	831
How do I write a formula to subtract a # from a total ONLY if the. JP	by Gord Dibben	2	904
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,303
Insert Leading Zeros hkslater	by Myrna Larson	7	1,091
How do I count my data that are between specific values? LDC	by Myrna Larson	3	724
Is it possible to do a conditional subtotal in Excel? LTS_Bgobien	by LTS_Bgobien	6	1,081
Controlling Linked Data to Workbooks Myrna	by Myrna	0	898
Totals based on dates DJ Dusty	by Domenic	1	726
need help using count if Lionheartilly	by Frank Kabel	1	366
How can I use SUMIF and AND to test for two conditons before summ. Neal	by Frank Kabel	1	475
how do i use the sumif function in non cons cells Kimbo	by Frank Kabel	1	540
Excel mjiverson121	by Frank Kabel	3	389
Auto-fill won't work spelunker64	by Frank Kabel	1	1,246
matching data formula? Todd	by Todd	1	808
How to resize a comment box, by embedding code into a function? JJ	by Debra Dalgleish	13	2,550
Formula Please Steved	by Steved	5	448
please help with timekeeping in excel Sicarii	by Sicarii	0	622
linking cells tricksydixie	by Gord Dibben	2	518
Hmmmm Upgrade Problem sh0t2bts	by Frank Kabel	1	396
Formula and Conditionl Formatting Help Phyliss	by Frank Kabel	3	686
Column #'s instead of letters in_detroit	by Don Guillett	2	498