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	468
Variable Table Array in Lookup Function matt_the_brum	by matt_the_brum	6	2,213
My boss is crazy John21	by John21	0	453
Enable Excel to Sort by IP Address Mykle	by Mykle	0	568
is there a way to post dates without enetering 1 by 1 into cell dustin	by Larry	3	353
Combining words and nums. Eddie	by Mark	2	361
How to use the drop down date in Excel? gwtreece	by Duke Carey	1	388
Absolutes in Formulas steph44haf	by Bernie Deitrick	1	408
unable to hide columns -"can not shift objects off sheet" shows Pinaki	by Marc	2	1,181
Flagging failed values. ryanmhess	by	3	610
Replace in a currency column AMH	by starguy	2	332
How do I count only values which are over a certain amount? IssieC	by Duke Carey	2	389
function to count project overlap jay d	by jay d	0	608
How do I use LOOKUP to return a range of values, then SUM values? irvine79	by Fred Smith	5	1,546
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	797
Data Validation with Blank Date Gos-C	by Gos-C	2	373
List when worksheet protected StephenS	by shail	3	391
Find next blank row in another spreadsheet Bry	by Toppers	1	636
Creating a complex search echo_park	by echo_park	3	610
fiterling merged cells vickyho1008	by Toppers	1	375
Coverting seconds, to minutes and seconds JaB	by Pete_UK	1	448
Using EOMONTH displays #NAME? error Paul	by Niek Otten	1	680
Drop down menu Freddo	by Freddo	9	506
Vlookup giving #N/A matt_the_brum	by matt_the_brum	12	1,683
copy from one workbook to another workbook Gocool	by Gocool	0	373
Formula for Annualized percentage Sat-Geek	by Sat-Geek	7	1,428
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	395
Finding row & column given value in a Table brutonparish	by Biff	1	373
Automating charts with reference to new data and formulas deesy	by deesy	1	407
RANK Function - Zero Value Ranked as 1 - Should be 10 Sandi	by Sandi	8	537
can this be done? Abbo	by Fred Smith	10	615
Not printing rows with a zero value jski	by Pete_UK	1	537
Total back to w/c Monday Mickey	by daddylonglegs	3	357
Import excel spreadsheet into an excel spreadsheet kfletchb	by kfletchb	2	901
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	427
SumIf: use of greater or less than operators in Criteria B. Olund ITC	by Alan	2	2,919
Vlookup to change a column Cube Farmer	by L. Howard Kittle	2	584
how can I use excel to tabulate survey results Maiadd	by Maiadd	2	3,461
Adding numbers from specific cells in a number of sheets c991257	by c991257	2	524
rolling dustin	by Biff	2	419
IF AND help! acebrown	by David Biddulph	1	340
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	353
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	666
IF Function with < & acebrown	by acebrown	4	376
varible table spxer	by Toppers	1	360
Dynamic naming of range needed XXL User	by MattColeridge	2	477
If Function vacation	by vacation	6	357
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,720
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	666
can any one tell me how to convert figures into words automatical. viral_pandya_virurids	by Marcelo	1	724
how do I get the address of a cell to calculate with it dilettante	by Niek Otten	4	464
fraction b166er	by Niek Otten	5	556
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	628
Change Links/SumIf function jillteresa	by jillteresa	4	460
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	444
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	563
Need Macro Help [email protected]	by Bob Phillips	1	382
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