Excel Worksheet Functions - Page 932

Thread / Thread Starter	Last Post	Replies	Views
Comparing two columns , and giving comparison results in a third. Colin Hayes	by Colin Hayes	6	584
Nesting SUMIF within SUMPRODUCT sj2008	by Bernie Deitrick	10	2,245
Regression and the confidence intervals Denis	by MH	3	1,815
Is use of XIRR appropriate when dividends are not reinvested? Borty	by Borty	2	2,056
Test cell formulas Steven	by Steven	2	410
How can I use an IFISNUMBER formula in conjunction with Vlookup? Dan	by Pete_UK	6	1,102
Using Excel to calculate future dates with various intervals MH	by Shane Devenshire[_2_]	6	1,832
Need to find all instances of a ticket number in a spreadsheet DebraR	by Shane Devenshire[_2_]	3	755
excel 2003 wildcards quynies_mom	by Shane Devenshire[_2_]	2	473
COUNTIF tcomm	by Shane Devenshire[_2_]	3	409
Simple ? countif, 3 separate conditions across multi tabs Steve	by Steve	8	526
Format cells without a formula [email protected]	by [email protected]	3	1,782
How do I set more than 1 target cell using MS Solver? n8wildey	by Dana DeLouis[_3_]	5	1,284
Analysis Toolpak-Confidence Level and data analysis questions MH	by MH	0	1,759
OR Function in VLookup Biff	by T. Valko	9	527
Conditional Formatting - 2 columns hamilton_heff[_2_]	by Shane Devenshire[_2_]	2	663
SUM the column, IF... Tauqeer M.Latif	by Shane Devenshire[_2_]	2	345
Consistent 80% Success Rate Trading System Alpha Trader	by Fred Smith[_4_]	2	554
SUM IF Duey on the lake	by Shane Devenshire[_2_]	3	394
Insert selected cell value into next cell in range that is empty Guy[_2_]	by Guy[_2_]	6	1,096
I want a cell to show total from other cell when that cell changes carinco	by Mike H	6	748
Formula Help Yossy	by JBeaucaire[_35_]	4	361
Referencing Relative Sheets jwatters	by jwatters	4	388
Amend the DV0022 - Update Validation Selections code for more lists [email protected]	by Joel	1	542
auto fill certain data from sheet1 to sheet 2 Coje	by Coje	2	1,081
Excel Worksheet Mike Pirolli	by Shane Devenshire[_2_]	2	386
Protect workbook Keyrookie	by Gord Dibben	2	554
I want to link totals on multiple worksheets into one total hugablek	by Gord Dibben	5	3,284
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve	by Steve	2	2,253
create overview page; lookup results from multiples worksheet van0710	by Shane Devenshire[_2_]	5	572
Averaging blank or cells with Zeros in them. Glenn	by Glenn	4	645
Auto fill Certain data from Sheet 1 to Sheet 2 Coje	by Coje	0	686
How to sum when the criteria and the range are in the same row? Mo	by Mo	2	377
How to Lock sort on a data entry sheet. Bob	by Bob	2	1,399
need a order fill rate spread sheet mv	by Shane Devenshire[_2_]	2	873
Simple formula, I'm sure Connie Martin	by Shane Devenshire[_2_]	2	285
How to restrict input to a list of values - with a twist Rod	by Ashish Mathur[_2_]	7	599
Labels in formula a m spock	by a m spock	7	540
Need a Formula for Multiplication of Feet and Inches vmohan1978	by vmohan1978	6	3,916
Conditional PRODUCT or SUM Kevin H.	by Pete_UK	9	771
find a alphanumeric in a list 2226	by Shaun	2	479
help with vlookup, offset or match formula's Gary	by Gary	0	416
How to have conditional dropdown Ramki	by Roger Govier[_3_]	1	416
Summing only #'s on unhidden columns Peter Trumbo	by Dave Peterson	3	512
Re-establish function on exiting workbook Colin Hayes	by Colin Hayes	4	603
How do I fix (prevent scrolling) of part of an Excel worksheet? katherin	by Pete_UK	2	1,237
Macro with custom sort order Erin	by Erin	4	1,451
Date Calculation Bill	by Lars-Åke Aspelin[_2_]	14	903
Rounding Cell Values RWAMSLEY	by Lars-Åke Aspelin[_2_]	3	408
Current Time Function Shaun	by Shane Devenshire[_2_]	11	910
Trying to calculate hours worked on timecard using "IF" command Melissa	by Shane Devenshire[_2_]	6	1,044
Are Protection Options Compatible? Reitanos	by Dave Peterson	3	417
Time Conversion Jodi Macy[_2_]	by Gary''s Student	3	570
State abbrev. TN changes to ten can not type TN as abbre. teresac	by Shane Devenshire[_2_]	3	392
=IF AND or OR sumif and[_2_]	by JBeaucaire[_49_]	8	538
Vlook up value is #N/A Hong	by Shane Devenshire	4	461
How do I write up-side-down in Excel? Fredde_kd	by Keep It Simple Stupid	2	965
Sorting data of various length's, numbers, letters and dash's Nicole	by Shane Devenshire	4	4,401
No Analysis Tool Pack=EDATE formula not working! HELP!! Danny Boy	by Danny Boy	9	1,134
Skip Blanks Not Working Adam	by [email protected]	4	1,436
Floating Titles Olrjr	by Max	4	1,030
COMPARING TWO COLUMNS OF INFORMATION, ACROSS TWO WORKSHEETS Susan	by Ashish Mathur[_2_]	2	683
find function Yossy	by Yossy	5	611
Date format in Excel 2007 mm/dd/yy not appearing correctly RickGCR	by Shane Devenshire[_2_]	2	1,628
conditional format Yossy	by JE McGimpsey	4	364
"filtration" of dataset gordom	by Max	6	453
Assigning values to adjacent cells from a function MJ_N_CO	by JE McGimpsey	1	410
How to combine several successive rows into one cell gordom	by Sheeloo[_3_]	2	609
how do I get the last entered value in a column of values Rodney	by T. Valko	12	1,120
How to do a Vlookup and choose the corresponding Value with highes fats_71	by fats_71[_2_]	3	530
COUNT IF WITH 2 CRITERIAS WITH SEVERALS ITEMS ON EACH CRITERIA Bere	by T. Valko	3	947
Looking Up Two Values in an Array Mike M[_2_]	by T. Valko	6	956
Count the times a value appears in a column based on another value TrainingGuru	by JE McGimpsey	6	564
excel 2002 John	by JBeaucaire[_57_]	3	402
names in different worksheets a m spock	by a m spock	2	452