Excel Worksheet Functions - Page 597

Thread / Thread Starter	Last Post	Replies	Views
Matrix Math using LOOKUP inside Array {} Function ExcelMonkey	by Ron Coderre	4	722
Loan Calculations Nolechik	by joeu2004	4	1,147
Calculation Using Time And Dates EmmaJade	by EmmaJade	0	458
Concatenate: Multi-Line Cell with 2 single line cells BEEJAY	by BEEJAY	0	1,254
Lookup? pearce	by pearce	4	489
Not all values showing BethB	by Gord Dibben	5	612
How can you separate a series of numbers into jenks? Shelly	by Gord Dibben	9	1,627
Index function with quotes and '&' sign in reference [email protected]	by [email protected]	1	478
Checking a second lookup condition Obwan	by Obwan	4	526
Calendar button McM	by McM	2	386
formula Irven griffin	by Toppers	5	434
Copying and auto updating a formula Blade370	by [email protected]	1	483
Match and Index function Gary Reger	by Gary Reger	2	620
formula to display first and last items of a list [email protected]	by T. Valko	2	842
count unique values, if ... Averitt Engineer[_2_]	by Averitt Engineer[_2_]	2	460
Can I fix a format so it doesn't change when I drag or copy/paste Blah-blah	by Gord Dibben	1	575
Clean matrix from 0 Arne Hegefors	by Gord Dibben	2	432
Matching a name to a specified monetary amount Sarah S	by Toppers	1	423
copy a formula down the colum and advance it by row only ShoDan	by ShoDan	4	586
Matching a name to a specified monetary amount Dave F	by Dave F	0	452
excel M.GONZALEZ[_2_]	by Dave F	2	376
Create list of Named Ranges Jim Tibbetts	by Duke Carey	4	647
Excel 2007 Filter in Column Steve300	by Debra Dalgleish	1	771
nested "If statement" using text RonB	by bj	2	3,152
scan a series of numbers and when it turns postive give me the yea Craig	by Teethless mama	2	674
Formula True False help Joel	by Joel	0	421
Multiple evaluations with an "OR". ron	by Dave F	2	352
go to a specific letter in a list Petya	by Roger Govier	4	469
Conditional Sum Wizard Limited Conditions ron	by ron	0	452
vlookup S Hendry	by Joel	3	376
exponents in excel PÃ©	by PÃ©	0	564
How do I use the If function to tell me if a cell has a negative pcmurph	by pcmurph	0	325
How do I use the If function to tell me if a cell has a negative Joel	by Joel	0	319
How do I use the If function to tell me if a cell has a negative Teethless mama	by Teethless mama	0	349
go to a specific letter in a list Toppers	by Toppers	0	438
go to a specific letter in a list Petya	by Petya	0	394
Selection in 1st list box populates 2nd list box [email protected]	by Ron Coderre	4	617
Help determining a best "lineup" Sarah	by Max	4	430
more than 250 word in cell with fuction Jacky Hope	by Max	2	359
exponents in excel Joel	by Joel	0	911
Change number format with IF statement Teethless mama	by Teethless mama	0	945
Date Change Macro Eschroeter	by Dave Peterson	2	442
Ranking a list HK[_2_]	by HK[_2_]	4	478
Monthly Summary [email protected]	by [email protected]	2	584
mail merge Susan	by macropod	1	358
I'm using BAHTTEXT in US English? Khalilurrehman Abola	by Niek Otten	2	2,073
Please solve this problem. ramulu	by Martin Fishlock	1	488
more than 250 word in cell with fuction Jacky Hope	by Jacky Hope	0	375
how to re-group the cells from vertical to horizontal Landa	by Teethless mama	1	1,765
count pivot tables Pivot Table doesn't like text	by Debra Dalgleish	1	545
how do I link pivot table data into a separate document? Hendy	by Debra Dalgleish	1	681
Nested 'IF', 'LOOKUP', 'AND' or 'INDEX', 'MATCH' JT	by JT	2	1,846
find a character location in a string starting from the right funtipoom	by daddylonglegs	2	3,949
Conditional Formatting of Merged Cells Fishman4	by Fishman4	7	1,095
disable Total and/or Sub total for a single column Voyager	by Roger Govier	3	656
Testing for a consistent value counting blanks [email protected]	by Bernie Deitrick	1	429
Hyperlink to link to text, not just a cell Ben	by Dave Peterson	1	736
Count Unique Numbers Averitt Engineer	by Harlan Grove	6	610
min function on non consecutive rows bikemrh	by bikemrh	4	588
syntax correction Richard	by Tom Ogilvy	4	501
vlookup problem Jeanette	by Jeanette	4	434
VLOOKUP or HLOOKUP function question MMangen	by T. Valko	1	405
EXCEL M.GONZALEZ	by M.GONZALEZ[_2_]	2	345
Setting password on worksheet in Excel 2000 Bill[_2_]	by JLatham	1	499
Lost text & fill colors from worksheet Basher Bates	by Gord Dibben	1	987
Help: Vlookup, Index, Match, or Sumproduct? Phrank	by T. Valko	3	869
lookup Jordan	by vezerid	3	436
Summing Subtotals Exceller	by Exceller	4	585
Data List - Total Row - Only displays "Total" Debbie Long	by Debbie Long	0	758
Look up a value in a table using both exact and approx matching Elbowes	by Elbowes	8	688
FV with inconsistant cash flow [email protected]	by [email protected]	2	484
Gone Blank on formula - please help Nick Wakeham	by Nick Wakeham	2	412
SubTotal for Sum function returning zeros ForestFeeder	by ForestFeeder	2	1,310
Number vs Text felipe_mfds	by Don Guillett	5	376
Can you calculate a cell name? and How to return a value from an adjacent cell? HK[_2_]	by vezerid	4	515