Excel Worksheet Functions - Page 387

Thread / Thread Starter	Last Post	Replies	Views
Calculating business hours between start and stop time Belinda7237	by daddylonglegs	3	1,524
Counting Unique tonyalt3	by Gary''s Student	1	376
conitif doesn't recognise time format? how to get round this? mavgn	by David Biddulph[_2_]	11	1,109
Shared Workbook robzrob	by Spiky	3	661
Grouping a column of data and displaying the number of items grouped [email protected]	by Herbert Seidenberg	2	512
Ranking problem. [email protected]	by BoniM	6	569
VlOOKUP/MATCH/INDEX Daniel Q.	by Brad Vogt	2	478
Find a specific formatted string in a cell KCK	by Ron Rosenfeld	1	451
Date Functions Sean.rogers	by Ron Rosenfeld	5	412
Data Validation Arrow Color morjayne	by Brad Vogt	2	506
Counting Combo Drop Down Box Selections Jeff	by Brad Vogt	1	551
How can I check/verify data in my Data Source for Pivot table? gayleh	by ryguy7272	1	797
Spreadsheets Compress or Overlap tompenn	by tompenn	0	549
index and matching with string search! via135	by T. Valko	4	435
Mass adding of text Shae	by Gary''s Student	5	6,492
how do i create a formula with a + or - in it Kevin Bell	by Sandy Mann	1	382
Transferring Data MJ	by Pete_UK	1	458
start and end dates within listboxes casey	by casey	4	581
Conditional array not working with pivot table data - what am Imissing?? Jason[_11_]	by Jason[_11_]	1	371
cant see column A Gaurav[_2_]	by Gaurav[_2_]	2	659
Conditional formatting of duplicates in a range gerhard	by gerhard	2	455
formula for negative time durations DAZA	by Pete_UK	1	534
Compound CountIf formula Pete Rooney	by Dave Peterson	5	868
Automatic fill-in from one worsheet to another mdj0615	by Pete_UK	1	362
database that can be updated daily jcheko	by jcheko	0	309
How to make one column update another column in Exell Canron newbie	by Fleone	2	363
How do I enter a conditional formula? Kel	by ryguy7272	2	316
Colours in a Created Planner do not show on a users Machine on ope Mike_Burns	by Mike_Burns[_2_]	1	448
CountIf value bob	by ryguy7272	3	361
Thanks to all the MVPs and others! Brian	by Brian	0	381
Countif for Pivot Krissy	by Krissy	2	1,358
page setup Mery[_2_]	by Pete_UK	3	345
How do I display negative percentages into red by a formula Marc	by Mike H	1	813
Comparing the first 2 characters of a coloumn to a string Jaime	by T. Valko	1	318
microsoft excel 2007 confusious	by Tyro[_2_]	3	461
Allocating usage across aging buckets Adrian1962	by Adrian1962	0	944
Drop Down Lists David Robinson	by JP[_4_]	2	374
how to use subtotal and it has a drop down to choose other functi TransMan	by Gord Dibben	2	536
AmalgamatingData robzrob	by JP[_4_]	1	373
date formula Daddy Rich	by Tyro[_2_]	3	324
use CTRL key inside a formula Date Less[_2_]	by Gord Dibben	6	561
How do I drag a hyperlink series to fill instead of copy? PCRONE	by Pete_UK	2	4,240
Can I jump to a cell in another worksheet PCRONE	by Pete_UK	2	1,669
Copying formulas in excel kevinrog	by Tyro[_2_]	5	430
Pivot in excel 2003 is not working when open in excel 2007 Jakob[_2_]	by Jakob[_2_]	2	1,346
VLookup Column Reference - can it increment when copying to subseq Nicky Armstrong	by Pete_UK	3	3,965
Nested IF function mrl	by Max	3	470
How can I get excel not to report n/a error when using index? Don Murray[_2_]	by Max	3	396
Using SUM, ADDRESS, INDIRECT in an array not working Bradley	by Bradley	0	625
Combining formulas Shae	by T. Valko[_2_]	5	567
Vlookup mpenkala	by mpenkala	0	306
How to line break in one cell via a formula to stack cell entries Barb @ Work	by Pete_UK	7	1,123
Find terms that sum to chosen total among a column of numbers? lstutchman	by Bernd P	2	470
Biblical references in Excel JBR	by Pat Adams	3	500
Functions for weekly net pay, single, 1 witholding, no state tax? TheSooz	by joeu2004	2	839
Dependant formula Ted	by Pete_UK	3	333
COUNTIF criteria bikerhal	by Pete_UK	2	511
Excell functions for converting column data MegM	by Pete_UK	7	635
Please help with formula mrl	by mrl	2	419
Creating a Master List from sub-lists Fleone	by Fleone	4	926
Update between spreadsheets Shae	by Shae	0	553
Using vlookup on a validation list Riptide	by Riptide	0	346
How do I slant the headers of the columns? Filly	by Gord Dibben	2	1,204
countif(range, between value 1 and value 2) Gaurav[_2_]	by RagDyer	2	1,463
Functions for "current" & "previous" month to calculate data Priss	by Priss	11	2,525
The meaning of "+". Cooz	by Spiky	13	787
Updating cells on different worksheets Martin Murray	by Gaurav[_2_]	1	448
Sharing Data between worksheets within in one workbook Jelena[_2_]	by Jelena	2	444
#ref! in calculations off of a getpivot data sum uvknights	by uvknights	0	705
Conditional Border BillMc	by BillMc	5	698
Vlookup with wildcard ryguy7272	by ryguy7272	2	650
Conditional VLOOKUP Code Numpty	by Code Numpty	0	483
What function soconfused	by soconfused	8	437
Blocking specific page cells in a pivot Hagge	by Hagge	0	661
Assistance with advanced formulas emerson.farms	by emerson.farms	3	414