Excel Worksheet Functions - Page 524

Thread / Thread Starter	Last Post	Replies	Views
how to reposition the dataset from top to bottom in a column? arizona	by RagDyeR	1	568
Extract duplicate rows to another worksheet Northwoods	by Max	7	1,217
A formula to filter data and copy it from one worksheet to another GeneR	by Biff	6	1,252
Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D [email protected]	by Max	2	477
I Need a Formula to return a zero value Matt	by Roger Govier	1	422
conditional format range set-up in Excel 2000 Ellie	by Ellie	5	694
"Format" function in Excel Barrett at Tyndale	by Obi	2	452
sum a column Alex	by Alex	2	374
Copy Pasty	by Roger Govier	1	416
copying formula Alex	by Alex	3	549
SAveAs worksheet Brian Young	by Brian Young	14	1,409
Check if result is an integer? Irdanwen	by Bob Phillips	2	2,682
Variable external data through a Microsoft Query Jocular Jock	by Dave F	2	745
Hyperlink mailto - ref cell for mail subject LDUNN1	by LDUNN1	2	1,056
DAILY WORKSHEET Donna	by Barb Reinhardt	1	469
why is the INDIRECT function volatile? Dave F	by Dave F	2	3,827
Criteria for datbase function in one row? Thomas R. Glass	by Bernie Deitrick	3	871
how do I create a football team syndicate? Needing Help!!	by Bernie Deitrick	1	765
extract first name only from full name KB916521 Junk Update Office 2003 -A	by PCLIVE	2	1,187
Keep non-duplicates only GMK	by smw226 via OfficeKB.com	7	4,340
16.36 convert to 16:36 (min:sec) Sailonmike	by Sailonmike	5	453
WEEKNUM() Question Jared Call	by Ron de Bruin	3	384
Lock/Unlock cells BFife	by PCLIVE	2	1,058
if statements in sumproduct formula Doug Glancy	by Bob Phillips	5	1,089
How to make userform work publically with hidden sheets? Zigball	by Zigball	7	1,120
time diffrence with 24 hour clock Rich Mcc	by Teethless mama	3	908
Is it possible to sort or filter data by color of the field? Anna	by Jim Thomlinson	1	606
Finding descrete valuse Steve M	by Steve M	3	534
Using a cell to reference sheetname in vlookup function jnasr	by Jim Thomlinson	1	913
Isolating single row based on date comparison [email protected]	by [email protected]	3	491
SUMPRODUCT formula - help! Kierano	by Teethless mama	5	498
Correlating items from 2 different spreadsheets Reebis	by Allllen	5	472
using "&" in the header (not date autofill) Jentothephils	by Jentothephils	2	1,255
pivot table, grand total no negatives legs	by Jim Thomlinson	3	823
separate a Capital starting word from a sentence Rasoul Khoshravan	by Rasoul Khoshravan	3	1,165
delete a word from end of a text Rasoul Khoshravan	by Rasoul Khoshravan	10	940
2.5-0.89Â¢-#VALUE!-2.5 - =IF((F3/H3)0,TEXT(F3/H3,"$0.00") No work atb	by David Biddulph	5	509
COUNTIF says Null = Blank but Blank < Null Epinn	by Epinn	4	1,470
How I do protect linked information if the link source is deleted moran	by romelsb	2	539
check for two blank cells before populating a 3rd. slinger	by Bernard Liengme	6	527
standard deviation ckatz	by Mike Middleton	1	970
How to format a cell to only allow multiples of a number Roger	by smw226 via OfficeKB.com	2	2,730
Find and Replace ROUNDUP(stuff, 0) [email protected]	by Dave F	3	446
How do I merge 2 workbooks by comparing one column Sadiya Bilgrami	by Richard Buttrey	1	451
find number in multiple columns and rows JLeoni	by Richard Buttrey	1	539
How do I import multiple e-mail addresses from website to excel af	by af	0	589
if a condition is met I want an x in a cell scheduler	by scheduler	2	397
Lookup with Variables rlee1999	by Ron Coderre	2	567
Calculations in Pivot Table pdberger	by Epinn	1	386
make heading stationairy Darrezz	by Biff	1	323
Spreadsheet to compute the swing weight of a golf club... Clubmaker	by CLR	3	3,770
converting julian dates Dvelasq	by Gary Brown	1	541
Excel formulas Debi	by Gord Dibben	2	312
find string within other string Nir	by Nir	8	571
Add-in function - language Johannes	by Franz Verga	3	765
running balance using split cells Linda Tonya	by Linda Tonya	0	363
Amortization with up front skips kmagolden	by Fred Smith	1	509
copy and paste Sam	by Sam	2	297
How can I format cells with data that meets certain criteria? AshEureka	by AshEureka	2	436
Can you make a checkbox larger? terrym	by terrym	0	1,161
MAX, IF statements? Bob	by Max	9	783
Reading the Latest Value into a cell lee	by Max	1	495
Conditions in sumproduct Antonio	by Antonio	3	558
SumIf - More then 1 criteria - Please assist Nir	by Biff	8	376
what are the columns (1 2 3) which appear right of line # column deadwood	by Paul B	1	309
Calendar/Date Calculations Rob	by Rob	3	365
Find Many String options in ONE String Nir	by PapaDos	6	629
countif within array Grant	by Biff	3	690
Date justvree	by Stefi	1	317
how to add a record to a pivot table Rasoul Khoshravan	by Roger Govier	1	402
How can i split combined number and text in excel using formula? John S	by Lori	14	3,769
how to search a word in a excel file which appears twice Jegadeesan P r	by Jegadeesan P r	0	465
How can I stop csv files converting 19-05-53 to 19/05/1953 Steve	by David Biddulph	2	408
two dimension look up table Dave Jepson	by Ron Coderre	1	500
How can I link and deduct one cell from a budget in another? stevierobs	by Dave F	1	390