Excel Worksheet Functions - Page 656

Thread / Thread Starter	Last Post	Replies	Views
Help - Looking for a Sumproduct formula [email protected]	by Carim	4	555
text box linked to cell DJP	by Carim	1	501
Hi--how do I scramble a list randomly? lmcshelp	by paul	1	1,614
How to concatenate 3064 and 01 with 306401 as a result? MSOChick	by MSOChick	11	1,146
Eliminate second browse box when right clicking for hyperlink Dirter Scott	by Dirter Scott	0	389
How can I use Excel to mark student's tests? Brownsugar9686	by GeneR	1	616
Ask user for information Aaron	by Aaron	0	364
Summing across Worksheets justvree	by RagDyeR	9	811
formula for counting TMF in MN	by Epinn	7	475
Does anyone know if there is a symbol for the "except" in formula? Kelvin yu	by Biff	2	474
Yes and No Dragan Ristic	by Dragan Ristic	5	529
Need help with COUNTIF Bob	by Biff	7	402
Linking Sheets Lynda	by Roger Govier	10	1,070
lotus 123 worksheet function conversion andresg1975	by andresg1975	2	992
countif Column A and excule column B if it's cancelled LLWest	by Biff	4	875
Array formula with a constant? Tester	by Biff	4	842
cancelling getpivot formula when setting formula outside pivot ta. cancelling getpivot formula	by PÃ©	2	805
Sumproduct value error Brad	by Biff	7	562
Advance Sumproduct calculation Brad	by Brad	8	736
Lookup and summing comparison Graham Haughs	by Toppers	8	429
Restricting a Spreadsheet so users cannot save changes GeneR	by Harlan Grove	1	1,231
How to create Cascading Drop-Down Lists? John	by Paul B	1	1,075
Date determination and sums UnderCoverGuy	by UnderCoverGuy	0	540
How do I seperate a full name field out into three seperate columns? Rod	by [email protected]	3	1,227
how can i capitalise text in an existing workbook craigs rus	by Ron de Bruin	1	658
Looking up a value from one cell in another range of cells [email protected]	by Herbert Seidenberg	2	469
Count cells in a column that has a autofilter Irv	by Ron de Bruin	1	509
NULL Cells UnderCoverGuy	by UnderCoverGuy	4	485
Auto e-mail message Freshman	by Ron de Bruin	1	535
Referencing another worksheet via a cell [email protected]	by [email protected]	2	552
use track changes and macros Jerjuice	by Jerjuice	0	517
Same page with Different Page numbers CFodor	by Ron de Bruin	1	975
index_match_error! via135 via OfficeKB.com	by via135 via OfficeKB.com	8	494
I need to add check boxes to my Excel spreadsheet,checked and not Spydermike	by Allllen	1	481
BackFill Zeros dallin	by Ron Coderre	1	1,261
Can the contents of a drop down box differ from what's entered? ForkHandles	by Jim Thomlinson	1	522
Worksheet naming using visual basic O'C	by O'C	2	826
Match cells with cells on another workbook James1976	by Allllen	1	1,091
Soundex converter formula? Vanessa	by Vanessa	0	2,393
MATCHING DATE TO A WEEKDAY Stuart Carnachan	by Roger Govier	3	711
how to change the insertion point color? smc11ca	by smc11ca	0	524
Excel Group & Sum function shikarishambu	by shikarishambu	2	977
Move data Horacio	by Horacio	2	590
Excel equivalent of sql group by count shikarishambu	by shikarishambu	2	1,584
How can I get a cell to Flash if it meets a certain criteria in Ex tcfoote	by Ron Coderre	1	647
How to set up an excel formula to copy cells to another worksheet? SLN	by SLN	3	474
lookup on Table including blanks - Nir	by Lori	7	579
How do you protect Headers and Footers in MOFFICE Tommydraw123	by Tommydraw123	0	772
Show input box with cell value [email protected]	by Sandy	4	1,158
Splitting cells - please help! Danny boy	by Ron Rosenfeld	11	976
Tie a Calendar week to a Scoped Projected Week [email protected]	by Gary Brown	3	620
Conditional formats using more than 3 conditions Al_Doug	by Allllen	2	346
Format Date [email protected]	by Lori	4	335
Drop Down List choice selecting another drop down list CVD0722	by CVD0722	3	1,552
How do i calculate the saved amount ? bao	by Niek Otten	1	565
Date Interval Predictions [email protected]	by Roger Govier	1	430
Maximum length of a number PÃ©	by Ron Rosenfeld	1	809
Formula Too Long Tom Young	by Lori	15	1,076
Group & sort rows that have a specific value in column C Lex	by Max	3	1,607
Macro problems Heine	by Bob Phillips	9	534
Quarter Dates LR	by Roger Govier	8	884
check for duplicate numbers Ash	by Roger Govier	13	1,187
How do I selectand copy only subtotals in a sheet Select and copy only subtotals in sheet	by Stefi	1	458
Text to rows...at wits end Anonon	by PY & Associates	3	555
cannot paste link using equal sign zizu	by David Biddulph	1	733
How on Earth do I use the GHK Function? Charles Matheson	by Ken Wright	3	732
How to concatenate an array of four stings using formulae (not UDF) Alan	by Alan	9	894
Read only files? Lost tabs on worksheetstoo! msjams516	by msjams516	0	458
convert time functions to numbers Patty	by JMB	1	565
FV Calculation problem bao	by JMB	1	580
Fv bao	by bao	0	334
Average if Curtis	by RagDyeR	10	640
conditional formatting error message Karla V	by Biff	3	705
Help with SUM and IF Amstro	by Biff	3	348
How to change cell reference within formulas CGSoniat	by RagDyeR	4	1,298