Excel Worksheet Functions - Page 59

Thread / Thread Starter	Last Post	Replies	Views
Last Friday of the month Alfredo_CPA	by T. Valko	9	2,255
find out average even rows in a particular range Muralikrishnan	by Muralikrishnan	9	2,254
Formula to return position of the next Non-blank cell in a column PCLIVE	by Don Guillett	14	2,254
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve	by Steve	2	2,254
How to count the number of Excel cells with text formatted Italic phausman	by phausman	3	2,254
Demerge cells and copy data Johan	by Ashish Mathur[_2_]	5	2,254
VLOOKUP using two criteria Josh Johansen	by bj	6	2,253
IF statement with 3 possible outcomes djmillis	by djmillis	2	2,251
Excel: How to import multiple XML "Repeating child elements" same. l8vj	by l8vj	0	2,251
use COUNTIF to total BOLD TEXT?? Brainless_in_Boston	by Brainless_in_Boston	4	2,251
Populate 120 cell column with successive months entering only firs 2ndchinv	by 2ndchinv	3	2,251
How to record time in Excel in military (0730) format? fontana	by David Biddulph[_2_]	17	2,251
How to get month number for fiscal year starting in Oct. Tim	by John C[_2_]	3	2,250
Is there a keyboard shortcut for using Paintbrush? Mike M[_2_]	by Don Guillett	8	2,250
1st Monday of a month in date range?? scwilly	by scwilly	22	2,250
Summing only numbers, not formulas John	by Bernard Liengme	4	2,249
How do you enter person's height in cell? Jim	by Peo Sjoblom	1	2,249
How do I setup a formula for payroll deductions in excel Skeeter	by Michael	1	2,249
sumif function leaving a blank cell when criteria not met Andy H	by Andy H[_2_]	3	2,248
Lookup Function? Employee Number with Employee Name Lance Hebert[_2_]	by Eva	1	2,248
Better performance Vlookup or Index/Match? Dan	by Infinitogool	1	2,247
How to Create Macro to Increase Cell Value to one and Print Worksheet [email protected]	by [email protected]	4	2,247
Calculate hours, past midnight etc CindyJ	by T. Valko	4	2,247
sending data from one cell to another (not using copy & paste) Charlie Payne	by CarlosAntenna	3	2,247
How do I program the cells in Excel to add, subtract, etc? Bob Mulligan	by S S	4	2,246
Calculate 'exact' age in EXCEL Zanny Garbett	by Niek Otten	4	2,246
Nesting SUMIF within SUMPRODUCT sj2008	by Bernie Deitrick	10	2,245
3D Interpolation EStewart	by EStewart	0	2,245
Disable automatic date conversion feature iceseal	by David McRitchie	2	2,245
Can you average data in 1 column based on a range of values in another? kman24	by R.VENKATARAMAN	2	2,244
Autofill cell references with a pattern of every 110 rows Light	by ShaneDevenshire	3	2,244
IF THEN color cell red NHOWARDUT	by Alan	3	2,244
Convert pesos to dollars???? Roberta	by Pete_UK	1	2,244
Convert Decimal hours and Minutes to minutes please. Steved	by Biff	13	2,244
Conditional formatting row when cell value is an even number hhunt	by Ken Wright	5	2,244
Return a value if item does not appear on list Staceyglow	by Staceyglow	2	2,244
How to omit blank cells when calculating weighted averages Suzy	by T. Valko	20	2,243
Merge Two Excel Files by Key THW	by Max	1	2,243
Count if within conditional formatted cells kmaki	by TheUbe	12	2,243
Remove Civic numbers in Street Address, move to previous blank cell Canuck	by Niek Otten	1	2,243
Create macro to calculate data range for a running chart James Lucero	by ryguy7272	1	2,243
Continuous calculation of a formula. Husker87	by Husker87	0	2,243
sum multiple cells from a 2d array koneil	by JMB	3	2,242
how to enter a null cell value in a formula Using formulas to enter NULL cell values	by Using formulas to enter NULL cell values	5	2,242
How to auto-refresh Pivot data when open Excel file? Julie	by Myrna Larson	3	2,242
want to copy formula, only change one number in formula cac1966	by Max	3	2,242
Vlookup for multiple row data David B	by Charlie_Brown	14	2,242
Vlookup info being used without vlookup table attached?	by	0	2,242
Does Excel contain a decision tree analysis? DrankPA6	by mickrio	4	2,242
Vacation Accrual Formula MissNadine	by MissNadine	0	2,242
How do I link a value into a sentence in Excel? FHM12	by Dave Peterson	4	2,241
Why is the font printing smaller than it should? shepsong	by Mujeeb ur Rehman, FBL-GRW-PK	1	2,241
freeze frames button inactive woody	by Gord Dibben	3	2,241
Vlookup and images placed into cell locations AtTheEndofMyRope	by JLatham	5	2,240
Finding the oldest date in a column Robert Smith	by Pete_UK	6	2,240
Ignore Blank in Validation not working David	by Bob Phillips	4	2,240
How to save random numbers? Rangemaster	by [email protected]	7	2,239
Change cell selection border color in excel to stand out more? Jeanne	by Dave Peterson	3	2,238
Daily Macro to Download Data, Order and paste in order Iarla	by Don Guillett	1	2,238
how to use linest to get the result as ARRAY? frank	by Harlan Grove[_2_]	1	2,237
Change EXCEL Clock to Standard Clock or Military Time YoMarie	by Alan Beban	4	2,237
copy paste formula to skip rows Greg	by Duke Carey	1	2,237
removing a space between words in a cell JenBasch	by Gord Dibben	3	2,237
I am trying to find drafting symbols TMT	by Beege	2	2,236
another text to column problem gbeard	by gbeard	11	2,236
Can Excel2002 determine if a calculated date is a business day? jsmahnken	by Harlan Grove	2	2,235
Group rows (or hide rows) like in MS Project Annie1904	by Ashish Mathur[_2_]	2	2,235
convert cm to inches VPH	by Gord Dibben	3	2,234
How do I sort the last 3 digits first and then the first 4 digit?. aphriam	by Teethless mama	2	2,233
NPV - when does the first year start? Gazza	by Gazza	3	2,233
Conditional formatting comparing two columns Shelina	by Jacob Skaria	6	2,233
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t zzxxcc	by zzxxcc	2	2,233
how to auto increment cell location within formula Bill	by Bill	3	2,232
Formula for adding a comma in front of text in a cell Shelley	by JulieD	4	2,232
SLOPE, (error in b if y= a+ bx) Miesjz	by Ron Rosenfeld	1	2,231