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,020
How to Count values inside a cell when refered elsewhere? littlejess22	by Pete_UK	4	629
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? 4mula_freak[_2_]	by Ron Rosenfeld	3	1,448
dividing words in selected cells korund	by korund	2	558
Copy Workseet Within Same Workbook lehigh46	by JE McGimpsey	1	489
how do I highlight duplicates cells in excell prior to deletion Paul B[_2_]	by Paul B[_2_]	6	667
Multiple levels of sumif? Peter Bellis	by Peter Bellis	3	737
Searching a cells contents? SteW	by SteW	2	527
Why is it that ~ is not recognised when using vlookup/hlookup? P Koh[_2_]	by Bob Phillips	2	489
background color! [email protected]	by David Biddulph[_2_]	1	338
Drop down box filter Spanner	by Spanner	0	311
Count string IF..... Coley	by Harlan Grove[_2_]	4	604
Vlookup function Ivan	by T. Valko	2	341
Vlookup Approximate Match Question Craig	by Harlan Grove[_2_]	4	1,268
Pivottable columns multiply in excel 2007 Haffi	by Mike Skibyak	1	790
Variable within a formula Tom Melosi	by Harlan Grove[_2_]	4	492
EXCEL: Truncating Text Fields to allow Vlookup searches to find da burkeam1113	by Ron Rosenfeld	1	1,060
return in fractions with multiple divisors, linear rflock	by Ron Rosenfeld	2	603
input value of row and column populate from another worksheet Avidan	by JLatham	1	933
Setting column widths when mapping out a field trial. Candys Kisses	by Pete_UK	1	529
Macro - edit with macro Danny	by Danny	4	459
How do I make the cursor move down 8 cells each time i press enter Candys Kisses	by Candys Kisses	3	1,458
Sum function with asterisks DianeG	by Gord Dibben	3	860
sumproduct and sorting Lauren	by Lauren	4	931
Combining 2 INDEX/MATCH eq'ns; also 2 Sumproduct eq'ns RS	by RS	0	512
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D! FER	by PCLIVE	5	573
IRR Trouble jeff	by Ron Rosenfeld	1	475
Help! PRobelms with TODAY()?! Leonhardtk	by T. Valko	2	398
How do I freeze columns so the formula does not calculate anymore sbeeler	by Peo Sjoblom	1	505
sorting data equally- Pernella	by Pernella[_2_]	3	403
listing all numbers in range eg 13-87 gooner	by Ron Coderre	1	333
cell shading GUH	by Gord Dibben	4	359
Formula to List Results? Jen1170	by Jen1170	0	431
copying data down columns juliejg1	by Gord Dibben	4	503
Finding Nearest and Furthest Date carl	by Bob Phillips	4	2,786
using the google spreadsheets compactstu	by Harlan Grove[_2_]	12	961
AutoFilter Macro carl	by bj	1	422
reference cell from previous worksheet without "naming" worksheet Kristin	by Harlan Grove[_2_]	3	1,324
Array formula will not copy any further- Help ASAP! LJoe	by Harlan Grove[_2_]	1	414
formula for "does one cell equall another cell" merricasigns	by bj	1	377
Negative values in a formula Susan	by David Biddulph[_2_]	2	608
Index Array Formula Assistance LJoe	by LJoe	0	396
Excel Macro for Beginners Positive	by Positive	5	2,116
COUNTIF quandry JohnLute	by KL	6	571
Long formulae Yiannos	by Harlan Grove[_2_]	4	369
date format in Excel 2003 sptpensions	by sptpensions	4	462
Unsure of the Function, and How to Write It Jane	by Dave Peterson	3	513
filter zolabus	by Bernie Deitrick	1	368
Formula amendment to not remove digits Sarah (OGI)	by Sarah (OGI)	3	1,272
How do I set up a function that skips a cell in a fill? clubbhouse	by clubbhouse	8	527
HELP! Customer count issues... Pivot Table disaster HoganD87	by Debra Dalgleish	1	404
Need to determine the elapsed Minutes between 2 dates in excel EasyButton	by Toppers	3	543
How do I sum column D and F based on multiple column criteria? sharon t	by sharon t	12	1,279
locking cells dynamically Deano	by Gary''s Student	1	374
excel 2007 formula STEVE THE PARTS GUY	by Toppers	1	497
Adding hh:mm times in a row as part of a "named" cell Joe	by David Biddulph[_2_]	2	895
Names of workbook cell ranges not accepted with some signs zzxxcc	by zzxxcc	1	479
Changing a formula dynamically. mg_sv_r	by Duke Carey	2	454
Multiple lists Peter	by Toppers	2	430
Can I highlight one cell when clicking on another cell? Oldersox	by Duke Carey	1	918
Import External Text Data and Refreshing Problem Douglas	by Douglas	0	551
Copy and Paste of Relative Cell References Skyscan	by David Biddulph[_2_]	1	575
UserForm Question Mr BT[_3_]	by Mr BT[_3_]	0	463
How do i return data in a cell from the referred cell? SunnyWantsome	by OssieMac	2	501
grouping dialog box Marion	by Marion	2	628
Creating a pop up window Mr BT[_3_]	by Mr BT[_3_]	0	508
Perpetual Calendar Keyrookie	by Keyrookie	4	894
Count all but a specific reference cell (countif ?) + Steve	by Max	3	665
How do you Increment Time by varrying times??? Crackles McFarly	by Gord Dibben	7	592
Blank Cell/IF Problem N.Cassadine	by Ron Rosenfeld	2	396
Vlookup match greater than lookup value papio5949	by papio5949	4	1,586
Conditional formatting does not change when values change. ?? Texana	by Texana	4	745
Conditional Formatting - More than 3 conditions Madge	by Madge	2	597
Merged cell data tabulated in columns James	by James	4	613
Random Number Generation & VLOOKUP Gareth_80	by Gareth_80[_2_]	4	3,699