Excel Worksheet Functions - Page 660

Thread / Thread Starter	Last Post	Replies	Views
make heading stationairy Darrezz	by Biff	1	334
Calculations in Pivot Table pdberger	by Epinn	1	422
Lookup with Variables rlee1999	by Ron Coderre	2	628
if a condition is met I want an x in a cell scheduler	by scheduler	2	410
How do I import multiple e-mail addresses from website to excel af	by af	0	620
find number in multiple columns and rows JLeoni	by Richard Buttrey	1	562
How do I merge 2 workbooks by comparing one column Sadiya Bilgrami	by Richard Buttrey	1	478
Find and Replace ROUNDUP(stuff, 0) [email protected]	by Dave F	3	467
How to format a cell to only allow multiples of a number Roger	by smw226 via OfficeKB.com	2	2,780
standard deviation ckatz	by Mike Middleton	1	999
check for two blank cells before populating a 3rd. slinger	by Bernard Liengme	6	554
How I do protect linked information if the link source is deleted moran	by romelsb	2	593
COUNTIF says Null = Blank but Blank < Null Epinn	by Epinn	4	1,521
2.5-0.89Â¢-#VALUE!-2.5 - =IF((F3/H3)0,TEXT(F3/H3,"$0.00") No work atb	by David Biddulph	5	518
delete a word from end of a text Rasoul Khoshravan	by Rasoul Khoshravan	10	965
separate a Capital starting word from a sentence Rasoul Khoshravan	by Rasoul Khoshravan	3	1,193
pivot table, grand total no negatives legs	by Jim Thomlinson	3	834
using "&" in the header (not date autofill) Jentothephils	by Jentothephils	2	1,285
Correlating items from 2 different spreadsheets Reebis	by Allllen	5	498
SUMPRODUCT formula - help! Kierano	by Teethless mama	5	516
Isolating single row based on date comparison [email protected]	by [email protected]	3	520
Using a cell to reference sheetname in vlookup function jnasr	by Jim Thomlinson	1	941
Finding descrete valuse Steve M	by Steve M	3	556
Is it possible to sort or filter data by color of the field? Anna	by Jim Thomlinson	1	619
time diffrence with 24 hour clock Rich Mcc	by Teethless mama	3	930
How to make userform work publically with hidden sheets? Zigball	by Zigball	7	1,164
if statements in sumproduct formula Doug Glancy	by Bob Phillips	5	1,107
Lock/Unlock cells BFife	by PCLIVE	2	1,085
WEEKNUM() Question Jared Call	by Ron de Bruin	3	410
16.36 convert to 16:36 (min:sec) Sailonmike	by Sailonmike	5	459
Keep non-duplicates only GMK	by smw226 via OfficeKB.com	7	4,459
extract first name only from full name KB916521 Junk Update Office 2003 -A	by PCLIVE	2	1,215
how do I create a football team syndicate? Needing Help!!	by Bernie Deitrick	1	793
Criteria for datbase function in one row? Thomas R. Glass	by Bernie Deitrick	3	895
why is the INDIRECT function volatile? Dave F	by Dave F	2	3,882
DAILY WORKSHEET Donna	by Barb Reinhardt	1	474
Hyperlink mailto - ref cell for mail subject LDUNN1	by LDUNN1	2	1,072
Variable external data through a Microsoft Query Jocular Jock	by Dave F	2	782
Check if result is an integer? Irdanwen	by Bob Phillips	2	2,812
SAveAs worksheet Brian Young	by Brian Young	14	1,442
copying formula Alex	by Alex	3	568
Copy Pasty	by Roger Govier	1	459
sum a column Alex	by Alex	2	394
"Format" function in Excel Barrett at Tyndale	by Obi	2	464
conditional format range set-up in Excel 2000 Ellie	by Ellie	5	707
I Need a Formula to return a zero value Matt	by Roger Govier	1	449
Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D [email protected]	by Max	2	506
A formula to filter data and copy it from one worksheet to another GeneR	by Biff	6	1,277
Extract duplicate rows to another worksheet Northwoods	by Max	7	1,242
how to reposition the dataset from top to bottom in a column? arizona	by RagDyeR	1	596
How to print the circles in formatting audit circle invalid data Creativity	by Creativity	0	626
How do I count rows within a cell? Jouni Kananen	by Gord Dibben	3	2,350
Possible to keep a macro seperated from a sheet? [email protected]	by Gord Dibben	2	383
Multiple criteria for lookup table Mark	by Mark	3	1,015
Calculate time within time Frigid	by Frigid	2	600
how to determine if a series of numbers contain odd or even values Kittysaid	by RagDyeR	6	559
Is there a way to name tabs so that they will ascend in order? madchef	by romelsb	8	638
how do I caluclate return on investment, compounded quarterly? SAR	by [email protected]	3	3,677
sort subtotal groups Clair	by Clair	0	741
Excel Formula Pat	by Teethless mama	3	376
I need an amortization schedule with the first 6mo no payment? kmagolden	by kmagolden	0	743
Index / Match tinman	by Biff	4	376
IF Function doesn't recognize TRUE AMY Z.	by Biff	6	1,987
how to create a if statement, if true turn colour Yashes	by Richard Buttrey	3	1,407
total the column anyway Robb27	by Robb27	6	538
copy workbook files without losing data that was in the org. work rue	by rue	0	638
Fill color not functioning in newly installed version of excel. Vernon Antoine Brou Jr.	by Vernon Antoine Brou Jr.	2	640
Reforecast budgets Jane	by romelsb	1	1,339
How to search a column that is not the first of the table Antonio	by Antonio	4	388
copy unique data Sam	by Sam	8	504
Trouble With Data Validation And Filtering On A Dropdown zura04	by zura04	0	765
sequential number code becky42002	by Bob Phillips	5	709
Unique list of entries Rasoul Khoshravan	by Kevin Vaughn	1	407
How do I write the IF function to reflect the result in one cell? AMBO	by Trevor Shuttleworth	8	606
Function within a function? Stefan	by Stefan	5	510