Excel Worksheet Functions - Page 597

Thread / Thread Starter	Last Post	Replies	Views
Matrix Math using LOOKUP inside Array {} Function ExcelMonkey	by Ron Coderre	4	704
Loan Calculations Nolechik	by joeu2004	4	1,139
Calculation Using Time And Dates EmmaJade	by EmmaJade	0	445
Concatenate: Multi-Line Cell with 2 single line cells BEEJAY	by BEEJAY	0	1,228
Lookup? pearce	by pearce	4	483
Not all values showing BethB	by Gord Dibben	5	603
How can you separate a series of numbers into jenks? Shelly	by Gord Dibben	9	1,599
Index function with quotes and '&' sign in reference [email protected]	by [email protected]	1	465
Checking a second lookup condition Obwan	by Obwan	4	509
Calendar button McM	by McM	2	379
formula Irven griffin	by Toppers	5	428
Copying and auto updating a formula Blade370	by [email protected]	1	471
Match and Index function Gary Reger	by Gary Reger	2	610
formula to display first and last items of a list [email protected]	by T. Valko	2	830
count unique values, if ... Averitt Engineer[_2_]	by Averitt Engineer[_2_]	2	448
Can I fix a format so it doesn't change when I drag or copy/paste Blah-blah	by Gord Dibben	1	560
Clean matrix from 0 Arne Hegefors	by Gord Dibben	2	419
Matching a name to a specified monetary amount Sarah S	by Toppers	1	408
copy a formula down the colum and advance it by row only ShoDan	by ShoDan	4	563
Matching a name to a specified monetary amount Dave F	by Dave F	0	439
excel M.GONZALEZ[_2_]	by Dave F	2	364
Create list of Named Ranges Jim Tibbetts	by Duke Carey	4	632
Excel 2007 Filter in Column Steve300	by Debra Dalgleish	1	717
nested "If statement" using text RonB	by bj	2	3,021
scan a series of numbers and when it turns postive give me the yea Craig	by Teethless mama	2	631
Formula True False help Joel	by Joel	0	407
Multiple evaluations with an "OR". ron	by Dave F	2	344
go to a specific letter in a list Petya	by Roger Govier	4	451
Conditional Sum Wizard Limited Conditions ron	by ron	0	443
vlookup S Hendry	by Joel	3	366
exponents in excel PÃ©	by PÃ©	0	555
How do I use the If function to tell me if a cell has a negative pcmurph	by pcmurph	0	314
How do I use the If function to tell me if a cell has a negative Joel	by Joel	0	315
How do I use the If function to tell me if a cell has a negative Teethless mama	by Teethless mama	0	332
go to a specific letter in a list Toppers	by Toppers	0	404
go to a specific letter in a list Petya	by Petya	0	375
Selection in 1st list box populates 2nd list box [email protected]	by Ron Coderre	4	608
Help determining a best "lineup" Sarah	by Max	4	421
more than 250 word in cell with fuction Jacky Hope	by Max	2	351
exponents in excel Joel	by Joel	0	900
Change number format with IF statement Teethless mama	by Teethless mama	0	934
Date Change Macro Eschroeter	by Dave Peterson	2	429
Ranking a list HK[_2_]	by HK[_2_]	4	427
Monthly Summary [email protected]	by [email protected]	2	572
mail merge Susan	by macropod	1	352
I'm using BAHTTEXT in US English? Khalilurrehman Abola	by Niek Otten	2	2,057
Please solve this problem. ramulu	by Martin Fishlock	1	468
more than 250 word in cell with fuction Jacky Hope	by Jacky Hope	0	361
how to re-group the cells from vertical to horizontal Landa	by Teethless mama	1	1,749
count pivot tables Pivot Table doesn't like text	by Debra Dalgleish	1	527
how do I link pivot table data into a separate document? Hendy	by Debra Dalgleish	1	642
Nested 'IF', 'LOOKUP', 'AND' or 'INDEX', 'MATCH' JT	by JT	2	1,826
find a character location in a string starting from the right funtipoom	by daddylonglegs	2	3,910
Conditional Formatting of Merged Cells Fishman4	by Fishman4	7	1,081
disable Total and/or Sub total for a single column Voyager	by Roger Govier	3	633
Testing for a consistent value counting blanks [email protected]	by Bernie Deitrick	1	404
Hyperlink to link to text, not just a cell Ben	by Dave Peterson	1	729
Count Unique Numbers Averitt Engineer	by Harlan Grove	6	589
min function on non consecutive rows bikemrh	by bikemrh	4	579
syntax correction Richard	by Tom Ogilvy	4	475
vlookup problem Jeanette	by Jeanette	4	416
VLOOKUP or HLOOKUP function question MMangen	by T. Valko	1	384
EXCEL M.GONZALEZ	by M.GONZALEZ[_2_]	2	340
Setting password on worksheet in Excel 2000 Bill[_2_]	by JLatham	1	489
Lost text & fill colors from worksheet Basher Bates	by Gord Dibben	1	935
Help: Vlookup, Index, Match, or Sumproduct? Phrank	by T. Valko	3	850
lookup Jordan	by vezerid	3	393
Summing Subtotals Exceller	by Exceller	4	542
Data List - Total Row - Only displays "Total" Debbie Long	by Debbie Long	0	743
Look up a value in a table using both exact and approx matching Elbowes	by Elbowes	8	662
FV with inconsistant cash flow [email protected]	by [email protected]	2	451
Gone Blank on formula - please help Nick Wakeham	by Nick Wakeham	2	404
SubTotal for Sum function returning zeros ForestFeeder	by ForestFeeder	2	1,302
Number vs Text felipe_mfds	by Don Guillett	5	362
Can you calculate a cell name? and How to return a value from an adjacent cell? HK[_2_]	by vezerid	4	496