Excel Worksheet Functions - Page 528

Thread / Thread Starter	Last Post	Replies	Views
Splitting cells - please help! Danny boy	by Ron Rosenfeld	11	969
Show input box with cell value [email protected]	by Sandy	4	1,153
How do you protect Headers and Footers in MOFFICE Tommydraw123	by Tommydraw123	0	732
lookup on Table including blanks - Nir	by Lori	7	579
How to set up an excel formula to copy cells to another worksheet? SLN	by SLN	3	465
How can I get a cell to Flash if it meets a certain criteria in Ex tcfoote	by Ron Coderre	1	637
Excel equivalent of sql group by count shikarishambu	by shikarishambu	2	1,583
Move data Horacio	by Horacio	2	584
Excel Group & Sum function shikarishambu	by shikarishambu	2	974
how to change the insertion point color? smc11ca	by smc11ca	0	523
MATCHING DATE TO A WEEKDAY Stuart Carnachan	by Roger Govier	3	709
Soundex converter formula? Vanessa	by Vanessa	0	2,391
Match cells with cells on another workbook James1976	by Allllen	1	1,089
Worksheet naming using visual basic O'C	by O'C	2	823
Can the contents of a drop down box differ from what's entered? ForkHandles	by Jim Thomlinson	1	519
BackFill Zeros dallin	by Ron Coderre	1	1,261
I need to add check boxes to my Excel spreadsheet,checked and not Spydermike	by Allllen	1	479
index_match_error! via135 via OfficeKB.com	by via135 via OfficeKB.com	8	494
Same page with Different Page numbers CFodor	by Ron de Bruin	1	973
use track changes and macros Jerjuice	by Jerjuice	0	513
Referencing another worksheet via a cell [email protected]	by [email protected]	2	549
Auto e-mail message Freshman	by Ron de Bruin	1	533
NULL Cells UnderCoverGuy	by UnderCoverGuy	4	482
Count cells in a column that has a autofilter Irv	by Ron de Bruin	1	509
Looking up a value from one cell in another range of cells [email protected]	by Herbert Seidenberg	2	469
how can i capitalise text in an existing workbook craigs rus	by Ron de Bruin	1	651
How do I seperate a full name field out into three seperate columns? Rod	by [email protected]	3	1,219
Date determination and sums UnderCoverGuy	by UnderCoverGuy	0	534
How to create Cascading Drop-Down Lists? John	by Paul B	1	1,073
Restricting a Spreadsheet so users cannot save changes GeneR	by Harlan Grove	1	1,230
Lookup and summing comparison Graham Haughs	by Toppers	8	425
Advance Sumproduct calculation Brad	by Brad	8	733
Sumproduct value error Brad	by Biff	7	557
cancelling getpivot formula when setting formula outside pivot ta. cancelling getpivot formula	by PÃ©	2	800
Array formula with a constant? Tester	by Biff	4	842
countif Column A and excule column B if it's cancelled LLWest	by Biff	4	873
lotus 123 worksheet function conversion andresg1975	by andresg1975	2	989
Linking Sheets Lynda	by Roger Govier	10	1,069
Need help with COUNTIF Bob	by Biff	7	400
Yes and No Dragan Ristic	by Dragan Ristic	5	529
Does anyone know if there is a symbol for the "except" in formula? Kelvin yu	by Biff	2	472
formula for counting TMF in MN	by Epinn	7	471
Summing across Worksheets justvree	by RagDyeR	9	810
Ask user for information Aaron	by Aaron	0	360
How can I use Excel to mark student's tests? Brownsugar9686	by GeneR	1	613
Eliminate second browse box when right clicking for hyperlink Dirter Scott	by Dirter Scott	0	388
How to concatenate 3064 and 01 with 306401 as a result? MSOChick	by MSOChick	11	1,145
Hi--how do I scramble a list randomly? lmcshelp	by paul	1	1,613
text box linked to cell DJP	by Carim	1	500
Help - Looking for a Sumproduct formula [email protected]	by Carim	4	550
How to switch position of columns and rows respectively? David Biddulph	by David Biddulph	0	423
Not getting messages in OE Biff	by Biff	2	705
Counting Unique Values Bob	by Jamie Collins	38	5,255
How do I set up for greater than 3 formats in excel? Stephen	by Ken Wright	1	486
how to use GETFORMULA() in EXCEL 2003? romelsb	by Lori	2	1,290
Wildcard character inside sumproduct andy62	by Lori	4	1,808
vlookup returns bad data SelfTaught_InNeedOfPro	by Roger Govier	3	931
Filling values in a grid Cecilia	by Lori	4	379
Filtering using Formulas Debbie D.	by Debbie D.	2	395
how can I multiply number of hours and minutes by hourly rate? cab0419	by cab0419	5	3,101
Formula to subtract values in one cell only... neilcarden	by neilcarden	0	363
How do I work with swedish excel 2003 that uses EDATUM DaveT	by Niek Otten	1	676
MATCH FUNCTION AND SERIAL DATE CONFLICTS Jones the Scouse	by Lori	4	974
SMALL() on unknown length of list [email protected]	by Bernie Deitrick	9	725
cell value<presented value Nir	by Bernie Deitrick	1	317
percentage completed and colors Junior	by Bernie Deitrick	1	684
Is there an easy way to find/display merged cells in excel Ronald J.	by Ronald J.	2	1,023
Combining two work sheets using a column in both as a key TwoTone	by DaveT	1	460
Can COUNTIF be nested to search two ranges Jimbob	by [email protected]	4	892
Get count for a table of dates [email protected]	by [email protected]	1	393
how to apply the same header or footer to all sheets in workbook Luenda Burke	by David McRitchie	1	1,564
Help please - looking for a formula [email protected]	by Harlan Grove	5	547
Excel won't calculate formulas unless I press F9 - HELP!!! Larry_thornton	by Larry_thornton	1	1,239
Paste Special Not Working Joe VW	by Dave Peterson	1	2,054
Change the "Insert Function" display for mail merge Beach Lover	by Beach Lover	3	506