Excel Worksheet Functions - Page 566

Thread / Thread Starter	Last Post	Replies	Views
linking cells stremetzky	by Anne Troy[_2_]	3	394
Please help for FV and XIRR function. RushatiINDIA	by RushatiINDIA	3	715
Formula for extracting data from a string LFM	by LFM	10	783
DP adjustment using quick menu buttons when sheet protected Aaron	by Aaron	0	540
Array Formula Not Calculating Alex	by JMB	1	834
Use of Match, Index, and Vlookup to Interpolate [email protected]	by JMB	4	3,595
moving cells [email protected]	by Gord Dibben	2	397
how to remove number from alphanumeric cell Igneshwara reddy[_2_]	by Ron Rosenfeld	3	1,462
tab.colorindex linked to cell color Mike	by Mike	2	1,061
If/Then functions in Excel Sean	by Teethless mama	1	319
External Database Source ericat04	by ericat04	0	368
IF formula casdaq	by casdaq	4	458
Look up and return text values plb2862	by Max	3	370
count if [email protected]	by Bob Phillips	1	305
SUMIF, with specific search criteria Bglib	by Naz	3	440
To leave a cell blank following an "IF" function abie26	by abie26	9	846
show a column of numbers also as percentages captain edward	by stevevrabel	2	551
SUMPRODUCT JN	by JN	4	332
VLOOKUP ERROR DeVoe	by PCLIVE	3	776
updating email addresses in cells cstwoplus	by cstwoplus	5	467
Return a list dependent upon the selection of a preceeding list Aja K	by Gord Dibben	4	989
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	430
end date ADK	by T. Valko	3	505
how to use the ceiling function Larry	by Conan Kelly	2	650
Sorting latitudes and longitudes I. Miller	by I. Miller	7	3,803
Excel question BillO	by Peo Sjoblom	5	370
Adding formulas Steved	by T. Valko	4	545
Can an Excel cell value be used in a Custom Footer? Footers and Cell references	by Gord Dibben	7	478
Excel decimal moving? Lee	by Gord Dibben	4	405
multiple variables in sumproduct or if/then formulas Ang	by Ang	4	628
Sort not working - very large file HelathcompanyHD	by Duke Carey	1	1,358
Difference in Weeks between 2 dates Grd	by Toppers	2	626
How to forecast non-numerics? [email protected]	by Lori	4	764
Lists From Different Tabs Steve Z[_2_]	by Steve Z[_2_]	2	2,515
Require Minimum Amount When Entering Data Steve Z	by Steve Z[_2_]	2	415
excel how to take choice of 75 rows - create form of 10 selectons John B[_2_]	by Toppers	2	412
How do I change date based on year Hannah	by Hannah	4	557
Data table function maestro	by Bruge	17	1,050
Return to sheet Ed Davis	by Ed Davis	7	442
can I add values of cells that are certain colours? GCC	by GCC	5	373
what does command simulation stands for,how to use? ayan	by ayan	0	381
static formulas - HELP Henry	by Max	3	370
formula in Excel 2000 to work %'s Justina	by Anne Troy[_2_]	7	653
Find the date of the coming up Saturday given the current date. Michael Ermino	by Ron Rosenfeld	4	1,582
what function do I use for excel to choose the 2nd highest number ematboy	by Roger Govier	2	2,515
How do I create check boxes? geckotatgirl	by geckotatgirl	4	800
I need to copy & paste multiple lines to another workbook? Jim	by Gord Dibben	3	1,251
Opening a worksheet automatically at start up of computer LUVMEEDOO	by Gord Dibben	3	2,256
formulas display but don't calculate. Mr. Z	by Gord Dibben	4	549
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table Conan Kelly	by Conan Kelly	6	996
Multiple non-consecutive rows RW	by RW	3	592
lookup and return multiple values Treena	by T. Valko	1	667
Overtime Calculations Michele	by Elkar	1	389
previous number not changing cac1966	by cac1966	2	440
matching key fields between two workbooks and displaying info when tukky142	by tukky142	2	474
Deleting Rows with data duplicated in 2 columns [email protected]	by Roger Govier	7	655
Formatting numbers in each cell after I have calculated their valu Davidr004	by Ron Coderre	1	550
Is there any way of combining vlookup with getpivotdata? Sarah (OGI)	by Bernie Deitrick	1	1,660
I need to convert a number to text but I need it to be 5 position Mike L.	by Niek Otten	5	475
Count characters within a string Francisco	by Ron Coderre	4	697
Nesting IF/calculate percentage JN	by joeu2004	6	964
Comma Seperated File Ricardo0303	by Dave Peterson	2	429
How can I reconcile data extracts from two different sources ? CSPatwardhan	by CSPatwardhan	0	768
How do I show zero in Accounting format ? Jakesmom	by Dave Peterson	2	3,813
Countif question how do I do this ? pano	by Ron Coderre	8	451
POP UP Message Rick	by frankjh19701	9	499
how do i get a list of only the begining of weeks in excel? F4Forte	by Pete_UK	1	1,898
creating dataseries from real time data Maurice	by Maurice	0	421
Trying to figure out a formula for range of numbers? Mary C[_2_]	by Mary C	2	998
IF(FIND Formula gives #VALUE! error XR6T4GC	by XR6T4GC	6	1,345
how o i use commas for lakhs jatin	by Bob Phillips	1	1,079
Links between worksheets dummy t	by Dave F	1	388
Restricting date entry relative to current date bwalshjr	by JE McGimpsey	1	629
run macro if cell value changes Maurice	by Maurice	2	1,069