Excel Worksheet Functions - Page 717

Thread / Thread Starter	Last Post	Replies	Views
Return a text string when the result of VLOOKUP formula is #N/A jeremy nickels	by jeremy nickels	2	1,804
varible table not spxer	by spxer	3	477
Variable Table Array in Lookup Function matt_the_brum	by matt_the_brum	6	2,237
My boss is crazy John21	by John21	0	459
Enable Excel to Sort by IP Address Mykle	by Mykle	0	580
is there a way to post dates without enetering 1 by 1 into cell dustin	by Larry	3	363
Combining words and nums. Eddie	by Mark	2	368
How to use the drop down date in Excel? gwtreece	by Duke Carey	1	391
Absolutes in Formulas steph44haf	by Bernie Deitrick	1	412
unable to hide columns -"can not shift objects off sheet" shows Pinaki	by Marc	2	1,209
Flagging failed values. ryanmhess	by	3	623
Replace in a currency column AMH	by starguy	2	336
How do I count only values which are over a certain amount? IssieC	by Duke Carey	2	407
function to count project overlap jay d	by jay d	0	627
How do I use LOOKUP to return a range of values, then SUM values? irvine79	by Fred Smith	5	1,574
How do I keep the top row of a spread sheet visable? Ronnie	by Niek Otten	1	650
A formula to count characters in an Excel cell? Griff	by Don Guillett	3	819
Data Validation with Blank Date Gos-C	by Gos-C	2	390
List when worksheet protected StephenS	by shail	3	398
Find next blank row in another spreadsheet Bry	by Toppers	1	644
Creating a complex search echo_park	by echo_park	3	629
fiterling merged cells vickyho1008	by Toppers	1	377
Coverting seconds, to minutes and seconds JaB	by Pete_UK	1	469
Using EOMONTH displays #NAME? error Paul	by Niek Otten	1	696
Drop down menu Freddo	by Freddo	9	517
Vlookup giving #N/A matt_the_brum	by matt_the_brum	12	1,689
copy from one workbook to another workbook Gocool	by Gocool	0	378
Formula for Annualized percentage Sat-Geek	by Sat-Geek	7	1,437
display different images based on cell value? deisenlohr	by Gord Dibben	1	1,723
Excel should calculate large workbooks more efficiently DKoinonia	by DKoinonia	5	400
Finding row & column given value in a Table brutonparish	by Biff	1	396
Automating charts with reference to new data and formulas deesy	by deesy	1	433
RANK Function - Zero Value Ranked as 1 - Should be 10 Sandi	by Sandi	8	545
can this be done? Abbo	by Fred Smith	10	618
Not printing rows with a zero value jski	by Pete_UK	1	551
Total back to w/c Monday Mickey	by daddylonglegs	3	364
Import excel spreadsheet into an excel spreadsheet kfletchb	by kfletchb	2	926
How do I lock a stamp date/time formula for an entry on a row? PROPERTIES INC.	by Gord Dibben	3	1,542
nesting within vlookup spxer	by daddylonglegs	1	437
SumIf: use of greater or less than operators in Criteria B. Olund ITC	by Alan	2	2,926
Vlookup to change a column Cube Farmer	by L. Howard Kittle	2	591
how can I use excel to tabulate survey results Maiadd	by Maiadd	2	3,468
Adding numbers from specific cells in a number of sheets c991257	by c991257	2	533
rolling dustin	by Biff	2	424
IF AND help! acebrown	by David Biddulph	1	346
Convert rows to Columns Ed	by Gord Dibben	7	678
Two colors in one cell...is this possible abqhusker	by Gord Dibben	1	611
IF function Bagia	by Bagia	8	463
Need some help with name replacement type formulas havocdragon	by havocdragon	2	361
Find text and open hyperlink 2shaws	by 2shaws	0	451
Using Countif with multiple criteria JustLearning	by Bob Phillips	1	586
conditional formatting for multiple lines using similar criteria? I Am Baltimore	by Bob Phillips	2	683
IF Function with < & acebrown	by acebrown	4	383
varible table spxer	by Toppers	1	365
Dynamic naming of range needed XXL User	by MattColeridge	2	490
If Function vacation	by vacation	6	363
How do you get Root Mean Square Error out of a column? i'm confused!	by Gary''s Student	1	3,190
Help required with COUNTIF/AND function DAT	by DAT	3	575
show or hide formatting marks tilaandrews	by Gord Dibben	2	1,827
Is it possible to combine two worsheets into one Pivot Table? Diane13	by Diane13	2	1,829
Using Countif with multiple criteria bj	by bj	0	681
can any one tell me how to convert figures into words automatical. viral_pandya_virurids	by Marcelo	1	755
how do I get the address of a cell to calculate with it dilettante	by Niek Otten	4	471
fraction b166er	by Niek Otten	5	596
probability mass function jeroen van dijk	by Jerry W. Lewis	4	2,531
Count unique records... with a twist... Need help! [email protected]	by [email protected]	4	639
Change Links/SumIf function jillteresa	by jillteresa	4	473
calender display of list data Derek	by Derek	0	304
How do I set default footer setting on excel spreadsheets? Madison1216	by David Biddulph	1	590
when inserting a file name in a cell how do you remove file type mikecarpenter21	by Elkar	1	468
Something is wrong with this IF statment bastien86	by Pete_UK	2	432
How can I change list into a directory format? Becky Ed	by Gord Dibben	1	595
Need Macro Help [email protected]	by Bob Phillips	1	386
aligning decimal point in a column of figures in Excel Fonda	by Duke Carey	1	649
Counting instances that 2 different columns match Cheech is Lost	by Cheech is Lost	2	473