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,775
varible table not spxer	by spxer	3	462
Variable Table Array in Lookup Function matt_the_brum	by matt_the_brum	6	2,213
My boss is crazy John21	by John21	0	452
Enable Excel to Sort by IP Address Mykle	by Mykle	0	563
is there a way to post dates without enetering 1 by 1 into cell dustin	by Larry	3	349
Combining words and nums. Eddie	by Mark	2	360
How to use the drop down date in Excel? gwtreece	by Duke Carey	1	388
Absolutes in Formulas steph44haf	by Bernie Deitrick	1	404
unable to hide columns -"can not shift objects off sheet" shows Pinaki	by Marc	2	1,180
Flagging failed values. ryanmhess	by	3	609
Replace in a currency column AMH	by starguy	2	329
How do I count only values which are over a certain amount? IssieC	by Duke Carey	2	388
function to count project overlap jay d	by jay d	0	606
How do I use LOOKUP to return a range of values, then SUM values? irvine79	by Fred Smith	5	1,544
How do I keep the top row of a spread sheet visable? Ronnie	by Niek Otten	1	645
A formula to count characters in an Excel cell? Griff	by Don Guillett	3	796
Data Validation with Blank Date Gos-C	by Gos-C	2	373
List when worksheet protected StephenS	by shail	3	390
Find next blank row in another spreadsheet Bry	by Toppers	1	634
Creating a complex search echo_park	by echo_park	3	609
fiterling merged cells vickyho1008	by Toppers	1	373
Coverting seconds, to minutes and seconds JaB	by Pete_UK	1	444
Using EOMONTH displays #NAME? error Paul	by Niek Otten	1	676
Drop down menu Freddo	by Freddo	9	506
Vlookup giving #N/A matt_the_brum	by matt_the_brum	12	1,682
copy from one workbook to another workbook Gocool	by Gocool	0	373
Formula for Annualized percentage Sat-Geek	by Sat-Geek	7	1,423
display different images based on cell value? deisenlohr	by Gord Dibben	1	1,703
Excel should calculate large workbooks more efficiently DKoinonia	by DKoinonia	5	391
Finding row & column given value in a Table brutonparish	by Biff	1	372
Automating charts with reference to new data and formulas deesy	by deesy	1	406
RANK Function - Zero Value Ranked as 1 - Should be 10 Sandi	by Sandi	8	534
can this be done? Abbo	by Fred Smith	10	613
Not printing rows with a zero value jski	by Pete_UK	1	533
Total back to w/c Monday Mickey	by daddylonglegs	3	355
Import excel spreadsheet into an excel spreadsheet kfletchb	by kfletchb	2	894
How do I lock a stamp date/time formula for an entry on a row? PROPERTIES INC.	by Gord Dibben	3	1,527
nesting within vlookup spxer	by daddylonglegs	1	422
SumIf: use of greater or less than operators in Criteria B. Olund ITC	by Alan	2	2,904
Vlookup to change a column Cube Farmer	by L. Howard Kittle	2	582
how can I use excel to tabulate survey results Maiadd	by Maiadd	2	3,455
Adding numbers from specific cells in a number of sheets c991257	by c991257	2	524
rolling dustin	by Biff	2	415
IF AND help! acebrown	by David Biddulph	1	339
Convert rows to Columns Ed	by Gord Dibben	7	653
Two colors in one cell...is this possible abqhusker	by Gord Dibben	1	608
IF function Bagia	by Bagia	8	460
Need some help with name replacement type formulas havocdragon	by havocdragon	2	351
Find text and open hyperlink 2shaws	by 2shaws	0	443
Using Countif with multiple criteria JustLearning	by Bob Phillips	1	567
conditional formatting for multiple lines using similar criteria? I Am Baltimore	by Bob Phillips	2	662
IF Function with < & acebrown	by acebrown	4	375
varible table spxer	by Toppers	1	359
Dynamic naming of range needed XXL User	by MattColeridge	2	477
If Function vacation	by vacation	6	356
How do you get Root Mean Square Error out of a column? i'm confused!	by Gary''s Student	1	3,186
Help required with COUNTIF/AND function DAT	by DAT	3	551
show or hide formatting marks tilaandrews	by Gord Dibben	2	1,713
Is it possible to combine two worsheets into one Pivot Table? Diane13	by Diane13	2	1,816
Using Countif with multiple criteria bj	by bj	0	665
can any one tell me how to convert figures into words automatical. viral_pandya_virurids	by Marcelo	1	723
how do I get the address of a cell to calculate with it dilettante	by Niek Otten	4	461
fraction b166er	by Niek Otten	5	554
probability mass function jeroen van dijk	by Jerry W. Lewis	4	2,510
Count unique records... with a twist... Need help! [email protected]	by [email protected]	4	626
Change Links/SumIf function jillteresa	by jillteresa	4	459
calender display of list data Derek	by Derek	0	301
How do I set default footer setting on excel spreadsheets? Madison1216	by David Biddulph	1	573
when inserting a file name in a cell how do you remove file type mikecarpenter21	by Elkar	1	439
Something is wrong with this IF statment bastien86	by Pete_UK	2	424
How can I change list into a directory format? Becky Ed	by Gord Dibben	1	560
Need Macro Help [email protected]	by Bob Phillips	1	380
aligning decimal point in a column of figures in Excel Fonda	by Duke Carey	1	636
Counting instances that 2 different columns match Cheech is Lost	by Cheech is Lost	2	457