Excel Worksheet Functions - Page 252

Thread / Thread Starter	Last Post	Replies	Views
Current Time Function Shaun	by Shane Devenshire[_2_]	11	939
Rounding Cell Values RWAMSLEY	by Lars-Åke Aspelin[_2_]	3	421
Date Calculation Bill	by Lars-Åke Aspelin[_2_]	14	919
Macro with custom sort order Erin	by Erin	4	1,468
How do I fix (prevent scrolling) of part of an Excel worksheet? katherin	by Pete_UK	2	1,263
Re-establish function on exiting workbook Colin Hayes	by Colin Hayes	4	622
Summing only #'s on unhidden columns Peter Trumbo	by Dave Peterson	3	530
How to have conditional dropdown Ramki	by Roger Govier[_3_]	1	446
help with vlookup, offset or match formula's Gary	by Gary	0	436
find a alphanumeric in a list 2226	by Shaun	2	497
Conditional PRODUCT or SUM Kevin H.	by Pete_UK	9	791
Need a Formula for Multiplication of Feet and Inches vmohan1978	by vmohan1978	6	3,976
Labels in formula a m spock	by a m spock	7	554
How to restrict input to a list of values - with a twist Rod	by Ashish Mathur[_2_]	7	633
Simple formula, I'm sure Connie Martin	by Shane Devenshire[_2_]	2	295
need a order fill rate spread sheet mv	by Shane Devenshire[_2_]	2	897
How to Lock sort on a data entry sheet. Bob	by Bob	2	1,421
How to sum when the criteria and the range are in the same row? Mo	by Mo	2	393
Auto fill Certain data from Sheet 1 to Sheet 2 Coje	by Coje	0	707
Averaging blank or cells with Zeros in them. Glenn	by Glenn	4	657
create overview page; lookup results from multiples worksheet van0710	by Shane Devenshire[_2_]	5	587
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve	by Steve	2	2,306
I want to link totals on multiple worksheets into one total hugablek	by Gord Dibben	5	3,302
Protect workbook Keyrookie	by Gord Dibben	2	571
Excel Worksheet Mike Pirolli	by Shane Devenshire[_2_]	2	395
auto fill certain data from sheet1 to sheet 2 Coje	by Coje	2	1,133
Amend the DV0022 - Update Validation Selections code for more lists [email protected]	by Joel	1	569
Referencing Relative Sheets jwatters	by jwatters	4	417
Formula Help Yossy	by JBeaucaire[_35_]	4	368
I want a cell to show total from other cell when that cell changes carinco	by Mike H	6	780
Insert selected cell value into next cell in range that is empty Guy[_2_]	by Guy[_2_]	6	1,132
SUM IF Duey on the lake	by Shane Devenshire[_2_]	3	428
Consistent 80% Success Rate Trading System Alpha Trader	by Fred Smith[_4_]	2	562
SUM the column, IF... Tauqeer M.Latif	by Shane Devenshire[_2_]	2	365
Conditional Formatting - 2 columns hamilton_heff[_2_]	by Shane Devenshire[_2_]	2	678
OR Function in VLookup Biff	by T. Valko	9	542
Analysis Toolpak-Confidence Level and data analysis questions MH	by MH	0	1,821
How do I set more than 1 target cell using MS Solver? n8wildey	by Dana DeLouis[_3_]	5	1,338
Format cells without a formula [email protected]	by [email protected]	3	1,829
Simple ? countif, 3 separate conditions across multi tabs Steve	by Steve	8	553
COUNTIF tcomm	by Shane Devenshire[_2_]	3	419
excel 2003 wildcards quynies_mom	by Shane Devenshire[_2_]	2	495
Need to find all instances of a ticket number in a spreadsheet DebraR	by Shane Devenshire[_2_]	3	769
Using Excel to calculate future dates with various intervals MH	by Shane Devenshire[_2_]	6	1,860
How can I use an IFISNUMBER formula in conjunction with Vlookup? Dan	by Pete_UK	6	1,132
Test cell formulas Steven	by Steven	2	424
Is use of XIRR appropriate when dividends are not reinvested? Borty	by Borty	2	2,071
Regression and the confidence intervals Denis	by MH	3	1,835
Nesting SUMIF within SUMPRODUCT sj2008	by Bernie Deitrick	10	2,281
Comparing two columns , and giving comparison results in a third. Colin Hayes	by Colin Hayes	6	606
Conditional Formatting Gord Dibben	by Jokah.D	5	378
Conditional Formatting RO	by T. Valko	3	514
PASSWORD PROTECTION JFW	by Shane Devenshire[_2_]	3	383
Multiple Workbooks I'm Me	by Don Guillett	1	368
correct syntax for nesting "if", "and", and "vlookup"....if possib Christine	by Christine	4	1,099
Where to begin??? PointerMan	by PointerMan	8	546
How do I create a spreadsheet that populates q's from a drop down Angela	by Angela	4	485
Macro to clear checkboxes Guy[_2_]	by Guy[_2_]	5	3,951
Combine an "IF" and "OR" statement Picman	by Picman	4	1,092
2003 to 2007 macro problem Russ Morgan	by Russ Morgan	3	484
Edits not saved when re-opening file SmartCookie	by Shane Devenshire[_2_]	1	388
Subtotal help!! ASAP!!!!!!!!! Report due by noon!!! DestinySky	by Shane Devenshire[_2_]	7	612
Flow data from one workbook to another cindyj	by JBeaucaire[_33_]	1	813
protection ?? Terry	by Shane Devenshire[_2_]	5	383
How do I select all cells with a value less than 1? PointerMan	by Gord Dibben	7	3,986
using mathmatical symbols in cells GO	by Spiky	9	550
Macro to select cells without a certain value and select a menu it Guy[_2_]	by Gord Dibben	9	1,321
Add print function Tim	by Gord Dibben	4	702
Find Cells that add up to Specific Sum BeachLover	by BeachLover	5	2,697
INDIRECT function Ernie Fenwick	by Dave Peterson	1	429
using an IF statement from a pull down box Jason	by Dave Peterson	7	627
calculating the sum of different categories over a given time peri JeffK	by Shane Devenshire[_2_]	4	465
Adding 3 columns of criteria simultaneously Michael Joseph Cosgriff	by OssieMac	3	499
Cross-referencing content of one worksheet with another Colin Hayes	by Pete_UK	9	467
Conditional Formatting Shane Devenshire[_2_]	by Jokah.D	1	705