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,146
Calculation Using Time And Dates EmmaJade	by EmmaJade	0	456
Concatenate: Multi-Line Cell with 2 single line cells BEEJAY	by BEEJAY	0	1,248
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,616
Index function with quotes and '&' sign in reference [email protected]	by [email protected]	1	478
Checking a second lookup condition Obwan	by Obwan	4	524
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	481
Match and Index function Gary Reger	by Gary Reger	2	618
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	458
Can I fix a format so it doesn't change when I drag or copy/paste Blah-blah	by Gord Dibben	1	574
Clean matrix from 0 Arne Hegefors	by Gord Dibben	2	432
Matching a name to a specified monetary amount Sarah S	by Toppers	1	420
copy a formula down the colum and advance it by row only ShoDan	by ShoDan	4	585
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	766
nested "If statement" using text RonB	by bj	2	3,150
scan a series of numbers and when it turns postive give me the yea Craig	by Teethless mama	2	672
Formula True False help Joel	by Joel	0	420
Multiple evaluations with an "OR". ron	by Dave F	2	351
go to a specific letter in a list Petya	by Roger Govier	4	466
Conditional Sum Wizard Limited Conditions ron	by ron	0	450
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	318
How do I use the If function to tell me if a cell has a negative Teethless mama	by Teethless mama	0	347
go to a specific letter in a list Toppers	by Toppers	0	426
go to a specific letter in a list Petya	by Petya	0	392
Selection in 1st list box populates 2nd list box [email protected]	by Ron Coderre	4	616
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	944
Date Change Macro Eschroeter	by Dave Peterson	2	438
Ranking a list HK[_2_]	by HK[_2_]	4	476
Monthly Summary [email protected]	by [email protected]	2	581
mail merge Susan	by macropod	1	357
I'm using BAHTTEXT in US English? Khalilurrehman Abola	by Niek Otten	2	2,071
Please solve this problem. ramulu	by Martin Fishlock	1	486
more than 250 word in cell with fuction Jacky Hope	by Jacky Hope	0	373
how to re-group the cells from vertical to horizontal Landa	by Teethless mama	1	1,763
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	680
Nested 'IF', 'LOOKUP', 'AND' or 'INDEX', 'MATCH' JT	by JT	2	1,845
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,094
disable Total and/or Sub total for a single column Voyager	by Roger Govier	3	654
Testing for a consistent value counting blanks [email protected]	by Bernie Deitrick	1	428
Hyperlink to link to text, not just a cell Ben	by Dave Peterson	1	735
Count Unique Numbers Averitt Engineer	by Harlan Grove	6	607
min function on non consecutive rows bikemrh	by bikemrh	4	588
syntax correction Richard	by Tom Ogilvy	4	499
vlookup problem Jeanette	by Jeanette	4	429
VLOOKUP or HLOOKUP function question MMangen	by T. Valko	1	403
EXCEL M.GONZALEZ	by M.GONZALEZ[_2_]	2	345
Setting password on worksheet in Excel 2000 Bill[_2_]	by JLatham	1	498
Lost text & fill colors from worksheet Basher Bates	by Gord Dibben	1	963
Help: Vlookup, Index, Match, or Sumproduct? Phrank	by T. Valko	3	868
lookup Jordan	by vezerid	3	435
Summing Subtotals Exceller	by Exceller	4	585
Data List - Total Row - Only displays "Total" Debbie Long	by Debbie Long	0	756
Look up a value in a table using both exact and approx matching Elbowes	by Elbowes	8	687
FV with inconsistant cash flow [email protected]	by [email protected]	2	470
Gone Blank on formula - please help Nick Wakeham	by Nick Wakeham	2	412
SubTotal for Sum function returning zeros ForestFeeder	by ForestFeeder	2	1,309
Number vs Text felipe_mfds	by Don Guillett	5	374
Can you calculate a cell name? and How to return a value from an adjacent cell? HK[_2_]	by vezerid	4	514