Excel Worksheet Functions - Page 252

Thread / Thread Starter	Last Post	Replies	Views
Current Time Function Shaun	by Shane Devenshire[_2_]	11	910
Rounding Cell Values RWAMSLEY	by Lars-Åke Aspelin[_2_]	3	408
Date Calculation Bill	by Lars-Åke Aspelin[_2_]	14	903
Macro with custom sort order Erin	by Erin	4	1,451
How do I fix (prevent scrolling) of part of an Excel worksheet? katherin	by Pete_UK	2	1,237
Re-establish function on exiting workbook Colin Hayes	by Colin Hayes	4	603
Summing only #'s on unhidden columns Peter Trumbo	by Dave Peterson	3	512
How to have conditional dropdown Ramki	by Roger Govier[_3_]	1	416
help with vlookup, offset or match formula's Gary	by Gary	0	416
find a alphanumeric in a list 2226	by Shaun	2	482
Conditional PRODUCT or SUM Kevin H.	by Pete_UK	9	771
Need a Formula for Multiplication of Feet and Inches vmohan1978	by vmohan1978	6	3,916
Labels in formula a m spock	by a m spock	7	540
How to restrict input to a list of values - with a twist Rod	by Ashish Mathur[_2_]	7	599
Simple formula, I'm sure Connie Martin	by Shane Devenshire[_2_]	2	285
need a order fill rate spread sheet mv	by Shane Devenshire[_2_]	2	873
How to Lock sort on a data entry sheet. Bob	by Bob	2	1,399
How to sum when the criteria and the range are in the same row? Mo	by Mo	2	377
Auto fill Certain data from Sheet 1 to Sheet 2 Coje	by Coje	0	688
Averaging blank or cells with Zeros in them. Glenn	by Glenn	4	645
create overview page; lookup results from multiples worksheet van0710	by Shane Devenshire[_2_]	5	572
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve	by Steve	2	2,254
I want to link totals on multiple worksheets into one total hugablek	by Gord Dibben	5	3,284
Protect workbook Keyrookie	by Gord Dibben	2	554
Excel Worksheet Mike Pirolli	by Shane Devenshire[_2_]	2	386
auto fill certain data from sheet1 to sheet 2 Coje	by Coje	2	1,084
Amend the DV0022 - Update Validation Selections code for more lists [email protected]	by Joel	1	542
Referencing Relative Sheets jwatters	by jwatters	4	388
Formula Help Yossy	by JBeaucaire[_35_]	4	361
I want a cell to show total from other cell when that cell changes carinco	by Mike H	6	749
Insert selected cell value into next cell in range that is empty Guy[_2_]	by Guy[_2_]	6	1,097
SUM IF Duey on the lake	by Shane Devenshire[_2_]	3	394
Consistent 80% Success Rate Trading System Alpha Trader	by Fred Smith[_4_]	2	554
SUM the column, IF... Tauqeer M.Latif	by Shane Devenshire[_2_]	2	347
Conditional Formatting - 2 columns hamilton_heff[_2_]	by Shane Devenshire[_2_]	2	663
OR Function in VLookup Biff	by T. Valko	9	528
Analysis Toolpak-Confidence Level and data analysis questions MH	by MH	0	1,759
How do I set more than 1 target cell using MS Solver? n8wildey	by Dana DeLouis[_3_]	5	1,284
Format cells without a formula [email protected]	by [email protected]	3	1,782
Simple ? countif, 3 separate conditions across multi tabs Steve	by Steve	8	527
COUNTIF tcomm	by Shane Devenshire[_2_]	3	409
excel 2003 wildcards quynies_mom	by Shane Devenshire[_2_]	2	473
Need to find all instances of a ticket number in a spreadsheet DebraR	by Shane Devenshire[_2_]	3	755
Using Excel to calculate future dates with various intervals MH	by Shane Devenshire[_2_]	6	1,833
How can I use an IFISNUMBER formula in conjunction with Vlookup? Dan	by Pete_UK	6	1,102
Test cell formulas Steven	by Steven	2	410
Is use of XIRR appropriate when dividends are not reinvested? Borty	by Borty	2	2,056
Regression and the confidence intervals Denis	by MH	3	1,815
Nesting SUMIF within SUMPRODUCT sj2008	by Bernie Deitrick	10	2,247
Comparing two columns , and giving comparison results in a third. Colin Hayes	by Colin Hayes	6	584
Conditional Formatting Gord Dibben	by Jokah.D	5	361
Conditional Formatting RO	by T. Valko	3	497
PASSWORD PROTECTION JFW	by Shane Devenshire[_2_]	3	363
Multiple Workbooks I'm Me	by Don Guillett	1	351
correct syntax for nesting "if", "and", and "vlookup"....if possib Christine	by Christine	4	1,049
Where to begin??? PointerMan	by PointerMan	8	529
How do I create a spreadsheet that populates q's from a drop down Angela	by Angela	4	469
Macro to clear checkboxes Guy[_2_]	by Guy[_2_]	5	3,923
Combine an "IF" and "OR" statement Picman	by Picman	4	1,079
2003 to 2007 macro problem Russ Morgan	by Russ Morgan	3	468
Edits not saved when re-opening file SmartCookie	by Shane Devenshire[_2_]	1	371
Subtotal help!! ASAP!!!!!!!!! Report due by noon!!! DestinySky	by Shane Devenshire[_2_]	7	596
Flow data from one workbook to another cindyj	by JBeaucaire[_33_]	1	798
protection ?? Terry	by Shane Devenshire[_2_]	5	376
How do I select all cells with a value less than 1? PointerMan	by Gord Dibben	7	3,827
using mathmatical symbols in cells GO	by Spiky	9	526
Macro to select cells without a certain value and select a menu it Guy[_2_]	by Gord Dibben	9	1,296
Add print function Tim	by Gord Dibben	4	682
Find Cells that add up to Specific Sum BeachLover	by BeachLover	5	2,675
INDIRECT function Ernie Fenwick	by Dave Peterson	1	419
using an IF statement from a pull down box Jason	by Dave Peterson	7	605
calculating the sum of different categories over a given time peri JeffK	by Shane Devenshire[_2_]	4	442
Adding 3 columns of criteria simultaneously Michael Joseph Cosgriff	by OssieMac	3	480
Cross-referencing content of one worksheet with another Colin Hayes	by Pete_UK	9	448
Conditional Formatting Shane Devenshire[_2_]	by Jokah.D	1	688