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	551
use field data from 1 pivot table in another? fdibbins	by fdibbins	0	432
Create formula in VBA Heine	by Dave Peterson	5	487
User form problem Freshman	by Chip Pearson	3	741
What if delete sheet is whited out? Peggy Sue	by Max	2	348
I want to get remaining text after using LEFT function Munawar Amin	by Harlan Grove	3	1,304
Find and replace numbers using a formula michelplantz	by michelplantz	6	565
sumif with 2 condtion Daoud Fakhry	by shail	3	429
How to skip the blank cells for calculating StdDev? Eric	by Max	3	7,239
Counting dan	by dan	3	560
Simple VLOOKUP problem Chris	by Max	2	389
adding quotations / brackets kvedros	by Max	1	617
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,449
Delete rows that are empty across columns ALATL	by ALATL	0	643
#N/A caldog	by Max	5	583
Generating random numbers with the occasional outlier [email protected]	by [email protected]	3	1,115
Evaluate a column and extract last value Virg	by VBA Noob	3	547
Is there a way to change Lowercase or Proper to ALL CAPS? Don	by Dave Peterson	2	795
automatically move cell data in 1 workbook to another workbook Genesis	by Ron de Bruin	1	1,073
How do I calculate within a range? Jdd561	by Dana DeLouis	5	531
NEWSGROUP QUESTION URGENT Jonah	by Don Guillett	8	616
VLOOKUP weirdness Dave	by Dave	2	395
Add sum of cell from another worksheet drumz	by Barb Reinhardt	6	427
Sum a range of cells starting from an offset date list from TODAY() [email protected]	by daddylonglegs	3	782
Lost my built in menu bar in excel 3 cutsy	by cutsy	3	879
Tip(s) from Excel User Conference Epinn	by Epinn	15	1,195
Time difference - again! ThomasAJ	by David Biddulph	2	443
Sum Cells Based on Condition (2 problems) Dave Y	by Dave Y	3	727
Compare CribbsStyle	by CribbsStyle	8	505
How can I change 080402 to 08/04/02? Bobbie	by Gord Dibben	4	383
Lost all my worksheet tabs on excel cutsy	by Gord Dibben	2	889
smart tags Louise	by Gord Dibben	3	501
How do I prevent saving an excel file if cells are blank? Leighann	by Ron de Bruin	1	841
NEWSGROUP MESSAGE URGENT Jonah	by Bob Phillips	1	435
Make Function ignore 0 and error values AD108	by AD108	3	1,332
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	778
Can't Access Paste Special Anymore Joe VW	by Dave Peterson	5	1,980
How to count occurrences where 2 columns are required to be true? Brandoni	by Paul B	1	876
Is there a better way? Terry Bennett	by David F Cox	1	331
creating formula help Zilla	by Ken Johnson	5	489
Changing hyperlink addresses (global)? Ian Bersten	by Epinn	1	671
Help with Excel Function [email protected]	by Epinn	2	397
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,055
Excel 2002: Merging cell content with a comma seperattor Mr. Low	by Mr. Low	2	546
Pasting data with hidden columns shark1966	by shark1966	4	556
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	687
flaging items as "org","dup",etc. via135 via OfficeKB.com	by via135	2	355
How do I make a spreadsheet w/ original price and then %? christyann	by Ron Coderre	3	642
ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE tcazabon	by Epinn	8	515
Create mutli-level subtotals JR Hester	by Debra Dalgleish	7	940
How do I show only the last portion of text in a multi line cell? Qwnuvhrts	by JNW	1	1,030
Formula in macro or in sheet/cells? Heine	by Don Guillett	10	775
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	435
selected extraction of cell ref in a series of cells in a row/colu romelsb	by romelsb	0	465
lowest number in a set EXCLUDING zero Bad Kitty	by JMB	2	1,700
Excel not recognizing equal values san-avsc	by san-avsc	5	2,606
Count Non-Blanks in one column based on criteria in another ScottPcola	by JMB	3	1,264
Excel File Double's in size? GENO	by GENO	2	1,363
Dates That Change Bob	by Sandy Mann	1	441
HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE romelsb	by romelsb	0	1,143
using nested OR stef	by stef	18	1,243
Conditional Format & Formula Bob	by Bob	2	665
How do I get Excel to open email for single sheet? Gary_Mc	by Gary_Mc	4	777
selecting using option buttons in excel stedroyf	by stedroyf	0	543
Formula to extract a specific word from text string Dinesh	by Bob Umlas, Excel MVP	4	2,142
Rounding Up in Cells With Formulas Earl	by PCLIVE	3	530
How can I paste a worksheet to an other program through a HYPERLIN Patrick	by Patrick	0	407
Problem with VB string character limit. AJL	by AJL	0	1,101
Grouping with a pivot table ROland	by Roger Govier	1	612
Columns to rows Azrael	by Roger Govier	1	315