Excel Worksheet Functions - Page 566

Thread / Thread Starter	Last Post	Replies	Views
linking cells stremetzky	by Anne Troy[_2_]	3	411
Please help for FV and XIRR function. RushatiINDIA	by RushatiINDIA	3	736
Formula for extracting data from a string LFM	by LFM	10	811
DP adjustment using quick menu buttons when sheet protected Aaron	by Aaron	0	559
Array Formula Not Calculating Alex	by JMB	1	858
Use of Match, Index, and Vlookup to Interpolate [email protected]	by JMB	4	3,633
moving cells [email protected]	by Gord Dibben	2	403
how to remove number from alphanumeric cell Igneshwara reddy[_2_]	by Ron Rosenfeld	3	1,505
tab.colorindex linked to cell color Mike	by Mike	2	1,083
If/Then functions in Excel Sean	by Teethless mama	1	353
External Database Source ericat04	by ericat04	0	386
IF formula casdaq	by casdaq	4	471
Look up and return text values plb2862	by Max	3	395
count if [email protected]	by Bob Phillips	1	322
SUMIF, with specific search criteria Bglib	by Naz	3	450
To leave a cell blank following an "IF" function abie26	by abie26	9	870
show a column of numbers also as percentages captain edward	by stevevrabel	2	567
SUMPRODUCT JN	by JN	4	370
VLOOKUP ERROR DeVoe	by PCLIVE	3	817
updating email addresses in cells cstwoplus	by cstwoplus	5	481
Return a list dependent upon the selection of a preceeding list Aja K	by Gord Dibben	4	1,062
Tracer Arrows and Objects Not Showing On Screen, But Do Print Heather	by Heather	0	710
How do I link the header to something in the worksheet? Beth	by Gord Dibben	1	435
end date ADK	by T. Valko	3	512
how to use the ceiling function Larry	by Conan Kelly	2	721
Sorting latitudes and longitudes I. Miller	by I. Miller	7	3,834
Excel question BillO	by Peo Sjoblom	5	393
Adding formulas Steved	by T. Valko	4	573
Can an Excel cell value be used in a Custom Footer? Footers and Cell references	by Gord Dibben	7	497
Excel decimal moving? Lee	by Gord Dibben	4	422
multiple variables in sumproduct or if/then formulas Ang	by Ang	4	661
Sort not working - very large file HelathcompanyHD	by Duke Carey	1	1,382
Difference in Weeks between 2 dates Grd	by Toppers	2	646
How to forecast non-numerics? [email protected]	by Lori	4	781
Lists From Different Tabs Steve Z[_2_]	by Steve Z[_2_]	2	2,531
Require Minimum Amount When Entering Data Steve Z	by Steve Z[_2_]	2	429
excel how to take choice of 75 rows - create form of 10 selectons John B[_2_]	by Toppers	2	452
How do I change date based on year Hannah	by Hannah	4	578
Data table function maestro	by Bruge	17	1,076
Return to sheet Ed Davis	by Ed Davis	7	462
can I add values of cells that are certain colours? GCC	by GCC	5	402
what does command simulation stands for,how to use? ayan	by ayan	0	397
static formulas - HELP Henry	by Max	3	397
formula in Excel 2000 to work %'s Justina	by Anne Troy[_2_]	7	674
Find the date of the coming up Saturday given the current date. Michael Ermino	by Ron Rosenfeld	4	1,615
what function do I use for excel to choose the 2nd highest number ematboy	by Roger Govier	2	2,655
How do I create check boxes? geckotatgirl	by geckotatgirl	4	833
I need to copy & paste multiple lines to another workbook? Jim	by Gord Dibben	3	1,287
Opening a worksheet automatically at start up of computer LUVMEEDOO	by Gord Dibben	3	2,277
formulas display but don't calculate. Mr. Z	by Gord Dibben	4	582
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table Conan Kelly	by Conan Kelly	6	1,021
Multiple non-consecutive rows RW	by RW	3	629
lookup and return multiple values Treena	by T. Valko	1	694
Overtime Calculations Michele	by Elkar	1	407
previous number not changing cac1966	by cac1966	2	462
matching key fields between two workbooks and displaying info when tukky142	by tukky142	2	504
Deleting Rows with data duplicated in 2 columns [email protected]	by Roger Govier	7	683
Formatting numbers in each cell after I have calculated their valu Davidr004	by Ron Coderre	1	568
Is there any way of combining vlookup with getpivotdata? Sarah (OGI)	by Bernie Deitrick	1	1,707
I need to convert a number to text but I need it to be 5 position Mike L.	by Niek Otten	5	500
Count characters within a string Francisco	by Ron Coderre	4	741
Nesting IF/calculate percentage JN	by joeu2004	6	989
Comma Seperated File Ricardo0303	by Dave Peterson	2	464
How can I reconcile data extracts from two different sources ? CSPatwardhan	by CSPatwardhan	0	791
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	466
POP UP Message Rick	by frankjh19701	9	569
how do i get a list of only the begining of weeks in excel? F4Forte	by Pete_UK	1	1,922
creating dataseries from real time data Maurice	by Maurice	0	461
Trying to figure out a formula for range of numbers? Mary C[_2_]	by Mary C	2	1,096
IF(FIND Formula gives #VALUE! error XR6T4GC	by XR6T4GC	6	1,367
how o i use commas for lakhs jatin	by Bob Phillips	1	1,107
Links between worksheets dummy t	by Dave F	1	399
Restricting date entry relative to current date bwalshjr	by JE McGimpsey	1	668
run macro if cell value changes Maurice	by Maurice	2	1,088