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,006
How to Count values inside a cell when refered elsewhere? littlejess22	by Pete_UK	4	613
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? 4mula_freak[_2_]	by Ron Rosenfeld	3	1,429
dividing words in selected cells korund	by korund	2	542
Copy Workseet Within Same Workbook lehigh46	by JE McGimpsey	1	467
how do I highlight duplicates cells in excell prior to deletion Paul B[_2_]	by Paul B[_2_]	6	643
Multiple levels of sumif? Peter Bellis	by Peter Bellis	3	718
Searching a cells contents? SteW	by SteW	2	508
Why is it that ~ is not recognised when using vlookup/hlookup? P Koh[_2_]	by Bob Phillips	2	470
background color! [email protected]	by David Biddulph[_2_]	1	332
Drop down box filter Spanner	by Spanner	0	306
Count string IF..... Coley	by Harlan Grove[_2_]	4	571
Vlookup function Ivan	by T. Valko	2	331
Vlookup Approximate Match Question Craig	by Harlan Grove[_2_]	4	1,242
Pivottable columns multiply in excel 2007 Haffi	by Mike Skibyak	1	776
Variable within a formula Tom Melosi	by Harlan Grove[_2_]	4	472
EXCEL: Truncating Text Fields to allow Vlookup searches to find da burkeam1113	by Ron Rosenfeld	1	1,042
return in fractions with multiple divisors, linear rflock	by Ron Rosenfeld	2	579
input value of row and column populate from another worksheet Avidan	by JLatham	1	911
Setting column widths when mapping out a field trial. Candys Kisses	by Pete_UK	1	521
Macro - edit with macro Danny	by Danny	4	440
How do I make the cursor move down 8 cells each time i press enter Candys Kisses	by Candys Kisses	3	1,440
Sum function with asterisks DianeG	by Gord Dibben	3	847
sumproduct and sorting Lauren	by Lauren	4	912
Combining 2 INDEX/MATCH eq'ns; also 2 Sumproduct eq'ns RS	by RS	0	486
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D! FER	by PCLIVE	5	550
IRR Trouble jeff	by Ron Rosenfeld	1	453
Help! PRobelms with TODAY()?! Leonhardtk	by T. Valko	2	383
How do I freeze columns so the formula does not calculate anymore sbeeler	by Peo Sjoblom	1	488
sorting data equally- Pernella	by Pernella[_2_]	3	392
listing all numbers in range eg 13-87 gooner	by Ron Coderre	1	318
cell shading GUH	by Gord Dibben	4	352
Formula to List Results? Jen1170	by Jen1170	0	422
copying data down columns juliejg1	by Gord Dibben	4	486
Finding Nearest and Furthest Date carl	by Bob Phillips	4	2,744
using the google spreadsheets compactstu	by Harlan Grove[_2_]	12	943
AutoFilter Macro carl	by bj	1	409
reference cell from previous worksheet without "naming" worksheet Kristin	by Harlan Grove[_2_]	3	1,280
Array formula will not copy any further- Help ASAP! LJoe	by Harlan Grove[_2_]	1	399
formula for "does one cell equall another cell" merricasigns	by bj	1	355
Negative values in a formula Susan	by David Biddulph[_2_]	2	574
Index Array Formula Assistance LJoe	by LJoe	0	380
Excel Macro for Beginners Positive	by Positive	5	2,105
COUNTIF quandry JohnLute	by KL	6	544
Long formulae Yiannos	by Harlan Grove[_2_]	4	355
date format in Excel 2003 sptpensions	by sptpensions	4	439
Unsure of the Function, and How to Write It Jane	by Dave Peterson	3	490
filter zolabus	by Bernie Deitrick	1	356
Formula amendment to not remove digits Sarah (OGI)	by Sarah (OGI)	3	1,252
How do I set up a function that skips a cell in a fill? clubbhouse	by clubbhouse	8	511
HELP! Customer count issues... Pivot Table disaster HoganD87	by Debra Dalgleish	1	385
Need to determine the elapsed Minutes between 2 dates in excel EasyButton	by Toppers	3	521
How do I sum column D and F based on multiple column criteria? sharon t	by sharon t	12	1,258
locking cells dynamically Deano	by Gary''s Student	1	340
excel 2007 formula STEVE THE PARTS GUY	by Toppers	1	485
Adding hh:mm times in a row as part of a "named" cell Joe	by David Biddulph[_2_]	2	877
Names of workbook cell ranges not accepted with some signs zzxxcc	by zzxxcc	1	465
Changing a formula dynamically. mg_sv_r	by Duke Carey	2	436
Multiple lists Peter	by Toppers	2	414
Can I highlight one cell when clicking on another cell? Oldersox	by Duke Carey	1	900
Import External Text Data and Refreshing Problem Douglas	by Douglas	0	530
Copy and Paste of Relative Cell References Skyscan	by David Biddulph[_2_]	1	532
UserForm Question Mr BT[_3_]	by Mr BT[_3_]	0	456
How do i return data in a cell from the referred cell? SunnyWantsome	by OssieMac	2	484
grouping dialog box Marion	by Marion	2	611
Creating a pop up window Mr BT[_3_]	by Mr BT[_3_]	0	494
Perpetual Calendar Keyrookie	by Keyrookie	4	870
Count all but a specific reference cell (countif ?) + Steve	by Max	3	650
How do you Increment Time by varrying times??? Crackles McFarly	by Gord Dibben	7	578
Blank Cell/IF Problem N.Cassadine	by Ron Rosenfeld	2	378
Vlookup match greater than lookup value papio5949	by papio5949	4	1,568
Conditional formatting does not change when values change. ?? Texana	by Texana	4	728
Conditional Formatting - More than 3 conditions Madge	by Madge	2	584
Merged cell data tabulated in columns James	by James	4	596
Random Number Generation & VLOOKUP Gareth_80	by Gareth_80[_2_]	4	3,587