Excel Worksheet Functions - Page 57

Thread / Thread Starter	Last Post	Replies	Views
limit a value using discounts Duncan, UK	by Duncan, UK	4	518
What is the quickest method to insert & name multiple worksheets . clyonesse	by clyonesse	0	636
How do I change the colour of/remove the Freeze Panes line in Exce katya_1978	by Jimbola	1	2,241
Pasting formulas to different rows herbertgroover	by Michael Malinsky	1	794
Copy and Paste Formula Without the linked file path KevinB	by Gord Dibben	2	1,970
Exctracting Data Brad	by Gord Dibben	1	421
Change workbook sheet reference using cell A1 to change a vairable Reed	by Reed	4	1,680
Multiple Data Validation Criterias MCorrea	by MCorrea	4	1,812
CELL PROTECTED IN 2000, UNPROTECTED IN 2003 Carole O	by Carole O	0	824
How do I convert dollars and cents to text, and prefill the cell . Jan Buckley	by Tim C	1	1,158
GetPivotData Paul Smith	by Paul Smith	0	659
Is there a way to display when a document was last saved in a foot Jeff	by Jason Morin	1	544
How do I use vlookup to point to an external file that changes nam Aschaney	by Harlan Grove	3	727
Need help with cell formatting jeri_g	by Trying to excel in life but need help	4	683
Average Non-Contiguous numbers Teri	by Jason Morin	1	861
Building a table with formulas rather than a macro Daniel Bonallack	by Daniel Bonallack	3	549
Total of differing dates parkerlex	by Peo Sjoblom	1	333
VLOOKUP taxmom	by taxmom	0	439
Excal Concatination of cells that are not empty orourksj	by orourksj	5	718
conditional formatting adjacent cells jbsand1001	by Peo Sjoblom	2	892
Sumproduct on filtered cells Ndel40	by Ndel40	19	2,909
Help needed with priority list _SPCA	by _SPCA	0	617
number of week ciccio	by Michael Malinsky	2	480
daily average JBoulton	by JBoulton	12	1,407
toolbar k8P	by Don Guillett	1	319
Replicating Formulas with Various Worksheet References Cloudburst99	by Ralph Howarth	1	781
Hyperlinks between versions Mike	by Carole O	1	478
Vlookup Need Help With Vlookup	by JE McGimpsey	1	388
Find number of days between to dates Qaspec	by Bob Phillips	1	771
Exam scores Newbie	by Gord Dibben	3	699
Replace Letter "E" with Letter "C" for 200 Different Sums in a Col Katherine	by Michael	1	693
Unique count of text Debbie	by Ola	7	541
Add a formula to Pivot Table bsfacf	by bsfacf	0	959
HELP!? Passwords are driving me crazy. NoviceJESS	by Kevin H. Stecyk	6	625
Why won't colums add if new infor mation is added? Mike	by Rob van Gelder	1	555
Count function in excel with different conditions chits	by Rob van Gelder	1	497
How read and calculate data from one worksheet to another? Frank JC	by Ralph Howarth	1	422
Dynamic Formulas with Dynamic Ranges Ralph Howarth	by Arvi Laanemets	5	1,365
Add up Plus & Minus Figures separately by Location John	by John	2	1,089
Error in SERIESSUM Thermal manager	by Thermal manager	3	473
Excel workbook crashed Edgar Thoemmes	by Max	3	733
EMBED Function with AutoCAD Derek	by Derek	0	529
Holiday chart Edgar Thoemmes	by Bernd Plumhoff	2	947
How do I secure borders, make them unaffected by copying or draggi sebds70	by Max	1	674
Check if table contains text Peter B	by JE McGimpsey	1	1,483
Conditionally formating weekends Edgar Thoemmes	by JE McGimpsey	3	341
Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working SuzieQ12345	by JulieD	5	994
Formulas Stan	by Bob Phillips	3	1,839
IF(SUM) help please Steve B	by Bob Phillips	4	409
is there a formula to generate a calendar month date rather than . lmurray	by JulieD	1	676
How do i change all numbers in my worksheet Leo258	by JulieD	2	314
What Functions should be used taxmom	by taxmom	4	517
Problem with named formula's nathan	by nathan	0	1,433
Another Date Formula Request Qaspec	by Qaspec	1	475
Question audrey	by JulieD	5	310
Need absolute time from yesterday MIke K	by JE McGimpsey	4	538
how do I add data validation dropdown lists to a Form SteveD.IFlora	by Bob Phillips	3	1,152
Display another cell have a cell containing its location. JKwesi	by Superslinky	2	595
Return a date 6 months from a date in another cell Qaspec	by N Harkawat	1	879
Cannot get border line on right of table to show. Debutante	by JE McGimpsey	1	571
SUMIF PROBLEM puzzledfe	by Peo Sjoblom	3	455
Count formula Vibha	by JE McGimpsey	2	569
tab delimited files Brad	by JE McGimpsey	3	499
Turn off warnings in Macro Patti	by Ken	1	1,153
How can I count cells that meet two criteria within a filtered co. lizzzy	by Bob Phillips	1	1,076
automatic color change in cells using a drop down list kennethwt	by Gord Dibben	1	2,802
return a " " for null values David#	by Gord Dibben	2	644
Creating Excel bookmarks Louise	by Gord Dibben	1	910
2 condition Duplicates wal50	by wal50	1	732
I need to have only the values show in a spreadsheet. Debutante	by Gord Dibben	1	734
How would I make a calendar template in Excel for the year 2006?? GHL	by GHL	5	1,161
SUMIF problem Nadia	by	3	497
EDATE &EOMONTH problem IC	by Myrna Larson	2	896
dynamic ranges Sam	by Sam	2	757
Pivot Tables TamIam	by TamIam	0	358