+ Post New Thread
Page 201 of 5614 FirstFirst ... 201 ...
Threads 10001 to 10050 of 280683

Forum: Excel Formulas & Functions

Post and discuss Excel Formulas & functions.

  1. Thumbs up Sticky Thread Sticky: Excel Useful Links (see last post for new additions)

    Started by gopi_excel‎, 12-22-2006 08:14 PM
    • 19
    • 156,904
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. [SOLVED] Dynamic List of data between a start text value and an end text value

    Started by amartin575‎, 02-10-2023 09:17 PM
    between column values, dynamic list, end point, filter based on list, start point 5 Attachment(s)
    • 14
    • 489
    Glenn Kennedy
    02-17-2023, 08:36 PM Go to last post

  2. [SOLVED] MODE Function on a specific Match

    Started by amartin575‎, 05-01-2013 03:27 PM
    match, mode, mode function as a range 1 Attachment(s)
    • 8
    • 827
    Tony Valko
    05-02-2013, 03:37 PM Go to last post

  3. Sum Multiple Rows with an Index/Match

    Started by amartin575‎, 07-19-2013 11:07 AM
    index, index and match, match, sumifs
    • 1
    • 3,498
    martindwilson
    07-20-2013, 06:13 AM Go to last post

  4. Formula to shift cell references a certain number of columns not working

    Started by amartin575‎, 03-15-2013 01:35 PM
    1 Attachment(s)
    • 0
    • 1,605
    amartin575
    03-15-2013, 01:35 PM Go to last post

  5. [SOLVED] Subtracting MONTH Function from another MONTH Function not working for Fiscal dates

    Started by amartin575‎, 08-16-2013 10:25 AM
    fiscal year, month, subtracting dates
    • 2
    • 758
    amartin575
    08-16-2013, 10:52 AM Go to last post

  6. [SOLVED] Not Equal To Multiple Criteria

    Started by amartin575‎, 10-23-2013 04:18 PM
    multiple criteria, multiple matches, not equal, not equal to
    • 4
    • 1,861
    Jonmo1
    10-23-2013, 04:35 PM Go to last post

  7. [SOLVED] Rank countif with index match is not giving top results

    Started by amartin575‎, 04-01-2014 09:04 PM
    countif, index & match, large function, rank formula 1 Attachment(s)
    • 3
    • 1,000
    azumi
    04-01-2014, 10:17 PM Go to last post

  8. Imbedding exclusion criteria into Large function

    Started by amartin575‎, 03-03-2015 02:46 PM
    if statement, imbed, large function, rank 1 Attachment(s)
    • 8
    • 1,006
    FDibbins
    03-03-2015, 03:53 PM Go to last post

  9. Stacking Data in specific order

    Started by amartin575‎, 09-22-2022 01:07 PM
    order, order by column, stack data 4 Attachment(s)
    • 3
    • 397
    amartin575
    09-27-2022, 10:26 AM Go to last post

  10. Large formula looking at a pivot table that updates as you select from data validation

    Started by amartin575‎, 04-19-2019 01:52 PM
    array, data validation, large, pivot table
    • 1
    • 559
    XLent
    04-23-2019, 06:51 AM Go to last post

  11. Index Match Search Not Using Exact Match

    Started by amartin575‎, 01-29-2018 04:54 PM
    1 Attachment(s)
    • 15
    • 915
    Jonmo1
    01-29-2018, 06:08 PM Go to last post

  12. [SOLVED] Indirect pulling wrong info

    Started by amartin575‎, 06-22-2016 05:24 PM
    data validation, indirect 1 Attachment(s)
    • 5
    • 1,672
    TMS
    06-23-2016, 04:47 PM Go to last post

  13. Concatenate cells based on criteria/threshold

    Started by amartin575‎, 12-01-2014 02:48 PM
    comment cells, concatenate, dynamic column reference, variance analysis, variances 1 Attachment(s)
    • 1
    • 1,257
    Brendan_Floyde
    01-19-2015, 12:26 PM Go to last post

  14. [SOLVED] VLOOKUP given #N/A result

    Started by amartinez988‎, 01-07-2016 12:08 PM
    • 6
    • 687
    Pete_UK
    01-07-2016, 02:54 PM Go to last post

  15. If statement (difficult)

    Started by amartino44‎, 10-09-2013 07:47 PM
    3 Attachment(s)
    • 17
    • 1,350
    Pete_UK
    10-16-2013, 04:52 AM Go to last post

  16. ratio formulas for last twelve months

    Started by amartino44‎, 11-19-2013 01:48 PM
    1 Attachment(s)
    • 1
    • 538
    daffodil11
    11-19-2013, 02:37 PM Go to last post

  17. Lookup with an indirect

    Started by amartino44‎, 12-05-2013 08:57 PM
    2 Attachment(s)
    • 3
    • 757
    amartino44
    12-06-2013, 01:01 PM Go to last post

  18. staggered formulas

    Started by amartino44‎, 12-12-2013 05:42 PM
    1 Attachment(s)
    • 5
    • 2,040
    amartino44
    12-13-2013, 12:44 PM Go to last post

  19. Named Range that changes columns

    Started by amartino44‎, 07-12-2013 02:38 PM
    • 8
    • 536
    amartino44
    08-19-2013, 12:50 PM Go to last post

  20. vlookup with spaces

    Started by amartino44‎, 07-10-2013 01:25 PM
    • 10
    • 3,765
    humdingaling
    07-10-2013, 07:36 PM Go to last post

  21. [SOLVED] vlookup changing columns

    Started by amartino44‎, 06-12-2013 06:24 PM
    2 Attachment(s)
    • 12
    • 1,753
    JBeaucaire
    06-12-2013, 10:23 PM Go to last post

  22. difficult lookup problem

    Started by amartino44‎, 06-11-2013 03:02 PM
    3 Attachment(s)
    • 9
    • 764
    JBeaucaire
    06-17-2013, 10:25 AM Go to last post

  23. getting second to last values in a lookup with multiple values

    Started by amartino44‎, 06-11-2013 05:19 PM
    1 Attachment(s)
    • 44
    • 2,287
    JBeaucaire
    06-17-2013, 05:10 PM Go to last post

  24. Vlookup (or other formulas) to use two variables

    Started by amartino44‎, 06-11-2013 12:00 PM
    • 5
    • 477
    Sam Capricci
    06-12-2013, 10:24 AM Go to last post

  25. problems with Vlookup

    Started by amartino44‎, 06-10-2013 07:33 PM
    1 Attachment(s)
    • 3
    • 482
    amartino44
    06-11-2013, 11:42 AM Go to last post

  26. vlookup with two criteria

    Started by amartino44‎, 06-10-2013 07:42 PM
    1 Attachment(s)
    • 2
    • 518
    amartino44
    06-11-2013, 11:39 AM Go to last post

  27. sumproduct with autofilter

    Started by amartino44‎, 02-25-2013 08:10 PM
    • 1
    • 662
    daddylonglegs
    02-25-2013, 08:33 PM Go to last post

  28. Help with Offset/Match Formula

    Started by amartino44‎, 01-24-2013 01:49 PM
    1 Attachment(s)
    • 3
    • 573
    FDibbins
    01-24-2013, 07:15 PM Go to last post

  29. Financial Statement Lookups

    Started by amartino44‎, 12-12-2012 07:40 PM
    • 1
    • 409
    amartino44
    12-12-2012, 08:05 PM Go to last post

  30. sumifs not working

    Started by amartino44‎, 01-04-2013 01:43 PM
    2 Attachment(s)
    • 6
    • 1,026
    jeffreybrown
    01-07-2013, 08:31 PM Go to last post

  31. Dynamic Ranges vs. Formulas that exclude blanks?

    Started by amartino44‎, 01-15-2013 01:37 PM
    • 1
    • 1,050
    Palmetto
    01-15-2013, 02:04 PM Go to last post

  32. Problem with sums--how to sum only partial data?

    Started by amartino44‎, 01-22-2013 01:58 PM
    • 1
    • 556
    Pepe Le Mokko
    01-22-2013, 03:52 PM Go to last post

  33. hard array formula based on dates

    Started by amartino44‎, 01-23-2013 09:04 PM
    1 Attachment(s)
    • 3
    • 544
    rylo
    01-24-2013, 05:52 PM Go to last post

  34. summing but ignoring #value errors

    Started by amartino44‎, 02-06-2013 02:39 PM
    • 5
    • 14,162
    amartino44
    02-12-2013, 03:49 PM Go to last post

  35. How to use a cell reference in a text statement

    Started by amartino44‎, 02-08-2013 07:33 PM
    • 2
    • 376
    TMS
    02-12-2013, 04:16 PM Go to last post

  36. if then statement for finance

    Started by amartino44‎, 02-15-2013 05:19 AM
    • 3
    • 504
    Ace_XL
    02-22-2013, 02:30 PM Go to last post

  37. Use of parentheses in formulas

    Started by amartino44‎, 02-21-2013 07:17 PM
    • 4
    • 1,371
    shg
    02-21-2013, 08:15 PM Go to last post

  38. Difficulties with sumproduct/choose formula

    Started by amartino44‎, 02-22-2013 03:44 PM
    1 Attachment(s)
    • 3
    • 1,076
    amartino44
    02-22-2013, 06:41 PM Go to last post

  39. Problem with index and offset

    Started by amartino44‎, 06-07-2013 07:30 PM
    • 2
    • 626
    FDibbins
    06-07-2013, 07:49 PM Go to last post

  40. make a sumif formula dynamic

    Started by amartino44‎, 03-05-2013 07:15 PM
    2 Attachment(s)
    • 6
    • 764
    Tank997
    03-08-2013, 11:19 AM Go to last post

  41. vlookup and isblank formula to return nothing

    Started by amartino44‎, 03-10-2013 06:56 PM
    • 1
    • 661
    martindwilson
    03-10-2013, 06:59 PM Go to last post

  42. Unbelievably difficult SUMPRODUCT and CHOOSE Formula that is coming up with an error

    Started by amartino44‎, 03-13-2013 06:08 PM
    1 Attachment(s)
    • 6
    • 826
    amartino44
    03-19-2013, 11:41 AM Go to last post

  43. What is the difference between Vlookup and Index

    Started by amartino44‎, 03-28-2013 12:18 PM
    • 3
    • 5,770
    ChemistB
    03-28-2013, 12:42 PM Go to last post

  44. Subtracting from a date

    Started by amartino44‎, 04-24-2013 05:06 PM
    • 2
    • 393
    Melvinrobb
    04-24-2013, 05:17 PM Go to last post

  45. creating and naming a new worksheet

    Started by amartino44‎, 05-24-2013 05:31 PM
    • 1
    • 620
    judgeh59
    05-24-2013, 05:35 PM Go to last post

  46. finding the root of circular reference issues

    Started by amartino44‎, 05-16-2013 12:51 PM
    • 2
    • 1,962
    amartino44
    05-17-2013, 02:36 PM Go to last post

  47. Ambiguous name detected...this book is weak

    Started by amartino44‎, 05-16-2013 06:55 PM
    • 1
    • 593
    Norie
    05-16-2013, 07:02 PM Go to last post

  48. Deciphering a user defined function

    Started by amartino44‎, 05-24-2013 02:38 PM
    • 4
    • 597
    shg
    05-24-2013, 04:54 PM Go to last post

  49. Moved: What is a Dim?

    Started by amartino44‎, 05-24-2013 05:46 PM
    •  
    •  

  50. Lookups from different excel reports

    Started by amartino44‎, 06-07-2013 05:10 PM
    • 3
    • 440
    FDibbins
    06-07-2013, 07:45 PM Go to last post
+ Post New Thread
Page 201 of 5614 FirstFirst ... 201 ...

Forum Information and Options

Users Browsing this Forum

There are currently 69 users browsing this forum. (4 members & 65 guests)

  1. CARACALLA,
  2. etaf,
  3. HansDouwe,
  4. TMS

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1