Excel Worksheet Functions - Page 1070

Thread / Thread Starter	Last Post	Replies	Views
Hyperlink Formula Problem Keith Howie	by MRT	2	782
Using the Countif, Countifs option for Excel mlkkrs	by mlkkrs	6	529
Please can you help me Matt via OfficeKB.com	by Glenn	7	481
returned calculation incorrect Gotroots	by Jacob Skaria	6	464
Macro error when trying to open workbook paankadu	by Jacob Skaria	6	685
Help Please - Lookup in an array that has duplicte values CBI FlexCard	by Jacob Skaria	2	436
Complex Date Functions Simon Heaven	by T. Valko	6	912
Return a value from Chart 1 depending on the value typed into char Folletti	by Jacob Skaria	1	480
exclude non numbers johnnyk	by T. Valko	2	2,481
matching 1 to 1 and 1 with variations... srmyers1	by Jacob Skaria	3	502
Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b. Bongo	by Jacob Skaria	1	557
Execel file auto save Sam	by Jacob Skaria	1	514
Why can't I sum several vlookups ?? Friday	by T. Valko	5	739
I need to delete the values in some cells, Skip[_2_]	by Glenn	5	495
Conditional formatting based on Cell Value and another cell's valu Nebulous	by LJL	9	521
Palindromes Luciano Paulino da Silva	by Bernie Deitrick	1	639
Easily mailing list from Data File OHDookie	by JCS	3	413
XIRR #Num! Error RAB1203	by Squeaky	2	2,197
How do you add 1 to an invoice number in Excel. loisamor	by Jacob Skaria	1	570
Summing one column based on criteria from two other columns glinishmak	by T. Valko	2	1,142
Match with 3 criteria Tom Davis	by Tom Davis	3	726
INDEX, MATCH, IF function does not work Michael[_7_]	by smartin	3	1,794
Help Pls Copy 1 Random Result To Many On Another Sheet? narrator	by narrator	2	419
IF statement and text bob	by Jacob Skaria	5	455
Renaming a file while maintaining links Curtis	by Farhan	2	1,647
Multiple levels of worksheet protection jvs	by Farhan	1	664
IF THEN PAL	by Niek Otten	4	456
vlookup Function Farhan	by Jacob Skaria	2	442
AVERAGEIF Shelina	by Shelina	4	572
One command in one cell initiating another command in another cel. Chas52	by Tom Hutchins	3	566
Why is AutoSum iinoperable w/protection when column is unlocked? RSE	by CellShocked	2	742
Conditional sum wizard ronb	by T. Valko	3	497
MIN from another worksheet Shelina	by Jacob Skaria	5	470
help simple SUM jmfozzybear	by jmfozzybear	3	381
with "show formulas" justify rfdh	by Martin Fishlock	2	526
DAVERAGE, MIN, and MAX from another worksheet Shelina	by Ashish Mathur[_2_]	2	493
Lookup Wizard MAX	by Jacob Skaria	4	527
nested sumif? Rachel	by Rachel	3	1,284
complex if statement kdel1201	by Jacob Skaria	1	548
IF statement and Combo Boxes nkwherron	by CellShocked	2	474
formula for sum afdmello	by David Biddulph[_2_]	4	505
Permanently linking Column A in many worksheets Tchipu	by zvkmpw	3	681
Can MSN Money stock quotes be used in Excel 2007. Smart tags suck taftpr	by taftpr	0	1,355
Using Excel in Formatted Output John[_31_]	by John[_31_]	2	748
Nested IFs Pieyed Piper	by Don Guillett	1	442
PMT function and 1st payment partway through a period Robbie G	by Joe User[_2_]	3	1,055
How do I customize the available fraction formats to fourteenths? dmowday	by Bernard Liengme[_3_]	1	721
[Q] How to use Excel to show est. compounded value displayed by mo JohnH	by Fred Smith[_4_]	2	497
account # entry needs to return the account description placerpone	by T. Valko[_2_]	1	983
% Variance Abdul[_2_]	by Abdul[_2_]	3	612
simple sum unless blank Cheryl	by Eduardo	5	824
pivot table field structure! via135	by via135	0	407
Running total for 2 columns IF column 3....... paulab	by Teethless mama	7	643
simple formula help Cheryl	by WKH8919	5	468
COUNTIF - across 2 columns Rebekah	by David Biddulph[_2_]	11	1,093
Long list into Table to contain only ten Chris Hough	by T. Valko	2	404
Account # is a known the description is not, need to create a look placerpone	by Daryl S	2	470
Compare 2 columns and align duplicates into same row AGOLFA	by Otto Moehrbach[_2_]	8	3,676
Product formula help txsharla	by txsharla	4	474
Format dates from cvf file Janet Kreinbrink	by Janet Kreinbrink[_2_]	5	717
Lookup a location # with multiple dates Andrea	by ryguy7272	2	499
Converting Pounfs to US Dollars Tom	by Sean Timmons	3	459
Can Excel look thru column of text & derive most commone camsown	by ryguy7272	4	659
Summing values within a matrix who are both in a column where theheaders are within a certain numerical range and in a row where the rowheaders are specified. Andy	by Andy	4	556
Data validation error message not showing raphiel2063	by Tom Hutchins	1	1,483
produce a criteria based list MarkN	by MarkN	5	811
Week ending calculation Michelle	by Ashish Mathur[_2_]	6	4,284
The ____ qualifier references the header row in the table. David Simmons	by Fred Smith[_4_]	2	1,345
simple counting gone awry Nondisclosure007	by Joe User[_2_]	3	463
Workaround no COUNTIFS in 2003 fay	by Teethless mama	5	1,598
data entry needs to be changed in multiple files drrons	by ryguy7272	1	610
12 dependent series Elton Law[_2_]	by Elton Law[_2_]	5	386
Limit access to range of cells jvs	by Chaitanya Sagar[_2_]	1	891
multiplying by variables based off original number jato	by Hans Terkelsen	3	478
Formatting cell WLMPilot	by Eduardo	4	358