Excel Worksheet Functions - Page 501

Thread / Thread Starter	Last Post	Replies	Views
sumproduct and sorting Lauren	by Lauren	4	888
Combining 2 INDEX/MATCH eq'ns; also 2 Sumproduct eq'ns RS	by RS	0	459
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D! FER	by PCLIVE	5	526
IRR Trouble jeff	by Ron Rosenfeld	1	429
Help! PRobelms with TODAY()?! Leonhardtk	by T. Valko	2	363
How do I freeze columns so the formula does not calculate anymore sbeeler	by Peo Sjoblom	1	467
sorting data equally- Pernella	by Pernella[_2_]	3	377
listing all numbers in range eg 13-87 gooner	by Ron Coderre	1	305
cell shading GUH	by Gord Dibben	4	318
Formula to List Results? Jen1170	by Jen1170	0	394
copying data down columns juliejg1	by Gord Dibben	4	451
Finding Nearest and Furthest Date carl	by Bob Phillips	4	2,649
using the google spreadsheets compactstu	by Harlan Grove[_2_]	12	903
AutoFilter Macro carl	by bj	1	385
reference cell from previous worksheet without "naming" worksheet Kristin	by Harlan Grove[_2_]	3	1,248
Array formula will not copy any further- Help ASAP! LJoe	by Harlan Grove[_2_]	1	359
formula for "does one cell equall another cell" merricasigns	by bj	1	327
Negative values in a formula Susan	by David Biddulph[_2_]	2	530
Index Array Formula Assistance LJoe	by LJoe	0	345
Excel Macro for Beginners Positive	by Positive	5	2,068
COUNTIF quandry JohnLute	by KL	6	513
Long formulae Yiannos	by Harlan Grove[_2_]	4	313
date format in Excel 2003 sptpensions	by sptpensions	4	404
Unsure of the Function, and How to Write It Jane	by Dave Peterson	3	423
filter zolabus	by Bernie Deitrick	1	304
Formula amendment to not remove digits Sarah (OGI)	by Sarah (OGI)	3	1,232
How do I set up a function that skips a cell in a fill? clubbhouse	by clubbhouse	8	484
HELP! Customer count issues... Pivot Table disaster HoganD87	by Debra Dalgleish	1	373
Need to determine the elapsed Minutes between 2 dates in excel EasyButton	by Toppers	3	496
How do I sum column D and F based on multiple column criteria? sharon t	by sharon t	12	1,230
locking cells dynamically Deano	by Gary''s Student	1	311
excel 2007 formula STEVE THE PARTS GUY	by Toppers	1	463
Adding hh:mm times in a row as part of a "named" cell Joe	by David Biddulph[_2_]	2	854
Names of workbook cell ranges not accepted with some signs zzxxcc	by zzxxcc	1	427
Changing a formula dynamically. mg_sv_r	by Duke Carey	2	407
Multiple lists Peter	by Toppers	2	383
Can I highlight one cell when clicking on another cell? Oldersox	by Duke Carey	1	850
Import External Text Data and Refreshing Problem Douglas	by Douglas	0	514
Copy and Paste of Relative Cell References Skyscan	by David Biddulph[_2_]	1	491
UserForm Question Mr BT[_3_]	by Mr BT[_3_]	0	432
How do i return data in a cell from the referred cell? SunnyWantsome	by OssieMac	2	461
grouping dialog box Marion	by Marion	2	597
Creating a pop up window Mr BT[_3_]	by Mr BT[_3_]	0	471
Perpetual Calendar Keyrookie	by Keyrookie	4	839
Count all but a specific reference cell (countif ?) + Steve	by Max	3	627
How do you Increment Time by varrying times??? Crackles McFarly	by Gord Dibben	7	559
Blank Cell/IF Problem N.Cassadine	by Ron Rosenfeld	2	356
Vlookup match greater than lookup value papio5949	by papio5949	4	1,538
Conditional formatting does not change when values change. ?? Texana	by Texana	4	703
Conditional Formatting - More than 3 conditions Madge	by Madge	2	549
Merged cell data tabulated in columns James	by James	4	578
Random Number Generation & VLOOKUP Gareth_80	by Gareth_80[_2_]	4	3,544
scanning worksheet for data then adding it Steve	by Toppers	4	795
Best/Worst grade Aivis	by Toppers	8	608
How to skip the save file notoification on file closing? Dan	by Mike H	1	514
HOW DO I SAVE A PORTION OF A WORKSHEET ON A FLOPPY DISK? asifuah	by squenson via OfficeKB.com	1	452
Listing & Counting Problem Russell	by squenson via OfficeKB.com	1	356
Enter multiple numbers in a cell so total shows when enter keypres newbie	by Stan Brown	2	1,040
Linking multiple cells between workbooks Ruth	by Ruth	2	490
I need to easily add checkmarks to indicate "done" items butterflykaty	by Bob Phillips	1	443
Conditional Formatting Valdemar	by Valdemar[_2_]	2	391
help! butters	by butters	3	425
More questions about copying Mr BT[_3_]	by Mr BT[_3_]	1	354
count blanks in pivot table Khoshravan	by Khoshravan	3	1,191
Sum uniques across worksheets with criteria Fin Fang Foom	by Fin Fang Foom	7	328
how to look up an approximate value in two columns Deise BR	by Max	3	791
Countif and Sumproduct Sandy	by JLatham	4	557
INDEX/MATCH skipping results RS	by RS	3	542
Conditional Drop-Down Menu Mike Dantuono	by Toppers	1	678
Using Named Formulas General Specific	by Steve G	2	304
Filling a series into a non-empty column Kathleen	by Gord Dibben	1	467
adding up columns in excel 2002 Techno Grandma	by Techno Grandma	5	523
how to install a drop down list excel 2002 Techno Grandma	by Techno Grandma	4	1,358
How to apply an automatic format to a column? AussieBumBxl	by Gord Dibben	2	383
frequency function and list features Johnny Jebel	by Ron Coderre	5	664