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	932
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	643
Excel 2003; spreadsheet with filtering; deleting rows MHcoTech	by MHcoTech	0	556
Calculation vs formula Steve Stad	by RagDyeR	2	585
Locate unique items MarkN	by MarkN	5	414
formulas appear as text instead of doing as expected Papa Jonah	by RagDyeR	7	456
Automatically generating a number range Alyssa C.	by Ron Coderre	2	614
Return Min & Max value of Conditional Formatted cells Sam via OfficeKB.com	by Domenic	20	1,972
Using IF function when "#value!" is present. [email protected]	by Biff	3	356
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,512
How to link a drop down value to a cell in a different worksheet? cdkjpm	by Biff	1	1,097
Working with hyperlinks kwidener	by Toppers	1	468
Output client name based on date... Ted McCastlain	by Ted McCastlain	0	452
Text String Seperation. [email protected]	by [email protected]	2	454
Delete first two characters in a cell... ChuckF	by bj	6	5,998
perform an event if mouse rolled over an object [email protected]	by [email protected]	0	480
Document at 100% doesn't print correctly missfunny now	by Dave F	2	476
why is the zero falling off a zip code in excel? Pam	by Dave Peterson	3	641
range inside RANK formula based on contents of other cells andy62	by Biff	3	780
Formula Help Curtis	by Curtis	5	392
Please help w/Sumproduct! bkt	by shail	2	402
Need a AHLookup function TRRed1	by shail	1	528
Sumproduct (Sumif) with Nested Or Criteria bkt	by shail	9	1,535
Excel: Changing "numeric $" to "text $" in a different cell. Heather_CCF	by Jim Thomlinson	1	1,064
update link Link Updates	by Dave Peterson	1	430
Delete the number "49" from each cell in a column se12	by Gord Dibben	18	1,544
a exact string search inquiry vito	by wal50	9	1,053
automatically fill in blank cells?? AlaskaMX	by Gord Dibben	6	999
Transferring data from one worksheet or workbook to another Janine	by [email protected]	5	620
Converting Numeric values to Text shail	by shail	2	646
Random number selection kwidener	by kwidener	5	675
a cell to display number of days in a month given in another cell sudip	by Franz Verga	1	846
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected]	by [email protected]	0	5,668
Convert column data to semicolon delimited text string Richard RE	by David Billigmeier	1	3,551
total on filtered data? martyn	by Pete_UK	3	1,196
How to remove commas from a downloaded .dat file? arvind	by arvind	3	1,239
Problems with MAX Carlo	by Carlo	6	495
linking items from drop down list in excel jog	by Toppers	1	807
Limiting what it displayed from drop down menu Orion96	by Orion96	4	349
How do I arrange the worksheets in my workbook alphabetically? Kiara Parker	by Jim Cone	2	739
Complex IF Anita	by Stefi	5	529
I need help with a text and quantity summary report. triffidbook	by triffidbook	2	619
How do I delete specified times from a spreadsheet Jay	by Roger Govier	1	408
Creating an Invoice Total Excel Novice	by Roger Govier	1	395
Extending VLOOKUP Krish	by JMB	2	376
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,613
Unhide function grayed out, why? Jay	by Carlos Antenna	1	1,180
Function for Totals Gymclass14	by Dave Peterson	1	397
simply function not work ViestaWu	by ViestaWu	10	1,012
Dual Formatting in Macro Slashman	by Ron Rosenfeld	9	422
strings in a range Peter Morris	by Peter Morris	4	594
What is the Excel equivalent of the CELL function? JP	by JP	8	1,441
Reading results for automated Myers Briggs Type Indicator? Jetlag	by Jetlag	2	1,363
Excel formula help needed-How to separate last and first names? Jan	by Jan	2	492
Vlookup by rows and columns puukoi	by puukoi	2	567
entry not removed in pivot table pull down filter EL in Melb.	by Debra Dalgleish	1	646
copy formats vlookup Andre Ronda	by Dave Peterson	1	757
Excel error:ROUND(1000.2555-999,3)=1.255 liaosheng	by Jerry W. Lewis	5	469
Sum Valour From different Columns Vanessa Simmonds	by Bob Phillips	2	369
If function Soz	by Soz	4	384
formula to add certain data and then move to another sheet wiersma7	by Bernard Liengme	1	453
Copying forumla for vlook up but changing the column Index # klafert	by Biff	21	2,100
Changing one cell colour by inserting date in another cell JohannM	by Carim	3	584
Code to clear contents jk	by jk	3	466
Generating an auto number JohannM	by JLatham	1	379
Referencing other workbook. [email protected]	by JLatham	1	426
How to cancel a find & replace command "midstream"? Matt from GVA	by Matt from GVA	4	6,995
update week to week in excel. Rudy	by Nobody	2	758
How do I restore my hash key on my keyboard? Nanny B	by Nanny B	2	2,144
I've changed the way my formulas are displayed !! Dave	by Dave	4	425
Can't figure out Mark Jackson	by Franz Verga	1	481