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	788
How do I return a calculation based on several ranges? Nanci	by JulieD	5	583
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,147
How do I add another name to an existing table with formulas to w. Summer	by JulieD	3	641
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	573
Listbox Question Greg B	by Dave Peterson	1	468
substituting two text occurances in same cell. Hassan Alameh	by Hassan Alameh	4	580
user defined function row number bj	by bj	11	1,767
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	665
If formulae using formats Paul	by CLR	2	387
adapt macro monty	by Bob Phillips	3	494
Minutes to Hours:minutes fredmunich	by fred	5	590
Excel 2003 V's Excel 2000? Ket	by Ket	2	1,110
i want to add a number to a date and get the date as an answer eg. traineeross	by Bob Phillips	2	789
Excel Formulas and formatting Helen	by Bob Phillips	3	496
Netting off to zero Gary T	by Gary T	0	497
One file splitted into worksheets Heine	by Heine	0	481
How do i sum vales of sales falling between certain time periods the_kane	by Ron Rosenfeld	6	825
Save sheet? Heine	by Heine	7	548
how can I select two different values for a cell? Parastoo Parto	by Bob Phillips	1	589
How do I set a formula that indicates a if a cell value changed? Zachie	by Bob Phillips	3	537
i need help with the "count" function kippercat	by Bob Phillips	1	568
Capital Letters Gaute	by Bob Phillips	4	907
rogue links appear in excel veally	by veally	0	616
Don't update excel links JacoH	by JacoH	2	1,176
Problems with the VLOOKUP formula Peter	by Michael	2	660
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	653
Count the number of dates in a range that are earlier than today. DeborahS	by CLR	1	1,232
can anyone help with times not coming across correctly in pivot t. [email protected]	by [email protected]	0	487
can anyone help with times not coming across correctly in pivot t. [email protected]	by [email protected]	0	696
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,034
Listbox Question Greg B	by Greg B	0	495
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,488
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,573
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,472
Return lowest quantity Pat	by Pat	2	709
formula for workbook showing daily income compared to goal income. tittytatbratt	by tittytatbratt	2	1,101
Bernie My New Macro JulianB	by Dave Peterson	1	470
How do I make the fill color of a cell on one sheet follow the co. SteelerfanDan	by Debra Dalgleish	2	763
Pivot tables - Fonts etc Natalie	by Debra Dalgleish	1	467
troubleshoot custom Excel Auto Filters when the column is a # or d MEM	by Debra Dalgleish	1	907
Counting Letters Gaute Hasti	by Bob Phillips	5	607
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	538
sort dates by month and day not year dianne	by Arvi Laanemets	2	869
Trouble opening an Excel file that contains macros JohnR	by Don Guillett	1	1,520
header footer M&A_Jack	by Paul B	1	604
Hide part of Pivot Table Ben	by dave	1	1,708
Need to find the right-most cell value in a string of cells -dc-	by Domenic	2	2,453
Subtotal seem slower in Excel 2003 ruffnro	by ruffnro	0	528
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,753
viewing seperate data within worksheet Gate	by Roger H.	1	430
Add asterisk to excel cell jblack35	by Bob Tarburton	1	1,809
conditional formating of group of columns and rows Madhav	by Madhav	0	763
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,015
VLookup Function MacNut	by Arvi Laanemets	5	380
web query for Excel QLS_KIM	by QLS_KIM	0	522