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,458
How do I fix (prevent scrolling) of part of an Excel worksheet? katherin	by Pete_UK	2	1,251
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	433
help with vlookup, offset or match formula's Gary	by Gary	0	425
find a alphanumeric in a list 2226	by Shaun	2	485
Conditional PRODUCT or SUM Kevin H.	by Pete_UK	9	778
Need a Formula for Multiplication of Feet and Inches vmohan1978	by vmohan1978	6	3,975
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	622
Simple formula, I'm sure Connie Martin	by Shane Devenshire[_2_]	2	292
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,415
How to sum when the criteria and the range are in the same row? Mo	by Mo	2	381
Auto fill Certain data from Sheet 1 to Sheet 2 Coje	by Coje	0	696
Averaging blank or cells with Zeros in them. Glenn	by Glenn	4	654
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,305
I want to link totals on multiple worksheets into one total hugablek	by Gord Dibben	5	3,301
Protect workbook Keyrookie	by Gord Dibben	2	570
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	559
Referencing Relative Sheets jwatters	by jwatters	4	402
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	779
Insert selected cell value into next cell in range that is empty Guy[_2_]	by Guy[_2_]	6	1,127
SUM IF Duey on the lake	by Shane Devenshire[_2_]	3	411
Consistent 80% Success Rate Trading System Alpha Trader	by Fred Smith[_4_]	2	559
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	671
OR Function in VLookup Biff	by T. Valko	9	536
Analysis Toolpak-Confidence Level and data analysis questions MH	by MH	0	1,820
How do I set more than 1 target cell using MS Solver? n8wildey	by Dana DeLouis[_3_]	5	1,325
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	538
COUNTIF tcomm	by Shane Devenshire[_2_]	3	413
excel 2003 wildcards quynies_mom	by Shane Devenshire[_2_]	2	488
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,125
Test cell formulas Steven	by Steven	2	414
Is use of XIRR appropriate when dividends are not reinvested? Borty	by Borty	2	2,067
Regression and the confidence intervals Denis	by MH	3	1,828
Nesting SUMIF within SUMPRODUCT sj2008	by Bernie Deitrick	10	2,269
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	373
Conditional Formatting RO	by T. Valko	3	505
PASSWORD PROTECTION JFW	by Shane Devenshire[_2_]	3	378
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,091
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	473
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	479
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	609
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,981
using mathmatical symbols in cells GO	by Spiky	9	541
Macro to select cells without a certain value and select a menu it Guy[_2_]	by Gord Dibben	9	1,310
Add print function Tim	by Gord Dibben	4	687
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	454
Adding 3 columns of criteria simultaneously Michael Joseph Cosgriff	by OssieMac	3	491
Cross-referencing content of one worksheet with another Colin Hayes	by Pete_UK	9	461
Conditional Formatting Shane Devenshire[_2_]	by Jokah.D	1	692