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	923
what causes this error" too many different cell formats" Bashar	by Ron Rosenfeld	3	368
limit characters returned a cell reference Lila	by Dave Peterson	8	640
Excel 2003; spreadsheet with filtering; deleting rows MHcoTech	by MHcoTech	0	555
Calculation vs formula Steve Stad	by RagDyeR	2	583
Locate unique items MarkN	by MarkN	5	414
formulas appear as text instead of doing as expected Papa Jonah	by RagDyeR	7	455
Automatically generating a number range Alyssa C.	by Ron Coderre	2	605
Return Min & Max value of Conditional Formatted cells Sam via OfficeKB.com	by Domenic	20	1,967
Using IF function when "#value!" is present. [email protected]	by Biff	3	355
Help with rounding formulas TriciaF	by Ron Rosenfeld	2	354
ignore #N/A in a sum? Todd	by Gord Dibben	3	1,412
Sorting rows by pairs justlearnin	by Dave Peterson	5	5,511
How to link a drop down value to a cell in a different worksheet? cdkjpm	by Biff	1	1,096
Working with hyperlinks kwidener	by Toppers	1	468
Output client name based on date... Ted McCastlain	by Ted McCastlain	0	451
Text String Seperation. [email protected]	by [email protected]	2	454
Delete first two characters in a cell... ChuckF	by bj	6	5,996
perform an event if mouse rolled over an object [email protected]	by [email protected]	0	479
Document at 100% doesn't print correctly missfunny now	by Dave F	2	475
why is the zero falling off a zip code in excel? Pam	by Dave Peterson	3	639
range inside RANK formula based on contents of other cells andy62	by Biff	3	780
Formula Help Curtis	by Curtis	5	391
Please help w/Sumproduct! bkt	by shail	2	402
Need a AHLookup function TRRed1	by shail	1	527
Sumproduct (Sumif) with Nested Or Criteria bkt	by shail	9	1,530
Excel: Changing "numeric $" to "text $" in a different cell. Heather_CCF	by Jim Thomlinson	1	978
update link Link Updates	by Dave Peterson	1	428
Delete the number "49" from each cell in a column se12	by Gord Dibben	18	1,542
a exact string search inquiry vito	by wal50	9	1,043
automatically fill in blank cells?? AlaskaMX	by Gord Dibben	6	996
Transferring data from one worksheet or workbook to another Janine	by [email protected]	5	618
Converting Numeric values to Text shail	by shail	2	642
Random number selection kwidener	by kwidener	5	673
a cell to display number of days in a month given in another cell sudip	by Franz Verga	1	820
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected]	by [email protected]	0	5,564
Convert column data to semicolon delimited text string Richard RE	by David Billigmeier	1	3,544
total on filtered data? martyn	by Pete_UK	3	1,118
How to remove commas from a downloaded .dat file? arvind	by arvind	3	1,237
Problems with MAX Carlo	by Carlo	6	494
linking items from drop down list in excel jog	by Toppers	1	804
Limiting what it displayed from drop down menu Orion96	by Orion96	4	347
How do I arrange the worksheets in my workbook alphabetically? Kiara Parker	by Jim Cone	2	738
Complex IF Anita	by Stefi	5	523
I need help with a text and quantity summary report. triffidbook	by triffidbook	2	617
How do I delete specified times from a spreadsheet Jay	by Roger Govier	1	405
Creating an Invoice Total Excel Novice	by Roger Govier	1	395
Extending VLOOKUP Krish	by JMB	2	375
Frame Type swap action, how??? Jay	by Jay	0	434
How to use vlookup when lookup contains number and letters TGL	by Biff	4	1,612
Unhide function grayed out, why? Jay	by Carlos Antenna	1	1,177
Function for Totals Gymclass14	by Dave Peterson	1	397
simply function not work ViestaWu	by ViestaWu	10	1,011
Dual Formatting in Macro Slashman	by Ron Rosenfeld	9	422
strings in a range Peter Morris	by Peter Morris	4	579
What is the Excel equivalent of the CELL function? JP	by JP	8	1,435
Reading results for automated Myers Briggs Type Indicator? Jetlag	by Jetlag	2	1,362
Excel formula help needed-How to separate last and first names? Jan	by Jan	2	489
Vlookup by rows and columns puukoi	by puukoi	2	565
entry not removed in pivot table pull down filter EL in Melb.	by Debra Dalgleish	1	641
copy formats vlookup Andre Ronda	by Dave Peterson	1	754
Excel error:ROUND(1000.2555-999,3)=1.255 liaosheng	by Jerry W. Lewis	5	468
Sum Valour From different Columns Vanessa Simmonds	by Bob Phillips	2	369
If function Soz	by Soz	4	382
formula to add certain data and then move to another sheet wiersma7	by Bernard Liengme	1	451
Copying forumla for vlook up but changing the column Index # klafert	by Biff	21	2,097
Changing one cell colour by inserting date in another cell JohannM	by Carim	3	582
Code to clear contents jk	by jk	3	460
Generating an auto number JohannM	by JLatham	1	377
Referencing other workbook. [email protected]	by JLatham	1	425
How to cancel a find & replace command "midstream"? Matt from GVA	by Matt from GVA	4	6,983
update week to week in excel. Rudy	by Nobody	2	749
How do I restore my hash key on my keyboard? Nanny B	by Nanny B	2	2,135
I've changed the way my formulas are displayed !! Dave	by Dave	4	424
Can't figure out Mark Jackson	by Franz Verga	1	480