Excel Worksheet Functions - Page 500

Thread / Thread Starter	Last Post	Replies	Views
How do I calculate the z factor automatically khalid	by Sandy Mann	7	2,028
How to Count values inside a cell when refered elsewhere? littlejess22	by Pete_UK	4	638
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? 4mula_freak[_2_]	by Ron Rosenfeld	3	1,470
dividing words in selected cells korund	by korund	2	564
Copy Workseet Within Same Workbook lehigh46	by JE McGimpsey	1	496
how do I highlight duplicates cells in excell prior to deletion Paul B[_2_]	by Paul B[_2_]	6	672
Multiple levels of sumif? Peter Bellis	by Peter Bellis	3	743
Searching a cells contents? SteW	by SteW	2	536
Why is it that ~ is not recognised when using vlookup/hlookup? P Koh[_2_]	by Bob Phillips	2	500
background color! [email protected]	by David Biddulph[_2_]	1	346
Drop down box filter Spanner	by Spanner	0	316
Count string IF..... Coley	by Harlan Grove[_2_]	4	610
Vlookup function Ivan	by T. Valko	2	348
Vlookup Approximate Match Question Craig	by Harlan Grove[_2_]	4	1,276
Pivottable columns multiply in excel 2007 Haffi	by Mike Skibyak	1	796
Variable within a formula Tom Melosi	by Harlan Grove[_2_]	4	505
EXCEL: Truncating Text Fields to allow Vlookup searches to find da burkeam1113	by Ron Rosenfeld	1	1,073
return in fractions with multiple divisors, linear rflock	by Ron Rosenfeld	2	613
input value of row and column populate from another worksheet Avidan	by JLatham	1	940
Setting column widths when mapping out a field trial. Candys Kisses	by Pete_UK	1	536
Macro - edit with macro Danny	by Danny	4	464
How do I make the cursor move down 8 cells each time i press enter Candys Kisses	by Candys Kisses	3	1,466
Sum function with asterisks DianeG	by Gord Dibben	3	866
sumproduct and sorting Lauren	by Lauren	4	935
Combining 2 INDEX/MATCH eq'ns; also 2 Sumproduct eq'ns RS	by RS	0	517
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D! FER	by PCLIVE	5	583
IRR Trouble jeff	by Ron Rosenfeld	1	484
Help! PRobelms with TODAY()?! Leonhardtk	by T. Valko	2	406
How do I freeze columns so the formula does not calculate anymore sbeeler	by Peo Sjoblom	1	514
sorting data equally- Pernella	by Pernella[_2_]	3	410
listing all numbers in range eg 13-87 gooner	by Ron Coderre	1	338
cell shading GUH	by Gord Dibben	4	370
Formula to List Results? Jen1170	by Jen1170	0	437
copying data down columns juliejg1	by Gord Dibben	4	508
Finding Nearest and Furthest Date carl	by Bob Phillips	4	2,793
using the google spreadsheets compactstu	by Harlan Grove[_2_]	12	968
AutoFilter Macro carl	by bj	1	429
reference cell from previous worksheet without "naming" worksheet Kristin	by Harlan Grove[_2_]	3	1,331
Array formula will not copy any further- Help ASAP! LJoe	by Harlan Grove[_2_]	1	419
formula for "does one cell equall another cell" merricasigns	by bj	1	386
Negative values in a formula Susan	by David Biddulph[_2_]	2	616
Index Array Formula Assistance LJoe	by LJoe	0	405
Excel Macro for Beginners Positive	by Positive	5	2,122
COUNTIF quandry JohnLute	by KL	6	581
Long formulae Yiannos	by Harlan Grove[_2_]	4	376
date format in Excel 2003 sptpensions	by sptpensions	4	468
Unsure of the Function, and How to Write It Jane	by Dave Peterson	3	521
filter zolabus	by Bernie Deitrick	1	373
Formula amendment to not remove digits Sarah (OGI)	by Sarah (OGI)	3	1,279
How do I set up a function that skips a cell in a fill? clubbhouse	by clubbhouse	8	535
HELP! Customer count issues... Pivot Table disaster HoganD87	by Debra Dalgleish	1	411
Need to determine the elapsed Minutes between 2 dates in excel EasyButton	by Toppers	3	551
How do I sum column D and F based on multiple column criteria? sharon t	by sharon t	12	1,292
locking cells dynamically Deano	by Gary''s Student	1	380
excel 2007 formula STEVE THE PARTS GUY	by Toppers	1	503
Adding hh:mm times in a row as part of a "named" cell Joe	by David Biddulph[_2_]	2	902
Names of workbook cell ranges not accepted with some signs zzxxcc	by zzxxcc	1	488
Changing a formula dynamically. mg_sv_r	by Duke Carey	2	460
Multiple lists Peter	by Toppers	2	441
Can I highlight one cell when clicking on another cell? Oldersox	by Duke Carey	1	930
Import External Text Data and Refreshing Problem Douglas	by Douglas	0	561
Copy and Paste of Relative Cell References Skyscan	by David Biddulph[_2_]	1	583
UserForm Question Mr BT[_3_]	by Mr BT[_3_]	0	470
How do i return data in a cell from the referred cell? SunnyWantsome	by OssieMac	2	511
grouping dialog box Marion	by Marion	2	636
Creating a pop up window Mr BT[_3_]	by Mr BT[_3_]	0	517
Perpetual Calendar Keyrookie	by Keyrookie	4	913
Count all but a specific reference cell (countif ?) + Steve	by Max	3	676
How do you Increment Time by varrying times??? Crackles McFarly	by Gord Dibben	7	599
Blank Cell/IF Problem N.Cassadine	by Ron Rosenfeld	2	403
Vlookup match greater than lookup value papio5949	by papio5949	4	1,595
Conditional formatting does not change when values change. ?? Texana	by Texana	4	753
Conditional Formatting - More than 3 conditions Madge	by Madge	2	604
Merged cell data tabulated in columns James	by James	4	620
Random Number Generation & VLOOKUP Gareth_80	by Gareth_80[_2_]	4	3,707