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,038
How to Count values inside a cell when refered elsewhere? littlejess22	by Pete_UK	4	650
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? 4mula_freak[_2_]	by Ron Rosenfeld	3	1,483
dividing words in selected cells korund	by korund	2	565
Copy Workseet Within Same Workbook lehigh46	by JE McGimpsey	1	509
how do I highlight duplicates cells in excell prior to deletion Paul B[_2_]	by Paul B[_2_]	6	681
Multiple levels of sumif? Peter Bellis	by Peter Bellis	3	746
Searching a cells contents? SteW	by SteW	2	539
Why is it that ~ is not recognised when using vlookup/hlookup? P Koh[_2_]	by Bob Phillips	2	501
background color! [email protected]	by David Biddulph[_2_]	1	349
Drop down box filter Spanner	by Spanner	0	320
Count string IF..... Coley	by Harlan Grove[_2_]	4	618
Vlookup function Ivan	by T. Valko	2	355
Vlookup Approximate Match Question Craig	by Harlan Grove[_2_]	4	1,283
Pivottable columns multiply in excel 2007 Haffi	by Mike Skibyak	1	811
Variable within a formula Tom Melosi	by Harlan Grove[_2_]	4	516
EXCEL: Truncating Text Fields to allow Vlookup searches to find da burkeam1113	by Ron Rosenfeld	1	1,083
return in fractions with multiple divisors, linear rflock	by Ron Rosenfeld	2	621
input value of row and column populate from another worksheet Avidan	by JLatham	1	952
Setting column widths when mapping out a field trial. Candys Kisses	by Pete_UK	1	543
Macro - edit with macro Danny	by Danny	4	474
How do I make the cursor move down 8 cells each time i press enter Candys Kisses	by Candys Kisses	3	1,467
Sum function with asterisks DianeG	by Gord Dibben	3	879
sumproduct and sorting Lauren	by Lauren	4	948
Combining 2 INDEX/MATCH eq'ns; also 2 Sumproduct eq'ns RS	by RS	0	525
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D! FER	by PCLIVE	5	596
IRR Trouble jeff	by Ron Rosenfeld	1	490
Help! PRobelms with TODAY()?! Leonhardtk	by T. Valko	2	409
How do I freeze columns so the formula does not calculate anymore sbeeler	by Peo Sjoblom	1	522
sorting data equally- Pernella	by Pernella[_2_]	3	423
listing all numbers in range eg 13-87 gooner	by Ron Coderre	1	338
cell shading GUH	by Gord Dibben	4	371
Formula to List Results? Jen1170	by Jen1170	0	441
copying data down columns juliejg1	by Gord Dibben	4	516
Finding Nearest and Furthest Date carl	by Bob Phillips	4	2,800
using the google spreadsheets compactstu	by Harlan Grove[_2_]	12	980
AutoFilter Macro carl	by bj	1	434
reference cell from previous worksheet without "naming" worksheet Kristin	by Harlan Grove[_2_]	3	1,334
Array formula will not copy any further- Help ASAP! LJoe	by Harlan Grove[_2_]	1	429
formula for "does one cell equall another cell" merricasigns	by bj	1	386
Negative values in a formula Susan	by David Biddulph[_2_]	2	623
Index Array Formula Assistance LJoe	by LJoe	0	407
Excel Macro for Beginners Positive	by Positive	5	2,131
COUNTIF quandry JohnLute	by KL	6	587
Long formulae Yiannos	by Harlan Grove[_2_]	4	376
date format in Excel 2003 sptpensions	by sptpensions	4	471
Unsure of the Function, and How to Write It Jane	by Dave Peterson	3	523
filter zolabus	by Bernie Deitrick	1	381
Formula amendment to not remove digits Sarah (OGI)	by Sarah (OGI)	3	1,290
How do I set up a function that skips a cell in a fill? clubbhouse	by clubbhouse	8	544
HELP! Customer count issues... Pivot Table disaster HoganD87	by Debra Dalgleish	1	413
Need to determine the elapsed Minutes between 2 dates in excel EasyButton	by Toppers	3	562
How do I sum column D and F based on multiple column criteria? sharon t	by sharon t	12	1,303
locking cells dynamically Deano	by Gary''s Student	1	385
excel 2007 formula STEVE THE PARTS GUY	by Toppers	1	511
Adding hh:mm times in a row as part of a "named" cell Joe	by David Biddulph[_2_]	2	904
Names of workbook cell ranges not accepted with some signs zzxxcc	by zzxxcc	1	500
Changing a formula dynamically. mg_sv_r	by Duke Carey	2	470
Multiple lists Peter	by Toppers	2	451
Can I highlight one cell when clicking on another cell? Oldersox	by Duke Carey	1	945
Import External Text Data and Refreshing Problem Douglas	by Douglas	0	571
Copy and Paste of Relative Cell References Skyscan	by David Biddulph[_2_]	1	595
UserForm Question Mr BT[_3_]	by Mr BT[_3_]	0	471
How do i return data in a cell from the referred cell? SunnyWantsome	by OssieMac	2	522
grouping dialog box Marion	by Marion	2	650
Creating a pop up window Mr BT[_3_]	by Mr BT[_3_]	0	518
Perpetual Calendar Keyrookie	by Keyrookie	4	913
Count all but a specific reference cell (countif ?) + Steve	by Max	3	682
How do you Increment Time by varrying times??? Crackles McFarly	by Gord Dibben	7	605
Blank Cell/IF Problem N.Cassadine	by Ron Rosenfeld	2	407
Vlookup match greater than lookup value papio5949	by papio5949	4	1,605
Conditional formatting does not change when values change. ?? Texana	by Texana	4	766
Conditional Formatting - More than 3 conditions Madge	by Madge	2	616
Merged cell data tabulated in columns James	by James	4	625
Random Number Generation & VLOOKUP Gareth_80	by Gareth_80[_2_]	4	3,720