Excel Worksheet Functions - Page 566

Thread / Thread Starter	Last Post	Replies	Views
linking cells stremetzky	by Anne Troy[_2_]	3	407
Please help for FV and XIRR function. RushatiINDIA	by RushatiINDIA	3	724
Formula for extracting data from a string LFM	by LFM	10	789
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,619
moving cells [email protected]	by Gord Dibben	2	400
how to remove number from alphanumeric cell Igneshwara reddy[_2_]	by Ron Rosenfeld	3	1,478
tab.colorindex linked to cell color Mike	by Mike	2	1,076
If/Then functions in Excel Sean	by Teethless mama	1	336
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	381
count if [email protected]	by Bob Phillips	1	309
SUMIF, with specific search criteria Bglib	by Naz	3	446
To leave a cell blank following an "IF" function abie26	by abie26	9	858
show a column of numbers also as percentages captain edward	by stevevrabel	2	565
SUMPRODUCT JN	by JN	4	369
VLOOKUP ERROR DeVoe	by PCLIVE	3	796
updating email addresses in cells cstwoplus	by cstwoplus	5	479
Return a list dependent upon the selection of a preceeding list Aja K	by Gord Dibben	4	1,052
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	509
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	378
Adding formulas Steved	by T. Valko	4	560
Can an Excel cell value be used in a Custom Footer? Footers and Cell references	by Gord Dibben	7	487
Excel decimal moving? Lee	by Gord Dibben	4	412
multiple variables in sumproduct or if/then formulas Ang	by Ang	4	646
Sort not working - very large file HelathcompanyHD	by Duke Carey	1	1,369
Difference in Weeks between 2 dates Grd	by Toppers	2	637
How to forecast non-numerics? [email protected]	by Lori	4	777
Lists From Different Tabs Steve Z[_2_]	by Steve Z[_2_]	2	2,521
Require Minimum Amount When Entering Data Steve Z	by Steve Z[_2_]	2	419
excel how to take choice of 75 rows - create form of 10 selectons John B[_2_]	by Toppers	2	439
How do I change date based on year Hannah	by Hannah	4	569
Data table function maestro	by Bruge	17	1,065
Return to sheet Ed Davis	by Ed Davis	7	452
can I add values of cells that are certain colours? GCC	by GCC	5	383
what does command simulation stands for,how to use? ayan	by ayan	0	387
static formulas - HELP Henry	by Max	3	384
formula in Excel 2000 to work %'s Justina	by Anne Troy[_2_]	7	665
Find the date of the coming up Saturday given the current date. Michael Ermino	by Ron Rosenfeld	4	1,613
what function do I use for excel to choose the 2nd highest number ematboy	by Roger Govier	2	2,643
How do I create check boxes? geckotatgirl	by geckotatgirl	4	819
I need to copy & paste multiple lines to another workbook? Jim	by Gord Dibben	3	1,271
Opening a worksheet automatically at start up of computer LUVMEEDOO	by Gord Dibben	3	2,267
formulas display but don't calculate. Mr. Z	by Gord Dibben	4	565
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table Conan Kelly	by Conan Kelly	6	1,004
Multiple non-consecutive rows RW	by RW	3	614
lookup and return multiple values Treena	by T. Valko	1	679
Overtime Calculations Michele	by Elkar	1	398
previous number not changing cac1966	by cac1966	2	446
matching key fields between two workbooks and displaying info when tukky142	by tukky142	2	487
Deleting Rows with data duplicated in 2 columns [email protected]	by Roger Govier	7	669
Formatting numbers in each cell after I have calculated their valu Davidr004	by Ron Coderre	1	554
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	720
Nesting IF/calculate percentage JN	by joeu2004	6	974
Comma Seperated File Ricardo0303	by Dave Peterson	2	446
How can I reconcile data extracts from two different sources ? CSPatwardhan	by CSPatwardhan	0	779
How do I show zero in Accounting format ? Jakesmom	by Dave Peterson	2	3,875
Countif question how do I do this ? pano	by Ron Coderre	8	457
POP UP Message Rick	by frankjh19701	9	559
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	448
Trying to figure out a formula for range of numbers? Mary C[_2_]	by Mary C	2	1,012
IF(FIND Formula gives #VALUE! error XR6T4GC	by XR6T4GC	6	1,349
how o i use commas for lakhs jatin	by Bob Phillips	1	1,103
Links between worksheets dummy t	by Dave F	1	397
Restricting date entry relative to current date bwalshjr	by JE McGimpsey	1	658
run macro if cell value changes Maurice	by Maurice	2	1,072