Excel Worksheet Functions - Page 693

Thread / Thread Starter	Last Post	Replies	Views
Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' Zona	by Dan Hatola	1	908
what causes this error" too many different cell formats" Bashar	by Ron Rosenfeld	3	353
limit characters returned a cell reference Lila	by Dave Peterson	8	606
Excel 2003; spreadsheet with filtering; deleting rows MHcoTech	by MHcoTech	0	544
Calculation vs formula Steve Stad	by RagDyeR	2	577
Locate unique items MarkN	by MarkN	5	404
formulas appear as text instead of doing as expected Papa Jonah	by RagDyeR	7	449
Automatically generating a number range Alyssa C.	by Ron Coderre	2	598
Return Min & Max value of Conditional Formatted cells Sam via OfficeKB.com	by Domenic	20	1,951
Using IF function when "#value!" is present. [email protected]	by Biff	3	341
Help with rounding formulas TriciaF	by Ron Rosenfeld	2	346
ignore #N/A in a sum? Todd	by Gord Dibben	3	1,390
Sorting rows by pairs justlearnin	by Dave Peterson	5	5,452
How to link a drop down value to a cell in a different worksheet? cdkjpm	by Biff	1	1,085
Working with hyperlinks kwidener	by Toppers	1	463
Output client name based on date... Ted McCastlain	by Ted McCastlain	0	443
Text String Seperation. [email protected]	by [email protected]	2	449
Delete first two characters in a cell... ChuckF	by bj	6	5,981
perform an event if mouse rolled over an object [email protected]	by [email protected]	0	465
Document at 100% doesn't print correctly missfunny now	by Dave F	2	468
why is the zero falling off a zip code in excel? Pam	by Dave Peterson	3	623
range inside RANK formula based on contents of other cells andy62	by Biff	3	766
Formula Help Curtis	by Curtis	5	381
Please help w/Sumproduct! bkt	by shail	2	396
Need a AHLookup function TRRed1	by shail	1	524
Sumproduct (Sumif) with Nested Or Criteria bkt	by shail	9	1,519
Excel: Changing "numeric $" to "text $" in a different cell. Heather_CCF	by Jim Thomlinson	1	956
update link Link Updates	by Dave Peterson	1	419
Delete the number "49" from each cell in a column se12	by Gord Dibben	18	1,500
a exact string search inquiry vito	by wal50	9	1,029
automatically fill in blank cells?? AlaskaMX	by Gord Dibben	6	984
Transferring data from one worksheet or workbook to another Janine	by [email protected]	5	606
Converting Numeric values to Text shail	by shail	2	630
Random number selection kwidener	by kwidener	5	654
a cell to display number of days in a month given in another cell sudip	by Franz Verga	1	805
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected]	by [email protected]	0	5,535
Convert column data to semicolon delimited text string Richard RE	by David Billigmeier	1	3,521
total on filtered data? martyn	by Pete_UK	3	1,105
How to remove commas from a downloaded .dat file? arvind	by arvind	3	1,205
Problems with MAX Carlo	by Carlo	6	470
linking items from drop down list in excel jog	by Toppers	1	794
Limiting what it displayed from drop down menu Orion96	by Orion96	4	338
How do I arrange the worksheets in my workbook alphabetically? Kiara Parker	by Jim Cone	2	729
Complex IF Anita	by Stefi	5	511
I need help with a text and quantity summary report. triffidbook	by triffidbook	2	611
How do I delete specified times from a spreadsheet Jay	by Roger Govier	1	401
Creating an Invoice Total Excel Novice	by Roger Govier	1	387
Extending VLOOKUP Krish	by JMB	2	370
Frame Type swap action, how??? Jay	by Jay	0	425
How to use vlookup when lookup contains number and letters TGL	by Biff	4	1,609
Unhide function grayed out, why? Jay	by Carlos Antenna	1	1,165
Function for Totals Gymclass14	by Dave Peterson	1	394
simply function not work ViestaWu	by ViestaWu	10	997
Dual Formatting in Macro Slashman	by Ron Rosenfeld	9	415
strings in a range Peter Morris	by Peter Morris	4	563
What is the Excel equivalent of the CELL function? JP	by JP	8	1,426
Reading results for automated Myers Briggs Type Indicator? Jetlag	by Jetlag	2	1,353
Excel formula help needed-How to separate last and first names? Jan	by Jan	2	464
Vlookup by rows and columns puukoi	by puukoi	2	562
entry not removed in pivot table pull down filter EL in Melb.	by Debra Dalgleish	1	632
copy formats vlookup Andre Ronda	by Dave Peterson	1	740
Excel error:ROUND(1000.2555-999,3)=1.255 liaosheng	by Jerry W. Lewis	5	454
Sum Valour From different Columns Vanessa Simmonds	by Bob Phillips	2	364
If function Soz	by Soz	4	372
formula to add certain data and then move to another sheet wiersma7	by Bernard Liengme	1	445
Copying forumla for vlook up but changing the column Index # klafert	by Biff	21	2,074
Changing one cell colour by inserting date in another cell JohannM	by Carim	3	568
Code to clear contents jk	by jk	3	450
Generating an auto number JohannM	by JLatham	1	370
Referencing other workbook. [email protected]	by JLatham	1	408
How to cancel a find & replace command "midstream"? Matt from GVA	by Matt from GVA	4	6,925
update week to week in excel. Rudy	by Nobody	2	738
How do I restore my hash key on my keyboard? Nanny B	by Nanny B	2	2,124
I've changed the way my formulas are displayed !! Dave	by Dave	4	420
Can't figure out Mark Jackson	by Franz Verga	1	471