Excel Worksheet Functions - Page 566

Thread / Thread Starter	Last Post	Replies	Views
linking cells stremetzky	by Anne Troy[_2_]	3	410
Please help for FV and XIRR function. RushatiINDIA	by RushatiINDIA	3	725
Formula for extracting data from a string LFM	by LFM	10	793
DP adjustment using quick menu buttons when sheet protected Aaron	by Aaron	0	550
Array Formula Not Calculating Alex	by JMB	1	846
Use of Match, Index, and Vlookup to Interpolate [email protected]	by JMB	4	3,620
moving cells [email protected]	by Gord Dibben	2	400
how to remove number from alphanumeric cell Igneshwara reddy[_2_]	by Ron Rosenfeld	3	1,491
tab.colorindex linked to cell color Mike	by Mike	2	1,078
If/Then functions in Excel Sean	by Teethless mama	1	338
External Database Source ericat04	by ericat04	0	375
IF formula casdaq	by casdaq	4	461
Look up and return text values plb2862	by Max	3	383
count if [email protected]	by Bob Phillips	1	310
SUMIF, with specific search criteria Bglib	by Naz	3	447
To leave a cell blank following an "IF" function abie26	by abie26	9	861
show a column of numbers also as percentages captain edward	by stevevrabel	2	566
SUMPRODUCT JN	by JN	4	369
VLOOKUP ERROR DeVoe	by PCLIVE	3	803
updating email addresses in cells cstwoplus	by cstwoplus	5	480
Return a list dependent upon the selection of a preceeding list Aja K	by Gord Dibben	4	1,054
Tracer Arrows and Objects Not Showing On Screen, But Do Print Heather	by Heather	0	709
How do I link the header to something in the worksheet? Beth	by Gord Dibben	1	435
end date ADK	by T. Valko	3	510
how to use the ceiling function Larry	by Conan Kelly	2	712
Sorting latitudes and longitudes I. Miller	by I. Miller	7	3,825
Excel question BillO	by Peo Sjoblom	5	380
Adding formulas Steved	by T. Valko	4	561
Can an Excel cell value be used in a Custom Footer? Footers and Cell references	by Gord Dibben	7	489
Excel decimal moving? Lee	by Gord Dibben	4	412
multiple variables in sumproduct or if/then formulas Ang	by Ang	4	647
Sort not working - very large file HelathcompanyHD	by Duke Carey	1	1,370
Difference in Weeks between 2 dates Grd	by Toppers	2	638
How to forecast non-numerics? [email protected]	by Lori	4	778
Lists From Different Tabs Steve Z[_2_]	by Steve Z[_2_]	2	2,522
Require Minimum Amount When Entering Data Steve Z	by Steve Z[_2_]	2	420
excel how to take choice of 75 rows - create form of 10 selectons John B[_2_]	by Toppers	2	440
How do I change date based on year Hannah	by Hannah	4	570
Data table function maestro	by Bruge	17	1,066
Return to sheet Ed Davis	by Ed Davis	7	452
can I add values of cells that are certain colours? GCC	by GCC	5	392
what does command simulation stands for,how to use? ayan	by ayan	0	387
static formulas - HELP Henry	by Max	3	387
formula in Excel 2000 to work %'s Justina	by Anne Troy[_2_]	7	667
Find the date of the coming up Saturday given the current date. Michael Ermino	by Ron Rosenfeld	4	1,614
what function do I use for excel to choose the 2nd highest number ematboy	by Roger Govier	2	2,648
How do I create check boxes? geckotatgirl	by geckotatgirl	4	821
I need to copy & paste multiple lines to another workbook? Jim	by Gord Dibben	3	1,272
Opening a worksheet automatically at start up of computer LUVMEEDOO	by Gord Dibben	3	2,269
formulas display but don't calculate. Mr. Z	by Gord Dibben	4	566
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table Conan Kelly	by Conan Kelly	6	1,008
Multiple non-consecutive rows RW	by RW	3	616
lookup and return multiple values Treena	by T. Valko	1	681
Overtime Calculations Michele	by Elkar	1	399
previous number not changing cac1966	by cac1966	2	446
matching key fields between two workbooks and displaying info when tukky142	by tukky142	2	489
Deleting Rows with data duplicated in 2 columns [email protected]	by Roger Govier	7	671
Formatting numbers in each cell after I have calculated their valu Davidr004	by Ron Coderre	1	556
Is there any way of combining vlookup with getpivotdata? Sarah (OGI)	by Bernie Deitrick	1	1,693
I need to convert a number to text but I need it to be 5 position Mike L.	by Niek Otten	5	487
Count characters within a string Francisco	by Ron Coderre	4	729
Nesting IF/calculate percentage JN	by joeu2004	6	974
Comma Seperated File Ricardo0303	by Dave Peterson	2	453
How can I reconcile data extracts from two different sources ? CSPatwardhan	by CSPatwardhan	0	780
How do I show zero in Accounting format ? Jakesmom	by Dave Peterson	2	3,877
Countif question how do I do this ? pano	by Ron Coderre	8	459
POP UP Message Rick	by frankjh19701	9	560
how do i get a list of only the begining of weeks in excel? F4Forte	by Pete_UK	1	1,907
creating dataseries from real time data Maurice	by Maurice	0	451
Trying to figure out a formula for range of numbers? Mary C[_2_]	by Mary C	2	1,093
IF(FIND Formula gives #VALUE! error XR6T4GC	by XR6T4GC	6	1,352
how o i use commas for lakhs jatin	by Bob Phillips	1	1,104
Links between worksheets dummy t	by Dave F	1	399
Restricting date entry relative to current date bwalshjr	by JE McGimpsey	1	660
run macro if cell value changes Maurice	by Maurice	2	1,073