Excel Worksheet Functions - Page 84

Thread / Thread Starter	Last Post	Replies	Views
month worksheet function returns wrong value Barry	by daddylonglegs	6	1,439
=countif (h3:h16"=01 01 2006") how to substitute cell for date Barry	by Barry	4	467
sort worksheet without affecting workbook Barry	by Gary L Brown	3	797
HELP - Have two lists and #1 needs #2's contents subtracted from it Barry Brown	by Frank Kabel	1	571
Multiples of 4 in an IF statement Barry Clark	by Barry Clark	3	1,035
New to Excel functions and need some help Barry Clark	by Peo Sjoblom	6	393
Getting only the filename with no extension Barry Clark	by bj	2	798
Combining references Barry Clark	by Marcelo	2	308
Date referencing Barry Clark	by Barry Clark	10	775
Excel formula not able to work this out barry duncan	by Spencer101	4	772
Can't Copy and Paste Barry Livingston	by CLR	2	1,123
Quarter End Date [email protected]	by [email protected]	6	7,190
Is it possible to make a cell flash between 2 colours? barry24uk	by barry24uk	6	513
formula calculation barry28	by barry28	4	536
Excel hyperlinks to other cells in workbook must be relative BarryB00	by BarryB00	0	903
Yieldmat function BarryHWhite	by JoeU2004	8	2,291
Getting column value based on month [email protected]	by kkchoh	2	396
Using a single cell refernce to change multiple formulas BarryL	by T. Valko	5	693
Copying a formula which uses indirect() BarryL	by Harlan Grove	5	597
How can I calculate weekly totals of daily data in Excel BarrySandell	by Peo Sjoblom	4	2,039
compare 5 columns of text and highlight duplicates based on repeti BarryTheCamper	by Herbert Seidenberg	2	1,481
match in excel Bart	by Bart	2	368
Days per month for calculating storage days Bart	by Bob Phillips	3	1,275
Hyperlink based on cell value in a different worksheet Bart	by Bart	3	2,301
Excel should spell-check all the cells together. Bart	by Bernie Deitrick	1	452
Excel should be able to give back the colorcode of a cell via celi Bart Schouw	by Arvi Laanemets	13	1,486
Special function Bart Steur	by Ron Rosenfeld	5	392
Formulae created from text strings will not compute. Bart Wolf	by Bart Wolf	6	543
Insert newline in cell through formula (excel 2003) Bart Wouters	by bj	2	4,242
Subtotals Nesting Error - Totals Above bart972	by bart972	0	454
Using Vlookup in formula arrays BartDesc	by Ron Rosenfeld	4	691
Auto Change Formulas - Please Help. [email protected]	by GS[_2_]	2	643
how do I perform a lookup on an 80,000 line array? Bartimus	by Harlan Grove	4	636
what is the maximum number of vlookups in a given workbook that E. Bartman	by Chip Pearson	2	1,003
Calculate interest rate on long term investment Bartman	by macropod[_2_]	1	1,308
Sorting characters, ignoring numbers Barto9729	by [email protected]	7	1,328
Formulas Becoming Inactive?!? Barton	by David Biddulph[_2_]	1	619
Dynamic Range Name that's driving me nuts [email protected]	by GS[_6_]	8	1,670
Lookup function BAS	by BAS	3	340
Function to populate cells?? BAS	by BAS	3	714
IF function BAS	by Pete_UK	4	335
How do I get to master Excel functions and formulas? Basabjit Chowdhury	by Gord Dibben	3	1,388
How to make cell not editable [email protected]	by Joerg Mochikun	1	3,270
what is clearing an assumption? Bascious	by Bascious	0	564
Against Bascious	by tjtjjtjt	1	416
Zero replaces blank field when paste special is used Baseball Greg	by Jerry W. Lewis	5	861
Count occurances of multiple values BaseballFan	by BaseballFan	2	766
Counting multiple occurances of a specific string BaseballFan	by CLR	1	588
Protected worksheet baseballmm	by Harlan Grove[_2_]	1	734
how do you find the SD(standard deviation ) for the multiple reg Basem Salman	by Jerry W. Lewis	2	1,295
Adding Days and Hours Basenji	by Basenji	8	528
Count between two dates using sumproduct Basenji	by Max	6	2,961
Count based on single number in string Basenji	by T. Valko	7	588
count based on single number Basenji	by Basenji	13	959
Rank and Sort Basenji	by T. Valko	15	1,500
Count based on 2 conditions Basenji	by Basenji	4	889
Rank in ascending order in Excel 2003 Basenji	by T. Valko	5	1,391
Counting number of times name occurs between two dates Basenji	by Basenji	2	1,555
Average using Sumproduct Basenji	by Joe User[_2_]	4	3,943
Multiple criteria in autofilter BASFMark	by Michael	1	609
How to compare a row data from one worksheet to another worksheet bash	by Herbert Seidenberg	5	2,670
Some cells have been colored and should be replaced by text basha	by Jim Cone	1	507
Difficulties with date in conditional calculations Basha	by Basha	2	411
what causes this error" too many different cell formats" Bashar	by Ron Rosenfeld	3	353
contents of 1 combo box depends on choice of another Basheed Bazi	by William DeLeo	2	478
I am getting incorrect answers in adding and subtraction Basher	by Niek Otten	2	428
Total width of several columns. Basher Bates	by Basher Bates	2	685
Conditionally format one cell for contents of another? Basher Bates	by bpeltzer	2	438
Converting to Absolute Cell References - en bloc Basher Bates	by Peo Sjoblom	7	450
Lost text & fill colors from worksheet Basher Bates	by Gord Dibben	1	946
Formula Help Bashful18	by JBeaucaire[_131_]	1	414
HOW TO CHANGE BAHTTEXT (THAI TEXT) TO ENGLISH TEXT IN EXCEL BASHIR	by BASHIR	0	2,612
COUNTIF STOPS COUNTING bashtherat	by bashtherat	12	1,491
How to compare 3 numbers and return value basic	by Myrna Larson	6	848
Subtotal basic	by basic	0	432