Excel Worksheet Functions - Page 449

Thread / Thread Starter	Last Post	Replies	Views
Formula to search for given term, and if not found in column to add it to list financier	by Pete_UK	3	656
Sorting Data From One Column into Multiple Columns Justin Hoffmann	by Justin Hoffmann	2	1,215
Import External Data -- Fill down formulas Issue Jonathan	by Jonathan	0	997
Floating Cells eppersbl	by eppersbl	2	823
How to format cells to show dates as the week-ending date of that dereksmom	by Bob Phillips	1	1,655
Need to create a error message box lostinformulas	by lostinformulas	4	436
If statement Mary	by RagDyeR	2	423
Horizontal arrow on cell edge and double-click, no matches found. Vic Tarrazi	by Vic Tarrazi	0	377
How do I retrieve & view multiple matches from another workbook? Michael	by Niek Otten	1	497
How do I highlight a column depending on other column value? Ada	by CLR	2	686
Tabs v.Pages DarklyCute1	by Roger Govier	1	369
Simplification help Mike Smith NC	by Bob Phillips	3	428
Count, Countif, Sumif?? benjam_in	by Bob Phillips	6	472
How do you copy a border down the page? Tammy	by Tammy	0	344
add leading zeros Jacqueline	by Arvi Laanemets	2	618
How do I sort Library of Congress call numbers in Excel? Casper	by PY & Associates	7	1,359
separating text dpdpdp	by dpdpdp	2	365
How do I set up a transport cost with mulit origins, destin,svcs [email protected]	by [email protected]	0	400
Formula/Macro to delete rows that do not meet criteria from a list? S Davis	by Ron Coderre	2	2,104
Formula non specific lookup taxmom	by taxmom	0	319
Average calcs - ignore sheets Blackstar79	by Bob Phillips	1	490
How can I covert dates to ccyymmdd? Payroll	by Marcelo	2	681
how can I compare two excel spreadsheets? Kathy	by lostinformulas	1	466
Reverse worksheet data by columns Bruce	by Gord Dibben	3	497
Extracting Data for a Formula from a List Zaraf	by Zaraf	2	409
Excel Charlene	by Gord Dibben	2	367
How to track inventory? rjez	by rjez	0	424
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA?	by	0	1,461
How do I write a comlicated conditional statement? OlYellerSnow	by OlYeller21	3	570
How can I find comon values in seperate spreadsheets? Bill in Wichita	by VBA Noob	2	346
get a count from multiple lookups andy62	by Max	10	1,005
How do I keep the font color with VLOOKUP? Joboozy	by Nick Hodge	1	1,753
funtions for colors for fonts or cell backgrounds? Yogi Smith	by Yogi Smith	5	728
How do I make excel not prompt before deleting worksheets? Lar Chen	by Gord Dibben	2	457
Delete Macro Saruman	by Gord Dibben	3	349
I can't change colors in certain Excel cells ArmyDad	by Gord Dibben	2	801
Auto Numbering System Smurf613	by Gord Dibben	1	670
Complex Nesting logstx095	by Biff	4	392
What is "Adjusted R^2" in Multiple Regression [email protected]	by [email protected]	3	1,148
How do you create a list & data validation in same cell? JLS	by andy62	2	494
More sort options - do they exist? shaunl	by shaunl	4	575
matching values that are not in order with conditional formatting TBA	by TBA	4	625
how to start using vlookup, match & index formulas, examples noninacio	by Max	3	724
Hyperlinking problems msteel	by Max	3	325
Using IF in an array L Martin	by Biff	1	348
How do I embed a two page word document in excel GregM	by GregM	0	1,179
set filename to <filename-date on open bob engler	by bob engler	2	1,105
Using the lookup Function for similar items to add together Brian	by Biff	1	949
Need to find a formula Lanza52	by Mallycat	1	399
Sumif with two conditions? thiensu	by Trevor Shuttleworth	1	417
Conditional Average across worksheets madduck	by Biff	3	1,023
Forcing DIV/0 to display "0" Pieter van der Walt	by Pieter van der Walt	2	367
list of sheets svko	by Max	1	503
IF in combination with larger than tom ossieur	by Bob Phillips	4	352
not sure which function to use for this summary evan	by Franz Verga	1	321
Sorting SumIF slim	by Franz Verga	1	1,019
how to expand the autofilter range 1000 to 10000? master777	by Max	3	1,034
Error when insering a "Right" function andy62	by Franz Verga	1	356
Relative addressing DOGMA-DOT	by Franz Verga	1	764
get a single count after looking up a set of values andy62	by Roger Govier	3	590
How do I do a vlookup that links to file paths within a cell ref Foozy	by paul	2	502
formula to remind me of an appointment 3 months in the future jamaicanbashi	by MartinW	2	678
Help..... with formula yhtak	by Dave Peterson	5	316
Please tell me this is possible Ryan	by Ryan	2	379
Converting US Dates to UK Formats Matt	by [email protected]	4	1,080
=NETWORKDAYS not working as expected and as it once did USAOz	by Ardus Petus	2	720
Stumped with an IF function Grant Reid	by Grant Reid	6	418
Help With Formulas IanEmery	by IanEmery	6	354
Sorting in Shared Workbook Colleen Tinney	by Colleen Tinney	0	380
Calculating cells with text only Cissy	by Franz Verga	1	371
index/match/replace InventoryQueryGuy	by InventoryQueryGuy	2	374
Repeat last action Teri	by Gord Dibben	5	940
How to Copy a Cell from one worksheet and return Gary Melvin	by Gary Melvin	0	387
Need help with dividing and using ISERROR for Div/0! durerca	by durerca	3	657
how do I open a publisher file in front page mike ramsey	by Gord Dibben	2	390