Excel Worksheet Functions - Page 191

Thread / Thread Starter	Last Post	Replies	Views
Form & Data Sheet??????? Chris Watson	by Bernie Deitrick	7	389
Macro to open new sheet?????? Chris Watson	by Anne Troy	1	1,162
Rounding to price points Chris Wetz	by Ron Rosenfeld	6	857
Moving formulas Chris White feeling dumb!	by Bob Phillips	3	359
Link to external link Chris Wong	by Chris Wong	0	621
Finding the Row number based on contents of a cell Chris Youlden	by Chris Youlden	5	2,135
Running a macro from an auto-refresh Chris Youlden	by Chris Youlden	2	1,413
Alphabetizing the tabs Chris Zrepskey	by Chip Pearson	2	394
formulas/data validation CHRIS...in trouble	by Barb Reinhardt	1	463
Summing partial strings. [email protected]	by Ashish Mathur	4	741
Average of last three rows against another column [email protected]	by [email protected]	10	800
Automatic cell colouring Chris01623	by Miguel Zapico	1	529
CountIf & null values problem chris100	by chris100	3	583
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC	by ExcelBanter AI	2	7,539
Arithmatic functions with date format...angry results chris23892 via OfficeKB.com	by Pete_UK	7	497
Max Value - based on a time period Chris26	by JoeU2004	3	1,087
average if - between range Chris26	by Jacob Skaria	2	3,748
Ignore Zero's - Percentile Chris26	by Mike H	1	3,035
SUMPRODUCT, MAX, Few Criteria Chris26	by Chris26	4	807
Max Value, Sum Product, Between Date Range Chris26	by Chris26	4	2,866
VLookup+ Monthly Data Chris26	by Bernard Liengme[_3_]	5	844
use sumif / Sumproduct for year data Chris26	by Jacob Skaria	5	551
maximum value (for a calendar date) Chris26	by T. Valko	3	579
Variable Criteria? chris2bc	by chris2bc	2	467
Stop Excel Changing Format Chris762	by Rob van Gelder	4	764
set hypothetical values for a cell chris8715	by Max	1	1,035
Fill down with references to worksheets [email protected]	by Zumble	3	479
Protecting Excel Formulas Chris@Preston	by Gord Dibben	3	633
File Names [email protected]	by Allllen	1	367
Page Numbers ChrisA	by ChrisA	0	458
ANDIF (i think) chrisabberton	by Myrna Larson	4	1,023
Lookup Hi / Lo chrisabberton	by Domenic	8	311
failure to update conditional formatting ChrisACV	by cisco kid	2	662
Cut and Paste entire row from one worksheet to another [email protected]	by [email protected]	5	1,014
Cut and Paste entire row from one worksheet to another [email protected]	by [email protected]	0	580
seperating days of week in a database chrisandfarah	by Duke Carey	1	589
how do I locate a cell that provides data to a formula ? chrisatminara	by JulieD	2	586
how do I locate a cell that provides data to a formula ? chrisatminara	by chrisatminara	0	711
count function ChrisC	by ChrisC	5	717
Can't get sensible clear colours in Excel 2003 chrisco	by Bernie Deitrick	1	378
look ups chrisgoods	by Max	4	346
Question about decimal places chrisgoulden	by Pete	4	491
How Do I reverse axis in a spreadsheet ChrisH	by Max	3	1,299
Simple lookup - or maybe not so simple - help! ChrisHodds	by vezerid	1	670
Autofilter after hyperlink to a page chrishop6	by Anne Troy	1	1,809
Capitalize only first letter in sentence ChrisHT	by Chip Pearson	1	3,724
Converting numbers to text Chrisj20	by Gord Dibben	2	416
Formulas Chrisj20	by David McRitchie	3	299
how do i convert a column of minutes into hours Chrisj20	by Gary''s Student	2	553
Conditional Delete Statement chrisjack001	by chrisjack001	0	803
Adding data to another table in database based on condition chrisjack001	by chrisjack001	0	954
Formatting Field chrisjack001	by chrisjack001	0	838
Adding letter P to Cell chrisjack001	by chrisjack001	0	877
Time formatting - Excel 2003 ChrisJM	by Claus Busch	1	664
Pulling/Collating Data from Workbooks chrisk	by Roger Govier[_8_]	6	547
Pulling/Collating Data chrisk	by chrisk	4	483
Spell Check in Protected Work Book ChrisK	by Gord Dibben	2	639
Ability to change the Excel comment indicator color ChrisK	by ChrisK	0	1,157
How to use RIGHT() in sumproduct chrisk	by Gary''s Student	1	1,058
Absoluet Reference ChrisK	by Maarkr	9	403
Max number in list of duplicates chrisk	by chrisk	9	570
How to count/tally entries? chrisk	by chrisk	2	869
How to filter using background colour? chrisk	by Ron de Bruin	1	486
SUMPRODUCT OR COUNTIF chrisk	by chrisk	6	498
How to count across multiple worksheets? chrisk	by chrisk	4	991
how to clear data chrisk	by MartinW[_2_]	3	319
How to work with Many Worksheets chrisk	by Peggy	3	475
Search, cut & paste chrisk	by chrisk	0	404
cut & paste IF? chrisk	by Bernard Liengme	1	355
chart types chrisk	by Mike Middleton	1	627
how can I find which cells in a dataset equal a specific value chrisk	by chrisk	1	974
How to populate a table? chrisk	by chrisk	0	382
Automatically Close Dialog Boxes chriskane	by Alan	2	1,798
Rows to columns with multiple sets chrisL	by ~L	1	544
Problems appending cells together ChrisL	by Gord Dibben	5	492