Excel Worksheet Functions - Page 156

Thread / Thread Starter	Last Post	Replies	Views
=SUM returns 5.54365E-11 instead of 0 (zero) Chwan Keng Ng	by Stan Brown	6	3,843
How to break out data combined in a single cell juliejg1	by Max	6	5,903
FORMULA TO FIGURE AGE tjsmags	by Harlan Grove[_2_]	6	436
Sumif or sumproduct Klee	by Klee	6	451
Transpose cell contents from multiple worksheets into rows v-words	by Harlan Grove[_2_]	6	1,221
Getting more than one lookup results in array Alex	by T. Valko	6	708
Finding the list of the question I have asked Old Keith	by T. Valko	6	421
look up / match / reference cell Kylie	by ilia	6	381
formula to track timeframe by automatically highlighting cells maijiuli	by maijiuli	6	504
Weekly average in pivot Max StenbÃ¤ck	by Max StenbÃ¤ck	6	633
Linking Data for Proposal Jeff	by Debra Dalgleish	6	527
Sound File Johno	by Johno	6	327
maybe it's simple with macro for this one? driller	by driller	6	417
selecting a row srikanth	by srikanth	6	546
Is there a way to make a link to a specific tab in excel? Carlee	by Send2Steph	6	732
how do I convert a general number to a time format? doveness	by daddylonglegs	6	1,656
How do I reference the value of a cell within a formula? masterbaker	by masterbaker	6	534
Lookup strings with ~ and ^ characters kmhnhsuk	by Dave Peterson	6	355
Which is faster? SUMPRODUCT or VLOOKUP, or another alternative? SteveC	by Aladin Akyurek	6	1,548
How do I write a macro that will allow users to set thier own pass David A.	by David A.	6	477
separate an address street/city,state,zip within a cell? Puzzled	by Puzzled	6	2,480
compound rate of return calculation Biff	by Biff	6	1,904
Macro Problem carl	by carl	6	644
VLOOKUP using two criteria Josh Johansen	by bj	6	2,251
Rounding problems Ste101	by Pete_UK	6	508
Dollar/Euro/Pound Excel macro Yendorian	by JLatham	6	739
Finding The MAX Value carl	by Jim Thomlinson	6	780
Sorting dates Old Keith	by Old Keith	6	487
Current Mortgage Balance JAH	by JAH	6	942
Another simple formula needed Connie Martin	by Toppers	6	504
Referencing cells in another worksheet xtrout	by T. Valko	6	802
Conditional function Sonia	by bj	6	436
Another Conditional Formatting Formula needed? Dan the Man[_2_]	by Dan the Man[_2_]	6	529
Formula for Matching Names and Conditional Formatting! Dan the Man[_2_]	by JMB	6	700
Dates formula davey	by Dave Thomas	6	486
Less Than MATCH() [email protected]	by [email protected]	6	324
INDIRECT Link of Variables for VLOOKUPs RayportingMonkey	by Harlan Grove[_2_]	6	549
Simple if, if ? Steve	by Steve	6	413
sumif and then regular equation to non selected cells mike	by Kevin Vaughn	6	562
Index/Match not working frosterrj	by frosterrj	6	1,900
Is there a formula that will add only highlighted rows? RMax	by Norman Jones	6	521
Adding a space in text MB	by CarlosAntenna	6	690
COUNTBLANK function Ian P	by Kevin Vaughn	6	525
How to link data from one drop-down list to another dolfijntje33	by Bob Phillips	6	1,793
Absolute function Dinesh	by Dinesh	6	689
Lookup based on two conditions [email protected]	by Kevin Vaughn	6	580
Complicated formulas XCESIV	by Niek Otten	6	425
Changing relative to absolute for a column John K	by davesexcel	6	861
cell data not validated if navigating cell to cell with mouse LoveThatMouse	by Ragdyer	6	893
Splitting cells using formula; RIGHT/LEFT not applicable Mitch	by Toppers	6	839
if/and statements BobVA	by BobVA	6	427
I want to add up the amounts from 1 cell in a folder of files Betsy	by Ron de Bruin	6	541
aa ab ac....ax ay az....ba bb bc....zx zy zz ? JethroUK©	by JethroUK©	6	1,532
How do I autofill conditional formatting? JesiR	by Rich Mcc	6	588
Nested Vlookup and IF function???? Simon Lloyd	by Don Guillett	6	1,016
min and if again jam	by jam	6	403
existing unique value formula help (index(match(countif))) [email protected]	by Domenic	6	1,114
highlighting cells beginning with certain numbers Louise	by Pete_UK	6	672
Needing simple formula Connie Martin	by Connie Martin	6	442
Numbers to dates steviec334567	by Ron Rosenfeld	6	365
(Unsuccessfully!) Unhiding Rows in Excel 2003 [email protected]	by [email protected]	6	1,856
2nd lowest number in an array Greg	by Marc	6	964
How to sum data based on font or cell color? techiesol	by jzzman	6	1,719
Logical functions to calculate points stellarblue11	by [email protected]	6	445
Using CountIf with 2 conditions - help! Sarah	by Max	6	630
Vlookup with variable worksheet reference trempnvt	by Max	6	1,270
Protection of identical cells on multiple worksheets shawnlacey	by shawnlacey	6	603
VLOOKUP stops working with pasted values SueD	by Max	6	1,098
Excel Chessboard problem, boarders and cell shading voyage2000UK	by voyage2000UK	6	777
VLOOKUP and LEFT to match text? LTUser54	by SteveG	6	1,507
can an array formula do this? [email protected]	by [email protected]	6	370
Shade a cell on one wrksht if another wrksht cell is occupied Clark	by SteveG	6	621
VLOOKUP and LEN/ISNA to match names? LTUser54	by Ken Hudson	6	1,305
NOW function question George Applegate	by George Applegate	6	548
Nested IF in this situation Cossminnn	by Ron Rosenfeld	6	536