Excel Worksheet Functions - Page 656

Thread / Thread Starter	Last Post	Replies	Views
Help - Looking for a Sumproduct formula [email protected]	by Carim	4	569
text box linked to cell DJP	by Carim	1	528
Hi--how do I scramble a list randomly? lmcshelp	by paul	1	1,636
How to concatenate 3064 and 01 with 306401 as a result? MSOChick	by MSOChick	11	1,171
Eliminate second browse box when right clicking for hyperlink Dirter Scott	by Dirter Scott	0	406
How can I use Excel to mark student's tests? Brownsugar9686	by GeneR	1	636
Ask user for information Aaron	by Aaron	0	388
Summing across Worksheets justvree	by RagDyeR	9	832
formula for counting TMF in MN	by Epinn	7	493
Does anyone know if there is a symbol for the "except" in formula? Kelvin yu	by Biff	2	501
Yes and No Dragan Ristic	by Dragan Ristic	5	533
Need help with COUNTIF Bob	by Biff	7	436
Linking Sheets Lynda	by Roger Govier	10	1,100
lotus 123 worksheet function conversion andresg1975	by andresg1975	2	1,014
countif Column A and excule column B if it's cancelled LLWest	by Biff	4	900
Array formula with a constant? Tester	by Biff	4	875
cancelling getpivot formula when setting formula outside pivot ta. cancelling getpivot formula	by PÃ©	2	853
Sumproduct value error Brad	by Biff	7	593
Advance Sumproduct calculation Brad	by Brad	8	753
Lookup and summing comparison Graham Haughs	by Toppers	8	436
Restricting a Spreadsheet so users cannot save changes GeneR	by Harlan Grove	1	1,251
How to create Cascading Drop-Down Lists? John	by Paul B	1	1,103
Date determination and sums UnderCoverGuy	by UnderCoverGuy	0	552
How do I seperate a full name field out into three seperate columns? Rod	by [email protected]	3	1,272
how can i capitalise text in an existing workbook craigs rus	by Ron de Bruin	1	677
Looking up a value from one cell in another range of cells [email protected]	by Herbert Seidenberg	2	479
Count cells in a column that has a autofilter Irv	by Ron de Bruin	1	534
NULL Cells UnderCoverGuy	by UnderCoverGuy	4	505
Auto e-mail message Freshman	by Ron de Bruin	1	550
Referencing another worksheet via a cell [email protected]	by [email protected]	2	574
use track changes and macros Jerjuice	by Jerjuice	0	538
Same page with Different Page numbers CFodor	by Ron de Bruin	1	995
index_match_error! via135 via OfficeKB.com	by via135 via OfficeKB.com	8	528
I need to add check boxes to my Excel spreadsheet,checked and not Spydermike	by Allllen	1	505
BackFill Zeros dallin	by Ron Coderre	1	1,272
Can the contents of a drop down box differ from what's entered? ForkHandles	by Jim Thomlinson	1	544
Worksheet naming using visual basic O'C	by O'C	2	851
Match cells with cells on another workbook James1976	by Allllen	1	1,107
Soundex converter formula? Vanessa	by Vanessa	0	2,424
MATCHING DATE TO A WEEKDAY Stuart Carnachan	by Roger Govier	3	740
how to change the insertion point color? smc11ca	by smc11ca	0	542
Excel Group & Sum function shikarishambu	by shikarishambu	2	1,000
Move data Horacio	by Horacio	2	631
Excel equivalent of sql group by count shikarishambu	by shikarishambu	2	1,616
How can I get a cell to Flash if it meets a certain criteria in Ex tcfoote	by Ron Coderre	1	687
How to set up an excel formula to copy cells to another worksheet? SLN	by SLN	3	495
lookup on Table including blanks - Nir	by Lori	7	603
How do you protect Headers and Footers in MOFFICE Tommydraw123	by Tommydraw123	0	805
Show input box with cell value [email protected]	by Sandy	4	1,180
Splitting cells - please help! Danny boy	by Ron Rosenfeld	11	990
Tie a Calendar week to a Scoped Projected Week [email protected]	by Gary Brown	3	660
Conditional formats using more than 3 conditions Al_Doug	by Allllen	2	371
Format Date [email protected]	by Lori	4	362
Drop Down List choice selecting another drop down list CVD0722	by CVD0722	3	1,618
How do i calculate the saved amount ? bao	by Niek Otten	1	593
Date Interval Predictions [email protected]	by Roger Govier	1	447
Maximum length of a number PÃ©	by Ron Rosenfeld	1	828
Formula Too Long Tom Young	by Lori	15	1,096
Group & sort rows that have a specific value in column C Lex	by Max	3	1,631
Macro problems Heine	by Bob Phillips	9	562
Quarter Dates LR	by Roger Govier	8	895
check for duplicate numbers Ash	by Roger Govier	13	1,233
How do I selectand copy only subtotals in a sheet Select and copy only subtotals in sheet	by Stefi	1	480
Text to rows...at wits end Anonon	by PY & Associates	3	582
cannot paste link using equal sign zizu	by David Biddulph	1	762
How on Earth do I use the GHK Function? Charles Matheson	by Ken Wright	3	758
How to concatenate an array of four stings using formulae (not UDF) Alan	by Alan	9	930
Read only files? Lost tabs on worksheetstoo! msjams516	by msjams516	0	470
convert time functions to numbers Patty	by JMB	1	582
FV Calculation problem bao	by JMB	1	601
Fv bao	by bao	0	360
Average if Curtis	by RagDyeR	10	661
conditional formatting error message Karla V	by Biff	3	738
Help with SUM and IF Amstro	by Biff	3	377
How to change cell reference within formulas CGSoniat	by RagDyeR	4	1,338