Excel Worksheet Functions - Page 1094

Thread / Thread Starter	Last Post	Replies	Views
Last day of week Job	by Bob Phillips	5	953
EXCLUDE ADDRESSES IN A SERIES SUM viktaur	by JulieD	1	631
How to convert hours in days? Tony	by Jason Morin	3	789
How do I return a calculation based on several ranges? Nanci	by JulieD	5	584
VLookUp Tables Louise	by Bob Phillips	5	1,124
? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching??? _Bigred	by JulieD	10	902
How do I autocalculate a single number? Crystal7760	by JulieD	2	478
How do I find a column entry closest to a particular value feman007	by JulieD	2	1,161
How do I add another name to an existing table with formulas to w. Summer	by JulieD	3	643
how do I select unique dates from a database in Excel? pomalley	by JulieD	3	708
Excel lookup and calculation Spaz South Africa	by Peo Sjoblom	1	619
Listbox Question Greg B	by Dave Peterson	1	469
substituting two text occurances in same cell. Hassan Alameh	by Hassan Alameh	4	593
user defined function row number bj	by bj	11	1,773
How do I set up a stock control template? space gb limited	by space gb limited	0	954
Macro Question? Greg B	by Tom Ogilvy	7	667
If formulae using formats Paul	by CLR	2	388
adapt macro monty	by Bob Phillips	3	496
Minutes to Hours:minutes fredmunich	by fred	5	591
Excel 2003 V's Excel 2000? Ket	by Ket	2	1,133
i want to add a number to a date and get the date as an answer eg. traineeross	by Bob Phillips	2	803
Excel Formulas and formatting Helen	by Bob Phillips	3	502
Netting off to zero Gary T	by Gary T	0	498
One file splitted into worksheets Heine	by Heine	0	483
How do i sum vales of sales falling between certain time periods the_kane	by Ron Rosenfeld	6	826
Save sheet? Heine	by Heine	7	550
how can I select two different values for a cell? Parastoo Parto	by Bob Phillips	1	590
How do I set a formula that indicates a if a cell value changed? Zachie	by Bob Phillips	3	540
i need help with the "count" function kippercat	by Bob Phillips	1	571
Capital Letters Gaute	by Bob Phillips	4	912
rogue links appear in excel veally	by veally	0	618
Don't update excel links JacoH	by JacoH	2	1,224
Problems with the VLOOKUP formula Peter	by Michael	2	665
CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS Jon re Excel	by Ron Rosenfeld	2	1,497
How do I replace a negative number with zero Laura@Gage	by Max	4	654
Count the number of dates in a range that are earlier than today. DeborahS	by CLR	1	1,237
can anyone help with times not coming across correctly in pivot t. [email protected]	by [email protected]	0	489
can anyone help with times not coming across correctly in pivot t. [email protected]	by [email protected]	0	697
PMT 30/365 vs 30/360 Will	by Fred Smith	1	1,565
Excel workbook fails to display when selecting from my documents. 4jjgolly	by Gord Dibben	1	1,041
Listbox Question Greg B	by Greg B	0	496
Frequency of occurence Danny J	by CLR	1	536
Highlight a row if a specific cell is specific numbers/words sea0221	by Gord Dibben	2	2,549
excell bogwald	by Gord Dibben	3	479
Return answer if..... Pat	by Fredrik Wahlgren	3	628
Excel should display tabs on multiple rows Kevin M	by Kevin M	6	1,578
Count Rows with two criteria Eli Waite	by Bob Phillips	3	582
how do I get lookup to work Grant	by Grant	3	441
How can Excel do daily timesheet, -lunch time, & not use colon in. Jan	by Jan	2	1,477
Return lowest quantity Pat	by Pat	2	710
formula for workbook showing daily income compared to goal income. tittytatbratt	by tittytatbratt	2	1,122
Bernie My New Macro JulianB	by Dave Peterson	1	472
How do I make the fill color of a cell on one sheet follow the co. SteelerfanDan	by Debra Dalgleish	2	768
Pivot tables - Fonts etc Natalie	by Debra Dalgleish	1	469
troubleshoot custom Excel Auto Filters when the column is a # or d MEM	by Debra Dalgleish	1	912
Counting Letters Gaute Hasti	by Bob Phillips	5	619
MSExcel--words in a cell separated by comma need to be moved into. Gary in Alaska	by Erin	2	646
How do you calc half day annual leave on a xls spread sheet using. RGayle_Imperial	by Jason Morin	5	2,561
Lookup Type Question carl	by Jason Morin	1	541
sort dates by month and day not year dianne	by Arvi Laanemets	2	870
Trouble opening an Excel file that contains macros JohnR	by Don Guillett	1	1,522
header footer M&A_Jack	by Paul B	1	606
Hide part of Pivot Table Ben	by dave	1	1,722
Need to find the right-most cell value in a string of cells -dc-	by Domenic	2	2,455
Subtotal seem slower in Excel 2003 ruffnro	by ruffnro	0	529
What is the keyboard shortcut for parentheses? jstewart46	by Jonathan Rynd	8	4,123
count duplicate (or, inversely, unique) entries, but based on a condition markx	by Wazooli	3	1,757
viewing seperate data within worksheet Gate	by Roger H.	1	431
Add asterisk to excel cell jblack35	by Bob Tarburton	1	1,810
conditional formating of group of columns and rows Madhav	by Madhav	0	784
pivot table logical calculation Spencer Hutton	by Spencer Hutton	0	495
How do I recover a file, with info, that I did'nt Save? JulianB	by	1	485
Please how do do this in vba Steved	by Steved	12	1,016
VLookup Function MacNut	by Arvi Laanemets	5	382
web query for Excel QLS_KIM	by QLS_KIM	0	526