Excel Worksheet Functions - Page 491

Thread / Thread Starter	Last Post	Replies	Views
How to use vlookup when lookup contains number and letters TGL	by Biff	4	1,599
Frame Type swap action, how??? Jay	by Jay	0	415
Extending VLOOKUP Krish	by JMB	2	366
Creating an Invoice Total Excel Novice	by Roger Govier	1	378
How do I delete specified times from a spreadsheet Jay	by Roger Govier	1	394
I need help with a text and quantity summary report. triffidbook	by triffidbook	2	578
Complex IF Anita	by Stefi	5	502
How do I arrange the worksheets in my workbook alphabetically? Kiara Parker	by Jim Cone	2	725
Limiting what it displayed from drop down menu Orion96	by Orion96	4	332
linking items from drop down list in excel jog	by Toppers	1	789
Problems with MAX Carlo	by Carlo	6	469
How to remove commas from a downloaded .dat file? arvind	by arvind	3	1,187
total on filtered data? martyn	by Pete_UK	3	1,096
Convert column data to semicolon delimited text string Richard RE	by David Billigmeier	1	3,511
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected]	by [email protected]	0	5,508
a cell to display number of days in a month given in another cell sudip	by Franz Verga	1	800
Random number selection kwidener	by kwidener	5	650
Converting Numeric values to Text shail	by shail	2	624
Transferring data from one worksheet or workbook to another Janine	by [email protected]	5	603
automatically fill in blank cells?? AlaskaMX	by Gord Dibben	6	979
a exact string search inquiry vito	by wal50	9	1,019
Delete the number "49" from each cell in a column se12	by Gord Dibben	18	1,493
update link Link Updates	by Dave Peterson	1	417
Excel: Changing "numeric $" to "text $" in a different cell. Heather_CCF	by Jim Thomlinson	1	933
Sumproduct (Sumif) with Nested Or Criteria bkt	by shail	9	1,513
Need a AHLookup function TRRed1	by shail	1	514
Please help w/Sumproduct! bkt	by shail	2	388
Formula Help Curtis	by Curtis	5	371
range inside RANK formula based on contents of other cells andy62	by Biff	3	757
why is the zero falling off a zip code in excel? Pam	by Dave Peterson	3	614
Document at 100% doesn't print correctly missfunny now	by Dave F	2	467
perform an event if mouse rolled over an object [email protected]	by [email protected]	0	454
Delete first two characters in a cell... ChuckF	by bj	6	5,979
Text String Seperation. [email protected]	by [email protected]	2	443
Output client name based on date... Ted McCastlain	by Ted McCastlain	0	438
Working with hyperlinks kwidener	by Toppers	1	457
How to link a drop down value to a cell in a different worksheet? cdkjpm	by Biff	1	1,076
Sorting rows by pairs justlearnin	by Dave Peterson	5	5,449
ignore #N/A in a sum? Todd	by Gord Dibben	3	1,380
Help with rounding formulas TriciaF	by Ron Rosenfeld	2	336
Using IF function when "#value!" is present. [email protected]	by Biff	3	339
Return Min & Max value of Conditional Formatted cells Sam via OfficeKB.com	by Domenic	20	1,943
Automatically generating a number range Alyssa C.	by Ron Coderre	2	594
formulas appear as text instead of doing as expected Papa Jonah	by RagDyeR	7	442
Locate unique items MarkN	by MarkN	5	399
Calculation vs formula Steve Stad	by RagDyeR	2	530
Excel 2003; spreadsheet with filtering; deleting rows MHcoTech	by MHcoTech	0	524
limit characters returned a cell reference Lila	by Dave Peterson	8	598
what causes this error" too many different cell formats" Bashar	by Ron Rosenfeld	3	348
Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' Zona	by Dan Hatola	1	903
pivot tables not refreshing correctly Tom G.	by Tom G.	0	847
entry removed from source table remains in pivot table pull down EL in Melb.	by Roger Govier	1	871
Sumif across workbook tabs tj	by Roger Govier	2	2,506
Multiplying the contents of two cells a variable number of times Stephen Brown	by Roger Govier	1	685
I need to search for then extract a specific portion of cell data... Ken	by Ron Rosenfeld	15	1,168
Help with formula Soth	by shail	9	347
Maybe an array is needed? Arturo	by Bob Umlas	1	410
Member database question! Lars Grøtteland	by Lars Grøtteland	0	467
how do i get a cell in a sheet to show the last 1024 characters? XenneX	by Dave Peterson	1	567
Compare two strings andy62	by Ron Rosenfeld	8	2,915
Use of Array Pivot Table for Percentile Calculation ... Elize	by Elize	0	1,173
Using IF function in excel to search for text across cells and she Rup1776	by Nobody	7	1,492
Posting lowest values in a seperate worksheet. [email protected]	by [email protected]	2	378
How do I make sure all empty columns are present in a .csv file? Decision Assist	by Dave F	1	615
How to save Excel, using macro which takes the name from a cell contained in it? [email protected]	by Bernie Deitrick	1	425
Create an annuity in Excel having monthly deposits plus interest gas	by Bernie Deitrick	1	962
Need formula for looking (finding) emilija	by shail	3	265
sumproduct Dewayne	by Dewayne	3	401
How do get I my schedule to open at the current date? Maurice	by Bob Phillips	1	395
Copying From Closed Workbooks Mike	by Ron de Bruin	3	497
VLOOKUP returning errors Dave F	by bj	4	605
Automatically replace cell value with next in list... ChuckF	by ChuckF	2	445
Find address of active cell Dave	by Dave	5	1,198
I need to change cell string lenths prior to upload into sql table kevt	by Toppers	1	553
My files in excel have been inverted . dieder	by Stephen Bye	2	536