Excel Worksheet Functions - Page 252

Thread / Thread Starter	Last Post	Replies	Views
Current Time Function Shaun	by Shane Devenshire[_2_]	11	932
Rounding Cell Values RWAMSLEY	by Lars-Åke Aspelin[_2_]	3	416
Date Calculation Bill	by Lars-Åke Aspelin[_2_]	14	906
Macro with custom sort order Erin	by Erin	4	1,455
How do I fix (prevent scrolling) of part of an Excel worksheet? katherin	by Pete_UK	2	1,249
Re-establish function on exiting workbook Colin Hayes	by Colin Hayes	4	615
Summing only #'s on unhidden columns Peter Trumbo	by Dave Peterson	3	518
How to have conditional dropdown Ramki	by Roger Govier[_3_]	1	431
help with vlookup, offset or match formula's Gary	by Gary	0	425
find a alphanumeric in a list 2226	by Shaun	2	484
Conditional PRODUCT or SUM Kevin H.	by Pete_UK	9	777
Need a Formula for Multiplication of Feet and Inches vmohan1978	by vmohan1978	6	3,960
Labels in formula a m spock	by a m spock	7	549
How to restrict input to a list of values - with a twist Rod	by Ashish Mathur[_2_]	7	619
Simple formula, I'm sure Connie Martin	by Shane Devenshire[_2_]	2	290
need a order fill rate spread sheet mv	by Shane Devenshire[_2_]	2	892
How to Lock sort on a data entry sheet. Bob	by Bob	2	1,412
How to sum when the criteria and the range are in the same row? Mo	by Mo	2	380
Auto fill Certain data from Sheet 1 to Sheet 2 Coje	by Coje	0	695
Averaging blank or cells with Zeros in them. Glenn	by Glenn	4	653
create overview page; lookup results from multiples worksheet van0710	by Shane Devenshire[_2_]	5	583
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve	by Steve	2	2,270
I want to link totals on multiple worksheets into one total hugablek	by Gord Dibben	5	3,299
Protect workbook Keyrookie	by Gord Dibben	2	564
Excel Worksheet Mike Pirolli	by Shane Devenshire[_2_]	2	389
auto fill certain data from sheet1 to sheet 2 Coje	by Coje	2	1,126
Amend the DV0022 - Update Validation Selections code for more lists [email protected]	by Joel	1	555
Referencing Relative Sheets jwatters	by jwatters	4	402
Formula Help Yossy	by JBeaucaire[_35_]	4	367
I want a cell to show total from other cell when that cell changes carinco	by Mike H	6	778
Insert selected cell value into next cell in range that is empty Guy[_2_]	by Guy[_2_]	6	1,109
SUM IF Duey on the lake	by Shane Devenshire[_2_]	3	410
Consistent 80% Success Rate Trading System Alpha Trader	by Fred Smith[_4_]	2	558
SUM the column, IF... Tauqeer M.Latif	by Shane Devenshire[_2_]	2	354
Conditional Formatting - 2 columns hamilton_heff[_2_]	by Shane Devenshire[_2_]	2	670
OR Function in VLookup Biff	by T. Valko	9	535
Analysis Toolpak-Confidence Level and data analysis questions MH	by MH	0	1,781
How do I set more than 1 target cell using MS Solver? n8wildey	by Dana DeLouis[_3_]	5	1,322
Format cells without a formula [email protected]	by [email protected]	3	1,817
Simple ? countif, 3 separate conditions across multi tabs Steve	by Steve	8	537
COUNTIF tcomm	by Shane Devenshire[_2_]	3	411
excel 2003 wildcards quynies_mom	by Shane Devenshire[_2_]	2	487
Need to find all instances of a ticket number in a spreadsheet DebraR	by Shane Devenshire[_2_]	3	760
Using Excel to calculate future dates with various intervals MH	by Shane Devenshire[_2_]	6	1,848
How can I use an IFISNUMBER formula in conjunction with Vlookup? Dan	by Pete_UK	6	1,118
Test cell formulas Steven	by Steven	2	412
Is use of XIRR appropriate when dividends are not reinvested? Borty	by Borty	2	2,066
Regression and the confidence intervals Denis	by MH	3	1,824
Nesting SUMIF within SUMPRODUCT sj2008	by Bernie Deitrick	10	2,268
Comparing two columns , and giving comparison results in a third. Colin Hayes	by Colin Hayes	6	593
Conditional Formatting Gord Dibben	by Jokah.D	5	372
Conditional Formatting RO	by T. Valko	3	505
PASSWORD PROTECTION JFW	by Shane Devenshire[_2_]	3	376
Multiple Workbooks I'm Me	by Don Guillett	1	357
correct syntax for nesting "if", "and", and "vlookup"....if possib Christine	by Christine	4	1,087
Where to begin??? PointerMan	by PointerMan	8	541
How do I create a spreadsheet that populates q's from a drop down Angela	by Angela	4	471
Macro to clear checkboxes Guy[_2_]	by Guy[_2_]	5	3,939
Combine an "IF" and "OR" statement Picman	by Picman	4	1,082
2003 to 2007 macro problem Russ Morgan	by Russ Morgan	3	476
Edits not saved when re-opening file SmartCookie	by Shane Devenshire[_2_]	1	379
Subtotal help!! ASAP!!!!!!!!! Report due by noon!!! DestinySky	by Shane Devenshire[_2_]	7	607
Flow data from one workbook to another cindyj	by JBeaucaire[_33_]	1	803
protection ?? Terry	by Shane Devenshire[_2_]	5	380
How do I select all cells with a value less than 1? PointerMan	by Gord Dibben	7	3,980
using mathmatical symbols in cells GO	by Spiky	9	537
Macro to select cells without a certain value and select a menu it Guy[_2_]	by Gord Dibben	9	1,308
Add print function Tim	by Gord Dibben	4	686
Find Cells that add up to Specific Sum BeachLover	by BeachLover	5	2,685
INDIRECT function Ernie Fenwick	by Dave Peterson	1	422
using an IF statement from a pull down box Jason	by Dave Peterson	7	615
calculating the sum of different categories over a given time peri JeffK	by Shane Devenshire[_2_]	4	453
Adding 3 columns of criteria simultaneously Michael Joseph Cosgriff	by OssieMac	3	489
Cross-referencing content of one worksheet with another Colin Hayes	by Pete_UK	9	460
Conditional Formatting Shane Devenshire[_2_]	by Jokah.D	1	692