Excel Worksheet Functions - Page 684

Thread / Thread Starter	Last Post	Replies	Views
How do I set up a function that skips a cell in a fill? clubbhouse	by clubbhouse	8	513
Formula amendment to not remove digits Sarah (OGI)	by Sarah (OGI)	3	1,259
filter zolabus	by Bernie Deitrick	1	366
Unsure of the Function, and How to Write It Jane	by Dave Peterson	3	504
date format in Excel 2003 sptpensions	by sptpensions	4	451
Long formulae Yiannos	by Harlan Grove[_2_]	4	359
COUNTIF quandry JohnLute	by KL	6	555
Excel Macro for Beginners Positive	by Positive	5	2,110
Index Array Formula Assistance LJoe	by LJoe	0	390
Negative values in a formula Susan	by David Biddulph[_2_]	2	590
formula for "does one cell equall another cell" merricasigns	by bj	1	363
Array formula will not copy any further- Help ASAP! LJoe	by Harlan Grove[_2_]	1	402
reference cell from previous worksheet without "naming" worksheet Kristin	by Harlan Grove[_2_]	3	1,317
AutoFilter Macro carl	by bj	1	415
using the google spreadsheets compactstu	by Harlan Grove[_2_]	12	950
Finding Nearest and Furthest Date carl	by Bob Phillips	4	2,764
copying data down columns juliejg1	by Gord Dibben	4	490
Formula to List Results? Jen1170	by Jen1170	0	423
cell shading GUH	by Gord Dibben	4	353
listing all numbers in range eg 13-87 gooner	by Ron Coderre	1	326
sorting data equally- Pernella	by Pernella[_2_]	3	393
How do I freeze columns so the formula does not calculate anymore sbeeler	by Peo Sjoblom	1	492
Help! PRobelms with TODAY()?! Leonhardtk	by T. Valko	2	391
IRR Trouble jeff	by Ron Rosenfeld	1	464
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D! FER	by PCLIVE	5	556
Combining 2 INDEX/MATCH eq'ns; also 2 Sumproduct eq'ns RS	by RS	0	491
sumproduct and sorting Lauren	by Lauren	4	917
Sum function with asterisks DianeG	by Gord Dibben	3	848
How do I make the cursor move down 8 cells each time i press enter Candys Kisses	by Candys Kisses	3	1,448
Macro - edit with macro Danny	by Danny	4	447
Setting column widths when mapping out a field trial. Candys Kisses	by Pete_UK	1	522
input value of row and column populate from another worksheet Avidan	by JLatham	1	922
return in fractions with multiple divisors, linear rflock	by Ron Rosenfeld	2	588
EXCEL: Truncating Text Fields to allow Vlookup searches to find da burkeam1113	by Ron Rosenfeld	1	1,053
Variable within a formula Tom Melosi	by Harlan Grove[_2_]	4	479
Pivottable columns multiply in excel 2007 Haffi	by Mike Skibyak	1	780
Vlookup Approximate Match Question Craig	by Harlan Grove[_2_]	4	1,249
Vlookup function Ivan	by T. Valko	2	337
Count string IF..... Coley	by Harlan Grove[_2_]	4	590
Drop down box filter Spanner	by Spanner	0	307
background color! [email protected]	by David Biddulph[_2_]	1	333
Why is it that ~ is not recognised when using vlookup/hlookup? P Koh[_2_]	by Bob Phillips	2	478
Searching a cells contents? SteW	by SteW	2	518
Multiple levels of sumif? Peter Bellis	by Peter Bellis	3	727
how do I highlight duplicates cells in excell prior to deletion Paul B[_2_]	by Paul B[_2_]	6	651
Copy Workseet Within Same Workbook lehigh46	by JE McGimpsey	1	470
dividing words in selected cells korund	by korund	2	550
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? 4mula_freak[_2_]	by Ron Rosenfeld	3	1,435
How to Count values inside a cell when refered elsewhere? littlejess22	by Pete_UK	4	620
How do I calculate the z factor automatically khalid	by Sandy Mann	7	2,012
Excel 2007 formula help STEVE THE PARTS GUY	by [email protected]	1	459
How do I add value to a cell based on the calendar? LoriKLynn	by Teethless mama	1	337
Creating reports based on data in a cell LoriKLynn	by Teethless mama	1	299
Change background color using conditional formatting pfa	by pfa	4	1,026
VLOOKUP bollard	by Max	6	687
Vlookup #N/A Error Mike	by Stephen Russell	4	803
Find Nonblank Cell Mike	by Peo Sjoblom	4	716
OLAP Data Cube Hood	by Hood	0	484
Can you sort within worksheet with grouped cells & keep cell group A Kelly	by A Kelly	0	573
calculating number of weeks between two set dates answer786	by Niek Otten	2	1,905
Need help with a complicated function smokief	by smokief	2	419
Cannot save shared workbook Ed B	by Ed B	0	1,009
Extract domain names from email IDs sl24	by Gord Dibben	2	1,943
Custom header/footer with many pages in one worksheet Positive	by Gord Dibben	11	944
Counting Text Strings Kholm	by Kholm	11	946
how to develop a formula where assumed value in a cell is used to V. K abbey	by ilia	3	379
Printing directly to Excel Nick Krill	by Gord Dibben	1	393
An #N/A returns in Vlookup formula Mike	by Ken Wright	12	951
Macro Problem carl	by Duke Carey	1	455
Pivot table format question [email protected]	by [email protected]	3	358
Dificulty in copy and paste when items is filtered in excel 2007 henksa	by [email protected]	2	1,549
Is there a function similar to FORECAST for a power distribution? Josh	by Harlan Grove[_2_]	1	775
Need formula to calculate trend for the high values in data. [email protected]	by [email protected]	4	1,801
Import many workbooks into one worksheet JBW	by JBW	3	1,061
Spreadsheet of files... Help bwhunt1923	by Gord Dibben	2	361