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,540
Counting Unique tonyalt3	by Gary''s Student	1	384
conitif doesn't recognise time format? how to get round this? mavgn	by David Biddulph[_2_]	11	1,118
Shared Workbook robzrob	by Spiky	3	672
Grouping a column of data and displaying the number of items grouped [email protected]	by Herbert Seidenberg	2	514
Ranking problem. [email protected]	by BoniM	6	576
VlOOKUP/MATCH/INDEX Daniel Q.	by Brad Vogt	2	478
Find a specific formatted string in a cell KCK	by Ron Rosenfeld	1	462
Date Functions Sean.rogers	by Ron Rosenfeld	5	427
Data Validation Arrow Color morjayne	by Brad Vogt	2	516
Counting Combo Drop Down Box Selections Jeff	by Brad Vogt	1	553
How can I check/verify data in my Data Source for Pivot table? gayleh	by ryguy7272	1	810
Spreadsheets Compress or Overlap tompenn	by tompenn	0	556
index and matching with string search! via135	by T. Valko	4	447
Mass adding of text Shae	by Gary''s Student	5	6,506
how do i create a formula with a + or - in it Kevin Bell	by Sandy Mann	1	389
Transferring Data MJ	by Pete_UK	1	468
start and end dates within listboxes casey	by casey	4	595
Conditional array not working with pivot table data - what am Imissing?? Jason[_11_]	by Jason[_11_]	1	381
cant see column A Gaurav[_2_]	by Gaurav[_2_]	2	669
Conditional formatting of duplicates in a range gerhard	by gerhard	2	467
formula for negative time durations DAZA	by Pete_UK	1	537
Compound CountIf formula Pete Rooney	by Dave Peterson	5	871
Automatic fill-in from one worsheet to another mdj0615	by Pete_UK	1	367
database that can be updated daily jcheko	by jcheko	0	319
How to make one column update another column in Exell Canron newbie	by Fleone	2	374
How do I enter a conditional formula? Kel	by ryguy7272	2	326
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	373
Thanks to all the MVPs and others! Brian	by Brian	0	384
Countif for Pivot Krissy	by Krissy	2	1,369
page setup Mery[_2_]	by Pete_UK	3	351
How do I display negative percentages into red by a formula Marc	by Mike H	1	815
Comparing the first 2 characters of a coloumn to a string Jaime	by T. Valko	1	327
microsoft excel 2007 confusious	by Tyro[_2_]	3	476
Allocating usage across aging buckets Adrian1962	by Adrian1962	0	947
Drop Down Lists David Robinson	by JP[_4_]	2	386
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	384
date formula Daddy Rich	by Tyro[_2_]	3	336
use CTRL key inside a formula Date Less[_2_]	by Gord Dibben	6	576
How do I drag a hyperlink series to fill instead of copy? PCRONE	by Pete_UK	2	4,253
Can I jump to a cell in another worksheet PCRONE	by Pete_UK	2	1,670
Copying formulas in excel kevinrog	by Tyro[_2_]	5	440
Pivot in excel 2003 is not working when open in excel 2007 Jakob[_2_]	by Jakob[_2_]	2	1,361
VLookup Column Reference - can it increment when copying to subseq Nicky Armstrong	by Pete_UK	3	3,971
Nested IF function mrl	by Max	3	477
How can I get excel not to report n/a error when using index? Don Murray[_2_]	by Max	3	406
Using SUM, ADDRESS, INDIRECT in an array not working Bradley	by Bradley	0	636
Combining formulas Shae	by T. Valko[_2_]	5	579
Vlookup mpenkala	by mpenkala	0	311
How to line break in one cell via a formula to stack cell entries Barb @ Work	by Pete_UK	7	1,128
Find terms that sum to chosen total among a column of numbers? lstutchman	by Bernd P	2	480
Biblical references in Excel JBR	by Pat Adams	3	508
Functions for weekly net pay, single, 1 witholding, no state tax? TheSooz	by joeu2004	2	842
Dependant formula Ted	by Pete_UK	3	345
COUNTIF criteria bikerhal	by Pete_UK	2	512
Excell functions for converting column data MegM	by Pete_UK	7	644
Please help with formula mrl	by mrl	2	426
Creating a Master List from sub-lists Fleone	by Fleone	4	936
Update between spreadsheets Shae	by Shae	0	555
Using vlookup on a validation list Riptide	by Riptide	0	355
How do I slant the headers of the columns? Filly	by Gord Dibben	2	1,216
countif(range, between value 1 and value 2) Gaurav[_2_]	by RagDyer	2	1,470
Functions for "current" & "previous" month to calculate data Priss	by Priss	11	2,525
The meaning of "+". Cooz	by Spiky	13	790
Updating cells on different worksheets Martin Murray	by Gaurav[_2_]	1	449
Sharing Data between worksheets within in one workbook Jelena[_2_]	by Jelena	2	450
#ref! in calculations off of a getpivot data sum uvknights	by uvknights	0	707
Conditional Border BillMc	by BillMc	5	712
Vlookup with wildcard ryguy7272	by ryguy7272	2	655
Conditional VLOOKUP Code Numpty	by Code Numpty	0	493
What function soconfused	by soconfused	8	445
Blocking specific page cells in a pivot Hagge	by Hagge	0	663
Assistance with advanced formulas emerson.farms	by emerson.farms	3	419