Excel Worksheet Functions - Page 622

Thread / Thread Starter	Last Post	Replies	Views
Lookup last value that does not equal certain value [email protected]	by JMB	4	1,094
Data sort over 200 worksheets - Help please Dave T	by JLatham	5	534
<!Excel and Arrow Keys! Torrin Miller	by Nick Hodge	1	625
If Function DHM	by Don Guillett	10	780
tab question crisgrnr	by Don Guillett	4	406
Excel csv spreadsheet-How to save info exceeding 20 columns Taurus13	by Taurus13	0	430
Need help with formula Helpme	by Helpme	4	348
MODE Function cesar	by Teethless mama	1	365
Formulas in a range of cells lmc	by T. Valko	5	424
difference between the 2 bda019	by Michael M	1	465
"No RETURN() or HALT() function found on macro sheet." Will	by Will	2	1,949
Macro to hide the row if both columns E & F are blank in that row. PCakes	by PCakes	2	676
How do I only display highlighted fields in excel View only highlighted fields	by Gord Dibben	2	3,554
Power and Sum John Watt	by Bernard Liengme	6	708
Help with VLOOKUP or other matching function mpenkala	by mpenkala	4	456
pivot tables tom	by Dave F	1	307
Is there a way to use a field link to rename a worksheet ? John H.	by Gord Dibben	6	564
Formula Error Question Office Princess	by Bernard Liengme	1	374
Setting up slide scale for prices Ted Metro	by Niek Otten	2	702
Automatically prefix cell entry rossinvrland	by rossinvrland	5	1,171
Continue typing in a cell after leaving the workbook. Andy	by Andy	4	2,063
Add number from a cell that contains a specific character Carole	by Carole	0	669
averaging range across sheets after transforming text to value Keith	by Keith	3	488
need 4 conditions for conditional formatting and there are only 3 pm	by Teethless mama	2	514
Using the replace function less caldog	by caldog	0	363
Filter data & sum or avg the results? bryan stewart	by Gord Dibben	3	577
Change Exel headers text. ? KalliMan	by Gord Dibben	2	452
VLOOKUP() Question mastermind	by mastermind	2	396
deleting worksheets from workbook when option not available Rita318	by Gord Dibben	3	495
using sum function,can I avoid calculating hidden rows UB	by Peo Sjoblom	7	1,284
Conversion of numbers Arne Hegefors	by Harlan Grove	8	532
File-search results in worksheet hmm	by Gary''s Student	8	641
Template Wizard with Data Tracking Will	by Gord Dibben	5	540
COUNTIF Help cesar	by cesar	5	470
COUNTIF across multiple workbooks JDB	by Bob Phillips	8	5,919
Code to include a one-up suffix to a field value Doctorjones_md	by Bob Phillips	4	514
vlookup with conditional formatting pm	by Peo Sjoblom	1	751
Logic Formula Truc Lopez	by RagDyeR	6	481
Calculating Calls closed in Given periods phocused	by phocused	2	503
Search multiple sheets and return largest number found mpenkala	by mpenkala	2	1,046
COUNTIF Function mpenkala	by mpenkala	2	356
count in several colums lee	by RagDyeR	10	738
Sumproduct not returning expected results Dos Equis	by Sandy Mann	8	639
Nested If help JoeA2006	by Bob Phillips	2	483
How do I reference a cell as PART of a vlookup "Table_Array" locat -Rocket	by -Rocket	2	808
Merge content of cells Arne Hegefors	by Dave Peterson	2	491
Importing signed over-punch text into Excel ALEX	by ALEX	2	2,634
Logic Formulas BWatson10	by Lori	3	567
How do I sort pivot table data outside a pivot table Michael	by Bernie Deitrick	1	4,278
Can I 'auto update' my spreadsheet ? Rich	by CLR	5	590
NPV and IRR Meredith	by Meredith	1	483
indirect function referenceing changing file name Spike	by Spike	3	1,276
Converting TEXT to DATE GFH	by Lori	3	673
Excel: Syntax to change cell color based on color of another cell davew18	by CLR	1	3,409
Excel Worksheets within a Workbook Lisa	by David Biddulph	3	556
lookup returning incorrect cell values stuartjk	by stuartjk	8	901
Format Cells to show different values bony_tony	by Roger Govier	2	642
If function with more than 7 conditions joie	by Roger Govier	3	1,581
Find missing values in a series petermcwerner	by petermcwerner	10	1,749
More then 7 nested If functions. Sarah	by T. Valko	2	829
Hide cell values based on a condition in another cell Cat	by Max	1	1,869
Sumproduct problem [email protected]	by T. Valko	1	435
re my new problem HANYANA via OfficeKB.com	by Max	6	422
insert page number in work sheet Nandkish	by Nandkish	2	1,195
SUMPRODUCT Woodi2	by JMB	1	433
Counting Unique entry from Concatenated list Rajat	by Rajat	28	1,943
Amortization 30/365 HUNGRY	by [email protected]	1	3,540
black and white display jaidencam	by Gord Dibben	1	1,158
please simplify mysearch formula. been drilbled to 2007	by T. Valko	3	457
date related question??? _Bigred	by Franz Verga	1	662
new number after printing Kelzina	by Kelzina	0	341
Return dates based on month and day of week lesg46	by Bill	8	1,030
Auto change background of color based on formula fredwing	by Gord Dibben	3	1,057
How can up type text upsidedown in a cell please not 90 degrees Justin	by Dave Peterson	4	5,318
embedding "ISERROR" function into an "IF" statement [email protected]	by Bob Phillips	8	1,620