Excel Worksheet Functions - Page 653

Thread / Thread Starter	Last Post	Replies	Views
use field data from 1 pivot table in another? fdibbins	by Jim Thomlinson	1	530
use field data from 1 pivot table in another? fdibbins	by fdibbins	0	408
Create formula in VBA Heine	by Dave Peterson	5	478
User form problem Freshman	by Chip Pearson	3	694
What if delete sheet is whited out? Peggy Sue	by Max	2	339
I want to get remaining text after using LEFT function Munawar Amin	by Harlan Grove	3	1,284
Find and replace numbers using a formula michelplantz	by michelplantz	6	543
sumif with 2 condtion Daoud Fakhry	by shail	3	384
How to skip the blank cells for calculating StdDev? Eric	by Max	3	7,100
Counting dan	by dan	3	536
Simple VLOOKUP problem Chris	by Max	2	370
adding quotations / brackets kvedros	by Max	1	606
to recover deleted work sheet from file worksheet deleted	by Chip Pearson	1	1,049
how to collectly put data in each cell from magnetic card reader data Electron-Serve Depot	by Simon	4	1,436
Delete rows that are empty across columns ALATL	by ALATL	0	630
#N/A caldog	by Max	5	569
Generating random numbers with the occasional outlier [email protected]	by [email protected]	3	1,083
Evaluate a column and extract last value Virg	by VBA Noob	3	530
Is there a way to change Lowercase or Proper to ALL CAPS? Don	by Dave Peterson	2	761
automatically move cell data in 1 workbook to another workbook Genesis	by Ron de Bruin	1	1,026
How do I calculate within a range? Jdd561	by Dana DeLouis	5	503
NEWSGROUP QUESTION URGENT Jonah	by Don Guillett	8	594
VLOOKUP weirdness Dave	by Dave	2	380
Add sum of cell from another worksheet drumz	by Barb Reinhardt	6	422
Sum a range of cells starting from an offset date list from TODAY() [email protected]	by daddylonglegs	3	757
Lost my built in menu bar in excel 3 cutsy	by cutsy	3	812
Tip(s) from Excel User Conference Epinn	by Epinn	15	1,182
Time difference - again! ThomasAJ	by David Biddulph	2	436
Sum Cells Based on Condition (2 problems) Dave Y	by Dave Y	3	710
Compare CribbsStyle	by CribbsStyle	8	493
How can I change 080402 to 08/04/02? Bobbie	by Gord Dibben	4	371
Lost all my worksheet tabs on excel cutsy	by Gord Dibben	2	867
smart tags Louise	by Gord Dibben	3	486
How do I prevent saving an excel file if cells are blank? Leighann	by Ron de Bruin	1	827
NEWSGROUP MESSAGE URGENT Jonah	by Bob Phillips	1	427
Make Function ignore 0 and error values AD108	by AD108	3	1,327
looking to create a time + text history when a button is clicked? xoxoxoxo	by Otto Moehrbach	1	633
in Excel, how to put gridline every ten rows badfastfan	by Debra Dalgleish	8	764
Can't Access Paste Special Anymore Joe VW	by Dave Peterson	5	1,951
How to count occurrences where 2 columns are required to be true? Brandoni	by Paul B	1	850
Is there a better way? Terry Bennett	by David F Cox	1	324
creating formula help Zilla	by Ken Johnson	5	469
Changing hyperlink addresses (global)? Ian Bersten	by Epinn	1	655
Help with Excel Function [email protected]	by Epinn	2	391
Has anyone a template for a surveyors field book Jack Tangaloma	by paul	1	5,269
SUMPRODUCT- double unary vs. * Epinn	by Epinn	2	1,046
Excel 2002: Merging cell content with a comma seperattor Mr. Low	by Mr. Low	2	522
Pasting data with hidden columns shark1966	by shark1966	4	482
How do I lock/protect cells so they can't be changed Julie	by Paul B	3	6,203
need scenarios function to running MPS for production planning JL	by [email protected]	4	657
flaging items as "org","dup",etc. via135 via OfficeKB.com	by via135	2	336
How do I make a spreadsheet w/ original price and then %? christyann	by Ron Coderre	3	617
ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE tcazabon	by Epinn	8	503
Create mutli-level subtotals JR Hester	by Debra Dalgleish	7	922
How do I show only the last portion of text in a multi line cell? Qwnuvhrts	by JNW	1	1,009
Formula in macro or in sheet/cells? Heine	by Don Guillett	10	752
Major Goof, I deleted data HELP Traci B........	by Jim Thomlinson	4	422
How do you calculate text into numerical answers? tyler8	by tyler8	4	426
selected extraction of cell ref in a series of cells in a row/colu romelsb	by romelsb	0	444
lowest number in a set EXCLUDING zero Bad Kitty	by JMB	2	1,688
Excel not recognizing equal values san-avsc	by san-avsc	5	2,578
Count Non-Blanks in one column based on criteria in another ScottPcola	by JMB	3	1,239
Excel File Double's in size? GENO	by GENO	2	1,353
Dates That Change Bob	by Sandy Mann	1	420
HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE romelsb	by romelsb	0	1,110
using nested OR stef	by stef	18	1,227
Conditional Format & Formula Bob	by Bob	2	608
How do I get Excel to open email for single sheet? Gary_Mc	by Gary_Mc	4	744
selecting using option buttons in excel stedroyf	by stedroyf	0	520
Formula to extract a specific word from text string Dinesh	by Bob Umlas, Excel MVP	4	2,081
Rounding Up in Cells With Formulas Earl	by PCLIVE	3	518
How can I paste a worksheet to an other program through a HYPERLIN Patrick	by Patrick	0	401
Problem with VB string character limit. AJL	by AJL	0	1,072
Grouping with a pivot table ROland	by Roger Govier	1	594
Columns to rows Azrael	by Roger Govier	1	308