Excel Worksheet Functions - Page 160

Thread / Thread Starter	Last Post	Replies	Views
Problems with SUMIF function and Wildcards (* and ?) J1J	by Bob Phillips	4	649
Can I do this? =VLOOKUP(A4,D1,2,FALSE); Where D1 has "$A$4:$B$18" Saravan	by Saravan	3	358
Summing across multiple sheets with a twist hillmic	by Domenic	5	729
Count number of times a specific number is displayed in a cell ran subs	by N Harkawat	1	1,145
How do I eliminate leading zeros from downloaded data? Vanessa	by bj	2	579
Page Number removal N Harkawat	by N Harkawat	3	398
Page numbering for a whole WorkBook Rodger Slape	by Rodger Slape	2	803
can I sum information in a list WTG	by WTG	0	345
how to save and print information WTG	by WTG	0	459
template for check requests suave	by Paul Ballou	1	617
Ctrl+Y not working vishal	by Leo Heuser	7	1,801
Is this decent? brookdale	by swatsp0p	7	383
How do I insert a date created in a cell in excel? Hasta	by Niek Otten	2	775
clear data from workbook lynn	by bj	1	459
Trouble with dates...... DavidMunday	by DavidMunday	0	405
column variables mahmon	by Ron Rosenfeld	19	954
Why doesn't the finance rate in MIRR impact the formula result? opieandy	by opieandy	0	599
MATCH FUNCTION?...challenge cecilluen	by bj	3	543
MIRR Function sensitivity to Finance Rate SongBear	by opieandy	2	1,394
hlookup #N/A stacyjhaskins	by Bob Phillips	2	863
Help with multiconditional sumif with range MaxTomas	by Gary L Brown	1	386
dynamic, double vlookup, match, index, dget?? different workbooks Leslie	by Bernie Deitrick	11	1,988
Only calculate specific worksheet automatically? qflyer	by Gary L Brown	1	479
Need a function jcc31	by jcc31	2	383
Can a worksheet pull from a specific cell value in a separate wrks reloanpro	by reloanpro	4	940
How wrong can you be with your NPV and MIRR functions in EXCel opieandy	by Harlan Grove	3	941
IF statement help NeedHelp321	by NeedHelp321	2	334
Conditional Validation - Using a "part-time" drop-down list Neil Goldwasser	by Neil Goldwasser	7	507
2 ?, Size and copying? Johnz414	by Johnz414	0	326
Goal Seek On Members of an Array within Array LostInVBA	by Harlan Grove	1	1,052
Cell shows only formula, no result alexrm	by Jim Thomlinson	1	646
can I sum information in a list WTG	by Jim Thomlinson	1	348
Sumproduct rud	by JE McGimpsey	1	377
hilght cells at a give day chuck irven [email protected]	by JE McGimpsey	1	471
Range Names Wes	by Wes	2	501
Excel 2003: can I insert a "last edited" date function? KTK	by Bob Phillips	1	1,258
Add-In: "HPVAL" Andy	by Vasant Nanavati	1	1,307
Positions of Comments AizA	by AizA	0	631
Multi Criteria then sum lost at work	by Dave Peterson	13	1,161
pivot table selection bayanbaru	by bayanbaru	0	850
how do i rename worksheet to equal cell name MissSunshineKiss	by Piranha	2	964
Decimal Points Leanne	by Leanne	1	744
Worksheet to Column Distance Cosmo	by Biff	1	427
countif text formula help JCH	by duane	2	417
Add on 10% Leanne	by Leanne	4	516
how do i add cells in checkbook register template with formulas? nlc	by nlc	0	862
template yao	by yao	0	345
Equal Sign Issue Jedidia	by Harlan Grove	2	515
Hide empty field error J	by J	3	460
how to change margins for multiple worksheets in Excel? eksus	by eksus	0	503
custom vertical footer? Joseph	by Joseph	0	633
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? Daniel	by JE McGimpsey	2	1,062
excel worksheets BobbieJ	by Anne Troy	1	413
Excel won't fill formulas Jeff Brown	by Anne Troy	3	1,243
Using other workbooks.. DavidMunday	by Alex	1	479
SUMIF Problem Mohammed Zenuwah	by Mohammed Zenuwah	5	439
Summing only coloured cells maxmil	by arno	2	587
popup message if certain criteria met in formula result John Davies	by John Davies	0	928
Linking multiple data into one worksheet. Patrick White	by Patrick White	0	678
Database Stefan	by Stefan	0	308
Need Help With A Find Formula toy4x4	by Domenic	3	364
Changing Positive to Negative Matthew Hackett via OfficeKB.com	by Matthew Hackett via OfficeKB.com	2	1,259
how do i cumulatively add in a single column? frustrated	by Dr. Nonverbal	1	472
Using the Mid function. brookdale	by Dana DeLouis	10	734
How do I filter based on color in Excel? Howieben	by Don Guillett	1	568
Autofill sisco98	by Don Guillett	1	660
How to type correctly formula in calculated field in a pivot? louloutte48	by louloutte48	2	832
Returning a numeric value for text sbg1275	by swatsp0p	4	515
automatic sort Robert	by malik641	6	497
sorting and filtering Duncan McDowell	by Debra Dalgleish	1	592
Use INDIRECT function to reference a value in closed file Saravan	by Saravan	6	1,185
Finding the 3rd largest number in a list Simon Jefford	by Simon Jefford	2	707
workbook sheets into separate files markx	by Ron de Bruin	1	931
sheet protection aimee	by Becky	2	445
Formula with options Becky	by Becky	3	345