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,097
Data sort over 200 worksheets - Help please Dave T	by JLatham	5	534
<!Excel and Arrow Keys! Torrin Miller	by Nick Hodge	1	626
If Function DHM	by Don Guillett	10	810
tab question crisgrnr	by Don Guillett	4	412
Excel csv spreadsheet-How to save info exceeding 20 columns Taurus13	by Taurus13	0	435
Need help with formula Helpme	by Helpme	4	351
MODE Function cesar	by Teethless mama	1	371
Formulas in a range of cells lmc	by T. Valko	5	425
difference between the 2 bda019	by Michael M	1	467
"No RETURN() or HALT() function found on macro sheet." Will	by Will	2	1,957
Macro to hide the row if both columns E & F are blank in that row. PCakes	by PCakes	2	681
How do I only display highlighted fields in excel View only highlighted fields	by Gord Dibben	2	3,567
Power and Sum John Watt	by Bernard Liengme	6	717
Help with VLOOKUP or other matching function mpenkala	by mpenkala	4	466
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	567
Formula Error Question Office Princess	by Bernard Liengme	1	375
Setting up slide scale for prices Ted Metro	by Niek Otten	2	710
Automatically prefix cell entry rossinvrland	by rossinvrland	5	1,172
Continue typing in a cell after leaving the workbook. Andy	by Andy	4	2,066
Add number from a cell that contains a specific character Carole	by Carole	0	671
averaging range across sheets after transforming text to value Keith	by Keith	3	496
need 4 conditions for conditional formatting and there are only 3 pm	by Teethless mama	2	519
Using the replace function less caldog	by caldog	0	364
Filter data & sum or avg the results? bryan stewart	by Gord Dibben	3	579
Change Exel headers text. ? KalliMan	by Gord Dibben	2	458
VLOOKUP() Question mastermind	by mastermind	2	400
deleting worksheets from workbook when option not available Rita318	by Gord Dibben	3	498
using sum function,can I avoid calculating hidden rows UB	by Peo Sjoblom	7	1,285
Conversion of numbers Arne Hegefors	by Harlan Grove	8	537
File-search results in worksheet hmm	by Gary''s Student	8	645
Template Wizard with Data Tracking Will	by Gord Dibben	5	541
COUNTIF Help cesar	by cesar	5	470
COUNTIF across multiple workbooks JDB	by Bob Phillips	8	5,924
Code to include a one-up suffix to a field value Doctorjones_md	by Bob Phillips	4	516
vlookup with conditional formatting pm	by Peo Sjoblom	1	761
Logic Formula Truc Lopez	by RagDyeR	6	482
Calculating Calls closed in Given periods phocused	by phocused	2	509
Search multiple sheets and return largest number found mpenkala	by mpenkala	2	1,057
COUNTIF Function mpenkala	by mpenkala	2	361
count in several colums lee	by RagDyeR	10	739
Sumproduct not returning expected results Dos Equis	by Sandy Mann	8	641
Nested If help JoeA2006	by Bob Phillips	2	487
How do I reference a cell as PART of a vlookup "Table_Array" locat -Rocket	by -Rocket	2	810
Merge content of cells Arne Hegefors	by Dave Peterson	2	527
Importing signed over-punch text into Excel ALEX	by ALEX	2	2,640
Logic Formulas BWatson10	by Lori	3	567
How do I sort pivot table data outside a pivot table Michael	by Bernie Deitrick	1	4,289
Can I 'auto update' my spreadsheet ? Rich	by CLR	5	591
NPV and IRR Meredith	by Meredith	1	483
indirect function referenceing changing file name Spike	by Spike	3	1,290
Converting TEXT to DATE GFH	by Lori	3	679
Excel: Syntax to change cell color based on color of another cell davew18	by CLR	1	3,421
Excel Worksheets within a Workbook Lisa	by David Biddulph	3	562
lookup returning incorrect cell values stuartjk	by stuartjk	8	905
Format Cells to show different values bony_tony	by Roger Govier	2	648
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,752
More then 7 nested If functions. Sarah	by T. Valko	2	832
Hide cell values based on a condition in another cell Cat	by Max	1	1,874
Sumproduct problem [email protected]	by T. Valko	1	443
re my new problem HANYANA via OfficeKB.com	by Max	6	423
insert page number in work sheet Nandkish	by Nandkish	2	1,217
SUMPRODUCT Woodi2	by JMB	1	437
Counting Unique entry from Concatenated list Rajat	by Rajat	28	1,947
Amortization 30/365 HUNGRY	by [email protected]	1	3,550
black and white display jaidencam	by Gord Dibben	1	1,167
please simplify mysearch formula. been drilbled to 2007	by T. Valko	3	458
date related question??? _Bigred	by Franz Verga	1	669
new number after printing Kelzina	by Kelzina	0	346
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,062
How can up type text upsidedown in a cell please not 90 degrees Justin	by Dave Peterson	4	5,326
embedding "ISERROR" function into an "IF" statement [email protected]	by Bob Phillips	8	1,628