Excel Worksheet Functions - Page 146

Thread / Thread Starter	Last Post	Replies	Views
Duplicating cell value between worksheets Dennis	by Dennis	6	673
Checking 2 sets of values to provide True False Arla	by Anne Troy	6	518
Multiple condition help needed Curtis	by daddylonglegs	6	409
HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS RWood	by RWood	6	459
Looking up several number damorrison	by damorrison	6	369
date formula for extracting unique dates elfudge35	by elfudge35	6	586
How many business days were in 2005? TC	by [email protected]	6	709
Zero Suppression in Excel barcode fonts PHELM1	by barcodewiz	6	917
How do I create a sheet in Excel that updates itself from other sh Mark	by Roger Govier	6	727
Extract the first few characters MC_blur	by Dave Peterson	6	1,121
labels 9397kkpr	by Anne Troy	6	443
IF formula - evaluation shows it should work but... Juliet	by Sandy Mann	6	820
Totals of calculated field in pivot table give incorrect results Jake	by Roger Govier	6	2,734
Fv & Emi! via135	by via135	6	854
#VALUE in formula as opposed to result Spike	by Niek Otten	6	917
Is there a simple solution? Bobby	by Sandy Mann	6	687
How can I add rows inbetween? dhjacha	by Ken Wright	6	555
How to autofill strings Allewyn	by Allewyn	6	525
splitting data from 1 column into multilple? Dan B	by CLR	6	478
conditional formula Serge	by Serge	6	404
can vlookup place results in a different box than the formula? Psychlogic	by L. A. McClelland	6	520
Incorporating Vlookup in a IF Statement Shams	by bpeltzer	6	496
insert a drop down list if a certain cell value is true kd	by Biff	6	874
Adding amounts that fall within a range pdgaustintexas	by Don Guillett	6	518
conditional formatting error removal JDog	by jesahs	6	405
Sum with multiple conditions shankarexcel	by Arvi Laanemets	6	314
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? bchilt	by Roger Govier	6	1,546
Get different numbers to return text?? Curalice	by Curalice	6	522
Have 2 columns of names - need to filter out names not duplicated Jill	by Ron Coderre	6	679
Search Word guy	by guy	6	392
"Insert Function" pop-up in Excel 2003, has anyone figured out ... Incoherent	by Niek Otten	6	621
Formula nesting BSantos	by Harlan Grove	6	632
Countdown formula Dan	by Dan	6	1,019
ISODD and EVEN formula BSantos	by mphell0	6	631
=OFFSET(cell("address"),-1,0) JJ	by Harlan Grove	6	975
How can I calculate hours in a Hourly schedule in Excel? SUPERNAM	by SUPERNAM	6	1,757
how do I multiply dollars by networkdays for forcasting run rates George Cahill	by Jim Cone	6	447
Help with formula, IF, AND, OR, etc. Nancy	by Bob Phillips	6	463
Networkdays & future months denise	by marko	6	333
Find and Length Marc	by Sloth	6	367
sumif wrong result tallyman00	by tallyman00	6	1,872
Array input in one single cell Ischias	by Sloth	6	448
Counting Dates billy	by Ron Rosenfeld	6	419
Look At Two Dates roy.okinawa	by roy.okinawa	6	320
Move Data Up One Row and Add On to Existing Dennis	by Otto Moehrbach	6	560
Can I automatically sort worksheets in excel? Jimmy	by Jim Cone	6	1,074
Concatenate or "&" problem Dino	by C. Cunningham	6	346
Sorting data in a cell alphabetically Newbie1092	by hshayh0rn	6	704
Is this possible scott	by Otto Moehrbach	6	437
sum up the ROW values with ref to COLUMN values! via135	by via135	6	321
Convert Gig to Meg John Schneider	by John Schneider	6	808
Value returned from Formula changes with the Date Jeff	by Max	6	613
How can I make a range "dynamic"? Conan Kelly	by Severo	6	656
Identify current active cell reades	by John Carroll	6	1,065
linking cells ATaylor	by NKirkland	6	336
for SUMIF function, how do I use 2 sets of range & criteria Bob	by Kalida Williams	6	592
how to spell out number using function in Excel Beans	by Max	6	1,374
Copy hyperlink from one cell to/as hyperlink in another cell YogS	by David McRitchie	6	1,495
conditional formatting to multiple cells TC	by Roger Govier	6	1,019
merging the layout only of 2 cells naaitie	by naaitie	6	453
How can I set a minimum value of zero or -100% in a cell? David Drennan	by David Drennan	6	4,190
Sort by conditional formats? jbtenor1	by Bob Phillips	6	534
List Validation and Format breadvan579	by breadvan579	6	478
How to calculate CAGR for mutual fund performance using XIRR Dick in SL	by Dick in SL	6	2,555
Naming cells... Steve	by Steve	6	513
sumif more conditions Pierre via OfficeKB.com	by Bob Phillips	6	429
Date Vacation Tracker jopla	by tls	6	2,873
Is it possible to make a cell flash between 2 colours? barry24uk	by barry24uk	6	513
Shifting Calculated Result - Re-Issued sony654	by Roger Govier	6	375
Dates change the next day. TimM	by Don Guillett	6	392
Convert MS Excel data to MS Access database HelpJim	by Ron Coderre	6	669
Excel worksheet functions. balanand	by Aladin Akyurek	6	486
Return list of uncleared checks bem	by Biff	6	466
=CELL("filename") VOLATILE? DR Hall	by Peo Sjoblom	6	805
substitute "," BorisS	by Ron Rosenfeld	6	362