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	520
Hi--how do I scramble a list randomly? lmcshelp	by paul	1	1,634
How to concatenate 3064 and 01 with 306401 as a result? MSOChick	by MSOChick	11	1,163
Eliminate second browse box when right clicking for hyperlink Dirter Scott	by Dirter Scott	0	403
How can I use Excel to mark student's tests? Brownsugar9686	by GeneR	1	629
Ask user for information Aaron	by Aaron	0	378
Summing across Worksheets justvree	by RagDyeR	9	829
formula for counting TMF in MN	by Epinn	7	489
Does anyone know if there is a symbol for the "except" in formula? Kelvin yu	by Biff	2	486
Yes and No Dragan Ristic	by Dragan Ristic	5	533
Need help with COUNTIF Bob	by Biff	7	423
Linking Sheets Lynda	by Roger Govier	10	1,088
lotus 123 worksheet function conversion andresg1975	by andresg1975	2	1,012
countif Column A and excule column B if it's cancelled LLWest	by Biff	4	893
Array formula with a constant? Tester	by Biff	4	866
cancelling getpivot formula when setting formula outside pivot ta. cancelling getpivot formula	by PÃ©	2	842
Sumproduct value error Brad	by Biff	7	587
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,239
How to create Cascading Drop-Down Lists? John	by Paul B	1	1,092
Date determination and sums UnderCoverGuy	by UnderCoverGuy	0	551
How do I seperate a full name field out into three seperate columns? Rod	by [email protected]	3	1,263
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	476
Count cells in a column that has a autofilter Irv	by Ron de Bruin	1	525
NULL Cells UnderCoverGuy	by UnderCoverGuy	4	493
Auto e-mail message Freshman	by Ron de Bruin	1	546
Referencing another worksheet via a cell [email protected]	by [email protected]	2	565
use track changes and macros Jerjuice	by Jerjuice	0	532
Same page with Different Page numbers CFodor	by Ron de Bruin	1	986
index_match_error! via135 via OfficeKB.com	by via135 via OfficeKB.com	8	510
I need to add check boxes to my Excel spreadsheet,checked and not Spydermike	by Allllen	1	498
BackFill Zeros dallin	by Ron Coderre	1	1,267
Can the contents of a drop down box differ from what's entered? ForkHandles	by Jim Thomlinson	1	539
Worksheet naming using visual basic O'C	by O'C	2	841
Match cells with cells on another workbook James1976	by Allllen	1	1,102
Soundex converter formula? Vanessa	by Vanessa	0	2,421
MATCHING DATE TO A WEEKDAY Stuart Carnachan	by Roger Govier	3	731
how to change the insertion point color? smc11ca	by smc11ca	0	534
Excel Group & Sum function shikarishambu	by shikarishambu	2	987
Move data Horacio	by Horacio	2	614
Excel equivalent of sql group by count shikarishambu	by shikarishambu	2	1,611
How can I get a cell to Flash if it meets a certain criteria in Ex tcfoote	by Ron Coderre	1	679
How to set up an excel formula to copy cells to another worksheet? SLN	by SLN	3	493
lookup on Table including blanks - Nir	by Lori	7	599
How do you protect Headers and Footers in MOFFICE Tommydraw123	by Tommydraw123	0	801
Show input box with cell value [email protected]	by Sandy	4	1,168
Splitting cells - please help! Danny boy	by Ron Rosenfeld	11	988
Tie a Calendar week to a Scoped Projected Week [email protected]	by Gary Brown	3	659
Conditional formats using more than 3 conditions Al_Doug	by Allllen	2	359
Format Date [email protected]	by Lori	4	348
Drop Down List choice selecting another drop down list CVD0722	by CVD0722	3	1,617
How do i calculate the saved amount ? bao	by Niek Otten	1	589
Date Interval Predictions [email protected]	by Roger Govier	1	444
Maximum length of a number PÃ©	by Ron Rosenfeld	1	821
Formula Too Long Tom Young	by Lori	15	1,093
Group & sort rows that have a specific value in column C Lex	by Max	3	1,620
Macro problems Heine	by Bob Phillips	9	550
Quarter Dates LR	by Roger Govier	8	894
check for duplicate numbers Ash	by Roger Govier	13	1,228
How do I selectand copy only subtotals in a sheet Select and copy only subtotals in sheet	by Stefi	1	465
Text to rows...at wits end Anonon	by PY & Associates	3	569
cannot paste link using equal sign zizu	by David Biddulph	1	756
How on Earth do I use the GHK Function? Charles Matheson	by Ken Wright	3	744
How to concatenate an array of four stings using formulae (not UDF) Alan	by Alan	9	913
Read only files? Lost tabs on worksheetstoo! msjams516	by msjams516	0	465
convert time functions to numbers Patty	by JMB	1	572
FV Calculation problem bao	by JMB	1	596
Fv bao	by bao	0	357
Average if Curtis	by RagDyeR	10	648
conditional formatting error message Karla V	by Biff	3	724
Help with SUM and IF Amstro	by Biff	3	362
How to change cell reference within formulas CGSoniat	by RagDyeR	4	1,327