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	558
use field data from 1 pivot table in another? fdibbins	by fdibbins	0	432
Create formula in VBA Heine	by Dave Peterson	5	497
User form problem Freshman	by Chip Pearson	3	749
What if delete sheet is whited out? Peggy Sue	by Max	2	357
I want to get remaining text after using LEFT function Munawar Amin	by Harlan Grove	3	1,315
Find and replace numbers using a formula michelplantz	by michelplantz	6	576
sumif with 2 condtion Daoud Fakhry	by shail	3	429
How to skip the blank cells for calculating StdDev? Eric	by Max	3	7,248
Counting dan	by dan	3	565
Simple VLOOKUP problem Chris	by Max	2	404
adding quotations / brackets kvedros	by Max	1	627
to recover deleted work sheet from file worksheet deleted	by Chip Pearson	1	1,101
how to collectly put data in each cell from magnetic card reader data Electron-Serve Depot	by Simon	4	1,460
Delete rows that are empty across columns ALATL	by ALATL	0	649
#N/A caldog	by Max	5	594
Generating random numbers with the occasional outlier [email protected]	by [email protected]	3	1,127
Evaluate a column and extract last value Virg	by VBA Noob	3	559
Is there a way to change Lowercase or Proper to ALL CAPS? Don	by Dave Peterson	2	807
automatically move cell data in 1 workbook to another workbook Genesis	by Ron de Bruin	1	1,080
How do I calculate within a range? Jdd561	by Dana DeLouis	5	536
NEWSGROUP QUESTION URGENT Jonah	by Don Guillett	8	616
VLOOKUP weirdness Dave	by Dave	2	400
Add sum of cell from another worksheet drumz	by Barb Reinhardt	6	441
Sum a range of cells starting from an offset date list from TODAY() [email protected]	by daddylonglegs	3	794
Lost my built in menu bar in excel 3 cutsy	by cutsy	3	885
Tip(s) from Excel User Conference Epinn	by Epinn	15	1,207
Time difference - again! ThomasAJ	by David Biddulph	2	444
Sum Cells Based on Condition (2 problems) Dave Y	by Dave Y	3	727
Compare CribbsStyle	by CribbsStyle	8	506
How can I change 080402 to 08/04/02? Bobbie	by Gord Dibben	4	391
Lost all my worksheet tabs on excel cutsy	by Gord Dibben	2	890
smart tags Louise	by Gord Dibben	3	502
How do I prevent saving an excel file if cells are blank? Leighann	by Ron de Bruin	1	851
NEWSGROUP MESSAGE URGENT Jonah	by Bob Phillips	1	437
Make Function ignore 0 and error values AD108	by AD108	3	1,344
looking to create a time + text history when a button is clicked? xoxoxoxo	by Otto Moehrbach	1	657
in Excel, how to put gridline every ten rows badfastfan	by Debra Dalgleish	8	793
Can't Access Paste Special Anymore Joe VW	by Dave Peterson	5	1,986
How to count occurrences where 2 columns are required to be true? Brandoni	by Paul B	1	889
Is there a better way? Terry Bennett	by David F Cox	1	332
creating formula help Zilla	by Ken Johnson	5	496
Changing hyperlink addresses (global)? Ian Bersten	by Epinn	1	676
Help with Excel Function [email protected]	by Epinn	2	410
Has anyone a template for a surveyors field book Jack Tangaloma	by paul	1	5,296
SUMPRODUCT- double unary vs. * Epinn	by Epinn	2	1,056
Excel 2002: Merging cell content with a comma seperattor Mr. Low	by Mr. Low	2	550
Pasting data with hidden columns shark1966	by shark1966	4	572
How do I lock/protect cells so they can't be changed Julie	by Paul B	3	6,336
need scenarios function to running MPS for production planning JL	by [email protected]	4	692
flaging items as "org","dup",etc. via135 via OfficeKB.com	by via135	2	364
How do I make a spreadsheet w/ original price and then %? christyann	by Ron Coderre	3	645
ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE tcazabon	by Epinn	8	529
Create mutli-level subtotals JR Hester	by Debra Dalgleish	7	953
How do I show only the last portion of text in a multi line cell? Qwnuvhrts	by JNW	1	1,046
Formula in macro or in sheet/cells? Heine	by Don Guillett	10	780
Major Goof, I deleted data HELP Traci B........	by Jim Thomlinson	4	427
How do you calculate text into numerical answers? tyler8	by tyler8	4	445
selected extraction of cell ref in a series of cells in a row/colu romelsb	by romelsb	0	476
lowest number in a set EXCLUDING zero Bad Kitty	by JMB	2	1,710
Excel not recognizing equal values san-avsc	by san-avsc	5	2,609
Count Non-Blanks in one column based on criteria in another ScottPcola	by JMB	3	1,278
Excel File Double's in size? GENO	by GENO	2	1,373
Dates That Change Bob	by Sandy Mann	1	453
HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE romelsb	by romelsb	0	1,157
using nested OR stef	by stef	18	1,257
Conditional Format & Formula Bob	by Bob	2	673
How do I get Excel to open email for single sheet? Gary_Mc	by Gary_Mc	4	785
selecting using option buttons in excel stedroyf	by stedroyf	0	558
Formula to extract a specific word from text string Dinesh	by Bob Umlas, Excel MVP	4	2,151
Rounding Up in Cells With Formulas Earl	by PCLIVE	3	535
How can I paste a worksheet to an other program through a HYPERLIN Patrick	by Patrick	0	415
Problem with VB string character limit. AJL	by AJL	0	1,105
Grouping with a pivot table ROland	by Roger Govier	1	624
Columns to rows Azrael	by Roger Govier	1	325