Excel Worksheet Functions - Page 553

Thread / Thread Starter	Last Post	Replies	Views
Autofilter selected arrow color Jon Quixley	by dominicb	1	417
Comma delimiter Jon Quixley	by Pierre	1	471
Networkdays equivalent for minutes Jon Ratzel	by Jon Ratzel[_2_]	2	807
Pulling Tab Name of a Different Tab Than What I'm Working In Jon Ratzel[_2_]	by T. Valko	7	1,348
Vlookup and retrieve values 1 row below the normally retrieved val Jon Ratzel[_2_]	by Chip Pearson	2	1,786
Minimum Ifs Function Jon Ratzel[_2_]	by Pete_UK	7	5,643
=month() function equivalent for fiscal calendar Jon Ratzel[_2_]	by Jim	1	1,975
help with subtracting time excluding weekends and non-working hour Jon Ratzel[_2_]	by Jon Ratzel[_2_]	2	1,711
CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS Jon re Excel	by Ron Rosenfeld	2	1,466
Determining the number of specific days between two dates in Excel jon s	by Jon S	9	1,821
How do I get a drop-down list to change other cells in Excel? Jon S	by Jon S	3	804
Is it possible to use a cell adress that is typed in a cell? Jon S	by Sloth	1	401
How do I use a formula to create a new line of text in a cell? Jon Shelton	by Gord Dibben	2	1,022
How to find hidden names on an Excel worksheet ? Jon Sipworth	by Jon Sipworth	2	2,877
Formula/Sum Question Jon the Contractor	by T. Valko	2	368
Saving Pivot Tables Jon Tiegs	by Jon Tiegs	0	381
Using a ComboBox for Data Entry into a Cell Jon Turner	by K Dales	4	1,169
DFunction + Print Preview = Slowdown ??? Jon Young	by Jon Young	0	497
MODE fx in array using multiple criteria Jon Young	by Rick Rothstein \(MVP - VB\)[_107_]	4	2,561
List Object and Protection Jon Young	by Jon Young	0	667
Help with Index and Match with data validation [email protected]	by [email protected]	2	1,060
SUM (How do i add more than one amount in a single cell) jon846	by Gord Dibben	5	563
dff jon846	by jon846	0	365
Cell Shading [email protected]	by [email protected]	3	393
Splitting Data in Cell [email protected]	by [email protected]	5	632
NEWSGROUP QUESTION URGENT Jonah	by Don Guillett	8	596
Clear a set of combo boxes after a Submit of data to a new sheet. Jonah	by Jonah	0	513
NEWSGROUP MESSAGE URGENT Jonah	by Bob Phillips	1	428
Macro problem Jonah	by Jonah	0	496
VLOOKUP issue Jonah	by Bob Phillips	1	498
COUNTIF for a partial value Jonah	by KL	4	715
Checkbox reading Jonah	by Jonah	2	413
VLOOKUP issue Jonah	by Jonah	0	407
LEN fuction to leave a single character Jonah	by Sloth	6	557
sorting merged cells Jonah	by Di	3	675
Validate in WS to prevent dual data entry Jonah	by Max	1	522
Increment column by column from data row by row Jonah	by Jonah	6	562
Password hyperlink or macro? Jonah	by Jonah	0	423
Carrying formatting automatically to new W/S Jonah	by Jonah	4	444
Working Time Night Shifts Jonahs	by Jonahs	0	802
Help with worksheet function Jonas	by Jonas	0	401
formatting numbers jonas	by Gord Dibben	3	732
using sumifs to sum based on month, and criteria Jonas	by Bob Phillips	13	2,708
VLOOKUP Jonas	by Dave Peterson	3	350
Comparing databases and returning values Jonas	by Jonas	0	437
Date of expiry - warning? Jonas	by broro183	5	1,329
Help with formula: finding text Jonas Ornborg	by Gord Dibben	4	428
Finding values jonas.ornborg	by Bernie Deitrick	1	411
Conditional formatting and formula jonas.ornborg	by Mark Lincoln	3	523
transferring formats jonas.ornborg	by Pete_UK	7	437
Vlookup jonas.ornborg	by jonas.ornborg	0	349
Help regarding CF - counting [Excel 2007] Jonasbry	by Jonasbry	0	708
IF function JonasO	by JonasO	3	369
Using Sum If and an array? Jonathan	by Zack Barresse	5	557
How do I define the signum function sign(x) in Excel? Jonathan	by Bernd	4	4,510
NVL type function Jonathan	by Jonathan	5	1,201
To XIRR or Not To XIRR Jonathan	by Jonathan	3	899
Statistical Function Jonathan	by Jerry W. Lewis	2	807
Why do I still get "#NAME?" when I have loaded the Analysis Toolp. Jonathan	by Peo Sjoblom	1	662
Getting SUMIF to work in Excel 2007 filtered tables? jonathan	by Ashish Mathur[_2_]	2	1,008
How to calculate # of days Jonathan	by Gord Dibben	3	608
Import External Data -- Fill down formulas Issue Jonathan	by Jonathan	0	997
vlookup refering to a cell to get wookbook name Jonathan	by Bob Phillips	1	379
Running a macro if any data is entered in a range of cells Jonathan	by Bob Phillips	3	809
Average # in total group with multiple criteria? Jonathan	by Domenic[_2_]	8	848
Countif + Named range Jonathan	by Bob Phillips	5	813
Best way to subtotal this data? Jonathan	by Ron Coderre	8	462
copy certain data from one row Jonathan	by Jonathan	0	445
Can i pull text with a Getpivottable formula? Jonathan	by Jonathan	0	624
selecting certain text in long row of text Jonathan	by Alan	1	525
Creating Spreadsheet that pull Names that have a pop. of 10+ Jonathan	by Jim	3	335
Keeping formulas that reference a tab that changes daily? Jonathan	by Pete_UK	3	411
Multiple Criteria, Count If, Sum Product to get count across range Jonathan	by T. Valko	5	1,585
Using the CountIf function with multiple criteria? Jonathan	by Bob Phillips	11	1,124
Formula to find Stop Time from Start Time and Total Minutes Jonathan Bickett	by JE McGimpsey	5	3,757