Excel Worksheet Functions - Page 531

Thread / Thread Starter	Last Post	Replies	Views
need scenarios function to running MPS for production planning JL	by [email protected]	4	675
How do I lock/protect cells so they can't be changed Julie	by Paul B	3	6,275
Pasting data with hidden columns shark1966	by shark1966	4	495
Excel 2002: Merging cell content with a comma seperattor Mr. Low	by Mr. Low	2	523
SUMPRODUCT- double unary vs. * Epinn	by Epinn	2	1,047
Has anyone a template for a surveyors field book Jack Tangaloma	by paul	1	5,272
Help with Excel Function [email protected]	by Epinn	2	391
Changing hyperlink addresses (global)? Ian Bersten	by Epinn	1	655
creating formula help Zilla	by Ken Johnson	5	472
Is there a better way? Terry Bennett	by David F Cox	1	325
How to count occurrences where 2 columns are required to be true? Brandoni	by Paul B	1	851
Can't Access Paste Special Anymore Joe VW	by Dave Peterson	5	1,965
in Excel, how to put gridline every ten rows badfastfan	by Debra Dalgleish	8	765
looking to create a time + text history when a button is clicked? xoxoxoxo	by Otto Moehrbach	1	636
Make Function ignore 0 and error values AD108	by AD108	3	1,328
NEWSGROUP MESSAGE URGENT Jonah	by Bob Phillips	1	428
How do I prevent saving an excel file if cells are blank? Leighann	by Ron de Bruin	1	828
smart tags Louise	by Gord Dibben	3	487
Lost all my worksheet tabs on excel cutsy	by Gord Dibben	2	868
How can I change 080402 to 08/04/02? Bobbie	by Gord Dibben	4	372
Compare CribbsStyle	by CribbsStyle	8	493
Sum Cells Based on Condition (2 problems) Dave Y	by Dave Y	3	711
Time difference - again! ThomasAJ	by David Biddulph	2	437
Tip(s) from Excel User Conference Epinn	by Epinn	15	1,183
Lost my built in menu bar in excel 3 cutsy	by cutsy	3	812
Sum a range of cells starting from an offset date list from TODAY() [email protected]	by daddylonglegs	3	759
Add sum of cell from another worksheet drumz	by Barb Reinhardt	6	422
VLOOKUP weirdness Dave	by Dave	2	381
NEWSGROUP QUESTION URGENT Jonah	by Don Guillett	8	595
How do I calculate within a range? Jdd561	by Dana DeLouis	5	503
automatically move cell data in 1 workbook to another workbook Genesis	by Ron de Bruin	1	1,027
Is there a way to change Lowercase or Proper to ALL CAPS? Don	by Dave Peterson	2	762
Evaluate a column and extract last value Virg	by VBA Noob	3	530
Generating random numbers with the occasional outlier [email protected]	by [email protected]	3	1,084
#N/A caldog	by Max	5	570
Delete rows that are empty across columns ALATL	by ALATL	0	631
how to collectly put data in each cell from magnetic card reader data Electron-Serve Depot	by Simon	4	1,438
to recover deleted work sheet from file worksheet deleted	by Chip Pearson	1	1,063
adding quotations / brackets kvedros	by Max	1	608
Simple VLOOKUP problem Chris	by Max	2	378
Counting dan	by dan	3	546
How to skip the blank cells for calculating StdDev? Eric	by Max	3	7,154
sumif with 2 condtion Daoud Fakhry	by shail	3	399
Find and replace numbers using a formula michelplantz	by michelplantz	6	545
I want to get remaining text after using LEFT function Munawar Amin	by Harlan Grove	3	1,285
What if delete sheet is whited out? Peggy Sue	by Max	2	340
User form problem Freshman	by Chip Pearson	3	697
Create formula in VBA Heine	by Dave Peterson	5	479
use field data from 1 pivot table in another? fdibbins	by fdibbins	0	409
use field data from 1 pivot table in another? fdibbins	by Jim Thomlinson	1	531
I was trying to protect a worksheet and my outlook tool bar is loc Melissa at SBI	by Melissa at SBI	0	377
conditinal If statement with 3 outputs Arvi Laanemets	by Arvi Laanemets	5	968
Help finishing array formula! Pat Flynn	by Pat Flynn	4	441
Find Numeric sign in a string Nir	by Ron Rosenfeld	5	374
Getting #VALUE Don	by daddylonglegs	4	354
Lookup Function Referencing cells, not text values Justin	by daddylonglegs	3	721
Any way to shorten this up? Kevin M	by Kevin M	2	721
Finding multiple values of a function trainerbro	by Barb Reinhardt	3	441
Nest vlookup within large function Mike S	by daddylonglegs	3	1,864
Using macro to select a range Rob	by Paul B	3	683
Weighted average question jnasr	by [email protected]	7	424
AutoSum Carmel R	by Paul B	4	521
percentages mike cooke	by Dave F	1	430
Conditional formating between 2 workbooks. Kim Shelton at PDC	by WesZalewski	1	562
12 Month Average Dewayne	by Roger Govier	10	1,656
sumif in Excel2007 on Vista doesn't work. WesZalewski	by Dave F	3	758
Using the MATCH formula and list the duplicates Cathey	by Duke Carey	1	510
Average Jordan	by S Davis	3	378
Creating a Vendor ID from Vendor Name... Donald King	by Donald King	4	827
Automatic evaluation of custom worksheet function Jim	by Biff	1	719
Calculations in Pivot Table. Shams	by Lori	4	1,103
delete worksheet Peggy Sue	by Gord Dibben	3	452
How does one turn off gridlines only in a group of cells? cmhoover	by Gord Dibben	2	780
How to skip the blank cells for calculating StdDev? Eric	by Eric	3	795
My Auto Sum Function is not Automaticlly summing the cells Christie	by Franz Verga	1	429