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,517
Counting Unique tonyalt3	by Gary''s Student	1	367
conitif doesn't recognise time format? how to get round this? mavgn	by David Biddulph[_2_]	11	1,095
Shared Workbook robzrob	by Spiky	3	646
Grouping a column of data and displaying the number of items grouped [email protected]	by Herbert Seidenberg	2	495
Ranking problem. [email protected]	by BoniM	6	563
VlOOKUP/MATCH/INDEX Daniel Q.	by Brad Vogt	2	468
Find a specific formatted string in a cell KCK	by Ron Rosenfeld	1	418
Date Functions Sean.rogers	by Ron Rosenfeld	5	407
Data Validation Arrow Color morjayne	by Brad Vogt	2	498
Counting Combo Drop Down Box Selections Jeff	by Brad Vogt	1	535
How can I check/verify data in my Data Source for Pivot table? gayleh	by ryguy7272	1	771
Spreadsheets Compress or Overlap tompenn	by tompenn	0	543
index and matching with string search! via135	by T. Valko	4	426
Mass adding of text Shae	by Gary''s Student	5	6,475
how do i create a formula with a + or - in it Kevin Bell	by Sandy Mann	1	364
Transferring Data MJ	by Pete_UK	1	439
start and end dates within listboxes casey	by casey	4	564
Conditional array not working with pivot table data - what am Imissing?? Jason[_11_]	by Jason[_11_]	1	363
cant see column A Gaurav[_2_]	by Gaurav[_2_]	2	646
Conditional formatting of duplicates in a range gerhard	by gerhard	2	428
formula for negative time durations DAZA	by Pete_UK	1	524
Compound CountIf formula Pete Rooney	by Dave Peterson	5	865
Automatic fill-in from one worsheet to another mdj0615	by Pete_UK	1	360
database that can be updated daily jcheko	by jcheko	0	303
How to make one column update another column in Exell Canron newbie	by Fleone	2	355
How do I enter a conditional formula? Kel	by ryguy7272	2	310
Colours in a Created Planner do not show on a users Machine on ope Mike_Burns	by Mike_Burns[_2_]	1	429
CountIf value bob	by ryguy7272	3	351
Thanks to all the MVPs and others! Brian	by Brian	0	372
Countif for Pivot Krissy	by Krissy	2	1,342
page setup Mery[_2_]	by Pete_UK	3	331
How do I display negative percentages into red by a formula Marc	by Mike H	1	797
Comparing the first 2 characters of a coloumn to a string Jaime	by T. Valko	1	313
microsoft excel 2007 confusious	by Tyro[_2_]	3	446
Allocating usage across aging buckets Adrian1962	by Adrian1962	0	922
Drop Down Lists David Robinson	by JP[_4_]	2	369
how to use subtotal and it has a drop down to choose other functi TransMan	by Gord Dibben	2	529
AmalgamatingData robzrob	by JP[_4_]	1	370
date formula Daddy Rich	by Tyro[_2_]	3	318
use CTRL key inside a formula Date Less[_2_]	by Gord Dibben	6	551
How do I drag a hyperlink series to fill instead of copy? PCRONE	by Pete_UK	2	4,175
Can I jump to a cell in another worksheet PCRONE	by Pete_UK	2	1,652
Copying formulas in excel kevinrog	by Tyro[_2_]	5	414
Pivot in excel 2003 is not working when open in excel 2007 Jakob[_2_]	by Jakob[_2_]	2	1,322
VLookup Column Reference - can it increment when copying to subseq Nicky Armstrong	by Pete_UK	3	3,937
Nested IF function mrl	by Max	3	462
How can I get excel not to report n/a error when using index? Don Murray[_2_]	by Max	3	380
Using SUM, ADDRESS, INDIRECT in an array not working Bradley	by Bradley	0	616
Combining formulas Shae	by T. Valko[_2_]	5	554
Vlookup mpenkala	by mpenkala	0	305
How to line break in one cell via a formula to stack cell entries Barb @ Work	by Pete_UK	7	1,103
Find terms that sum to chosen total among a column of numbers? lstutchman	by Bernd P	2	463
Biblical references in Excel JBR	by Pat Adams	3	494
Functions for weekly net pay, single, 1 witholding, no state tax? TheSooz	by joeu2004	2	834
Dependant formula Ted	by Pete_UK	3	324
COUNTIF criteria bikerhal	by Pete_UK	2	498
Excell functions for converting column data MegM	by Pete_UK	7	627
Please help with formula mrl	by mrl	2	410
Creating a Master List from sub-lists Fleone	by Fleone	4	910
Update between spreadsheets Shae	by Shae	0	539
Using vlookup on a validation list Riptide	by Riptide	0	344
How do I slant the headers of the columns? Filly	by Gord Dibben	2	1,184
countif(range, between value 1 and value 2) Gaurav[_2_]	by RagDyer	2	1,457
Functions for "current" & "previous" month to calculate data Priss	by Priss	11	2,465
The meaning of "+". Cooz	by Spiky	13	758
Updating cells on different worksheets Martin Murray	by Gaurav[_2_]	1	444
Sharing Data between worksheets within in one workbook Jelena[_2_]	by Jelena	2	436
#ref! in calculations off of a getpivot data sum uvknights	by uvknights	0	692
Conditional Border BillMc	by BillMc	5	656
Vlookup with wildcard ryguy7272	by ryguy7272	2	646
Conditional VLOOKUP Code Numpty	by Code Numpty	0	475
What function soconfused	by soconfused	8	432
Blocking specific page cells in a pivot Hagge	by Hagge	0	642
Assistance with advanced formulas emerson.farms	by emerson.farms	3	410