Excel Worksheet Functions - Page 403

Thread / Thread Starter	Last Post	Replies	Views
array formulas disabled? erikheath	by erikheath	1	432
sumif function DAB	by DAB	2	348
Using sum(1/countif....) not returning expected result Kent (thanks)	by Kent (thanks)	10	1,092
SUM of INDEX lookups Liz Steffen	by Peo Sjoblom	3	1,232
How do I show numbers in Excel as 48K instead of 48000? Scotty	by Peo Sjoblom	2	491
IF Statements-call private sub CrimsonPlague29	by CrimsonPlague29	0	424
UserForm Save Issue DarnTootn	by DarnTootn	0	522
Multiple sheet acherony	by acherony	0	295
Gas Mileage Patsy	by Patsy	4	557
How can I use an IF statement to find out if the cell is shaded? Pascual	by JethroUK©	1	368
Saving worksheets within workbooks as individual files Colin Hayes	by Ron de Bruin	4	680
How can I count the number of times a letter repeats in a string? Wiley	by Bob Phillips	3	1,121
count number of letters in a string Wiley	by Ron Coderre	3	816
Find a value and return a corresponding number Irene	by Gary''s Student	3	1,043
IF Statement help please Alan Davies	by Bob Phillips	1	369
Excel Fed Up	by Chip Pearson	1	356
Is this formula going to work? yrose70	by Peo Sjoblom	1	398
How can I sum data on a row from certain named columns? Liliana	by Biff	1	445
Index function using multiple values in one cell [email protected]	by Biff	2	937
vlookup formula Ash	by Ash	2	504
Copying Sum Formulas Justin Hoffmann	by Peo Sjoblom	3	415
2nd to MAX Danny	by Danny	2	401
Date Population achapman	by achapman	5	592
Converting to Absolute Cell References - en bloc Basher Bates	by Peo Sjoblom	7	449
I need to know how to 'Colour Tabs' in Excel 2000 Fed Up	by Don Guillett	6	488
linking to a cell within a text cell or comment BlueJ2005	by BlueJ2005	0	452
How do I make hyperlinks? johnnstacy	by Peo Sjoblom	4	285
sum only visible cells hommer	by JLatham	5	802
How do I input a minus time in an excel spreadsheet Nadine NZ	by Lost for time	1	1,061
Create my own formula? james	by JLatham	2	379
Returning a Value if 3 Conditions are True brownie224	by David Biddulph	5	2,007
Copy a Workbook Automatically Len	by David Biddulph	1	394
Sort Problem - Please Hurry!! walleys25	by davesexcel	1	497
Modified /advance "Max function "may help!! PA	by PA	3	512
in data/filter/auto filter sp8	by Debra Dalgleish	2	904
Simple Circular Reference Problem Gary	by JLatham	2	406
Unlocking "check box" control function aliceinphx	by davesexcel	1	374
Excel, how do I count cell with data within a range? BRKirk	by Chip Pearson	2	515
If Match Part of Text Within Cell, Then Blank SteveC	by Biff	3	3,379
Calculate Elapsed Date and Time Gary F Shelton	by Fred Smith	3	2,022
IRR formula for monthly cash flows MB Burgis	by Fred Smith	3	2,129
Time calculations joe z	by Biff	1	441
Reference to Worksheet name SKY	by Biff	3	463
Summing every third cell bthieson	by Biff	6	404
V-LookUp help Asma Shah	by JMB	3	339
Seperate cell string into individual cells ERudy	by Biff	2	1,208
How to auto hide and unhide columns using 1 and 2 icons R. Rebello	by David D	1	684
How to incorporate cell data in a worksheet header John Bennett	by David D	1	367
Trnasferring/ Copying Data Between Sheets Neil M	by David D	1	1,190
Match and merge on new worksheet Traci	by David D	1	393
Finding values in a list Irene	by [email protected]	3	332
Is there any way to rotate the a field or cell 180 in excel? stephiestevenson	by David D	1	641
Does protecting a workbook shut off VBA code? Stilla	by David D	1	397
How does Excel allow for leap years? Neil	by Neil	2	985
Several Countif criteria Martin	by Martin	2	463
Arrows And Formulas Langoose	by Dav	2	417
Validation List edwardpestian	by Dav	4	376
Need help with two cell accumulator dlashley	by [email protected]	1	794
Tick Boxes blain	by Ardus Petus	3	585
"IF" Formula Query Langoose	by David Biddulph	3	425
Using nested IFs with CountIf Excel novice	by Bob Phillips	7	1,921
Multiple IFs prior to Count function Excel novice	by Excel novice	3	588
Extract information from the list 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	3	532
Excel extending result to multiple decimals dls2193	by Jerry W. Lewis	5	433
Filter record on color scheme Prashant	by Bob Phillips	1	588
template for taking customer food order mccheryl	by mccheryl	0	5,998
IF Statement help please - again - got it wrong last time! Alan Davies	by Bob Phillips	2	480
How do I vary the conditional formatting? Clyde	by Bob Phillips	1	312
How can I link sheet to the certain Excel document acherony	by acherony	0	366
IF Date range formula Phatbob	by mr_teacher	4	369
Need help with possible formula Michael Wise	by broro183	4	319
shortcut to last entry in a column inthestands	by Don Guillett	11	852
Linking 2 workbooks jacob	by fabiano	11	808
How to select automaticly the last cell not empty of a area? Bigmas	by Bernie Deitrick	1	405
Results of conditional formatting not what desired. How do I corr Clyde	by Clyde	8	390