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	480
Variable Table Array in Lookup Function matt_the_brum	by matt_the_brum	6	2,237
My boss is crazy John21	by John21	0	461
Enable Excel to Sort by IP Address Mykle	by Mykle	0	584
is there a way to post dates without enetering 1 by 1 into cell dustin	by Larry	3	373
Combining words and nums. Eddie	by Mark	2	370
How to use the drop down date in Excel? gwtreece	by Duke Carey	1	400
Absolutes in Formulas steph44haf	by Bernie Deitrick	1	415
unable to hide columns -"can not shift objects off sheet" shows Pinaki	by Marc	2	1,213
Flagging failed values. ryanmhess	by	3	630
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	409
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	653
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	396
List when worksheet protected StephenS	by shail	3	404
Find next blank row in another spreadsheet Bry	by Toppers	1	654
Creating a complex search echo_park	by echo_park	3	630
fiterling merged cells vickyho1008	by Toppers	1	378
Coverting seconds, to minutes and seconds JaB	by Pete_UK	1	470
Using EOMONTH displays #NAME? error Paul	by Niek Otten	1	698
Drop down menu Freddo	by Freddo	9	519
Vlookup giving #N/A matt_the_brum	by matt_the_brum	12	1,692
copy from one workbook to another workbook Gocool	by Gocool	0	386
Formula for Annualized percentage Sat-Geek	by Sat-Geek	7	1,439
display different images based on cell value? deisenlohr	by Gord Dibben	1	1,732
Excel should calculate large workbooks more efficiently DKoinonia	by DKoinonia	5	400
Finding row & column given value in a Table brutonparish	by Biff	1	399
Automating charts with reference to new data and formulas deesy	by deesy	1	438
RANK Function - Zero Value Ranked as 1 - Should be 10 Sandi	by Sandi	8	555
can this be done? Abbo	by Fred Smith	10	621
Not printing rows with a zero value jski	by Pete_UK	1	551
Total back to w/c Monday Mickey	by daddylonglegs	3	366
Import excel spreadsheet into an excel spreadsheet kfletchb	by kfletchb	2	936
How do I lock a stamp date/time formula for an entry on a row? PROPERTIES INC.	by Gord Dibben	3	1,545
nesting within vlookup spxer	by daddylonglegs	1	447
SumIf: use of greater or less than operators in Criteria B. Olund ITC	by Alan	2	2,932
Vlookup to change a column Cube Farmer	by L. Howard Kittle	2	596
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	429
IF AND help! acebrown	by David Biddulph	1	349
Convert rows to Columns Ed	by Gord Dibben	7	678
Two colors in one cell...is this possible abqhusker	by Gord Dibben	1	612
IF function Bagia	by Bagia	8	472
Need some help with name replacement type formulas havocdragon	by havocdragon	2	366
Find text and open hyperlink 2shaws	by 2shaws	0	461
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	390
varible table spxer	by Toppers	1	368
Dynamic naming of range needed XXL User	by MattColeridge	2	491
If Function vacation	by vacation	6	373
How do you get Root Mean Square Error out of a column? i'm confused!	by Gary''s Student	1	3,200
Help required with COUNTIF/AND function DAT	by DAT	3	585
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,834
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	757
how do I get the address of a cell to calculate with it dilettante	by Niek Otten	4	477
fraction b166er	by Niek Otten	5	599
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	644
Change Links/SumIf function jillteresa	by jillteresa	4	477
calender display of list data Derek	by Derek	0	311
How do I set default footer setting on excel spreadsheets? Madison1216	by David Biddulph	1	593
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	441
How can I change list into a directory format? Becky Ed	by Gord Dibben	1	602
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	654
Counting instances that 2 different columns match Cheech is Lost	by Cheech is Lost	2	482