+ Post New Thread
Page 503 of 5614 FirstFirst ... 503 ...
Threads 25101 to 25150 of 280681

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] Sum employees based 3 variables

    Started by BennyH‎, 11-04-2013 10:09 PM
    1 Attachment(s)
    • 2
    • 455
    BennyH
    11-04-2013, 10:58 PM Go to last post

  2. [SOLVED] averageif returning #div/0! error now

    Started by BennyH‎, 03-20-2013 12:54 AM
    1 Attachment(s)
    • 3
    • 567
    BennyH
    03-20-2013, 01:26 AM Go to last post

  3. Cool [SOLVED] shade rows based on multiple criteria

    Started by BennyH‎, 03-19-2013 07:30 PM
    2 Attachment(s)
    • 5
    • 454
    dredwolf
    03-19-2013, 09:08 PM Go to last post

  4. Blending IF Statment

    Started by bennyhay‎, 10-05-2012 04:30 AM
    • 2
    • 418
    bennyhay
    10-05-2012, 04:38 AM Go to last post

  5. Retrieve highest 3 scpring players

    Started by BennyHill‎, 04-24-2013 10:20 AM
    retrieving data 3 Attachment(s)
    • 4
    • 624
    Tony Valko
    04-28-2013, 10:07 AM Go to last post

  6. Dates and date range and return a value

    Started by bennyis2010‎, 09-04-2016 08:35 PM
    date, date range, formula 1 Attachment(s)
    • 2
    • 672
    David A Coop
    09-05-2016, 03:33 AM Go to last post

  7. Dependent dropdown list problem

    Started by bennyistanto‎, 10-06-2020 07:29 AM
    dependant drop down list 3 Attachment(s)
    • 5
    • 383
    Squeaky
    10-07-2020, 08:18 AM Go to last post

  8. [SOLVED] Find neighbor cell 5x5

    Started by bennyistanto‎, 08-11-2020 12:33 PM
    6 Attachment(s)
    • 8
    • 305
    BMV
    08-12-2020, 05:08 AM Go to last post

  9. [SOLVED] Number of days since a dry day

    Started by bennyistanto‎, 06-10-2016 04:09 AM
    2 Attachment(s)
    • 3
    • 708
    Aardigspook
    06-11-2016, 09:14 AM Go to last post

  10. [SOLVED] How to get max value and information about date of the max value

    Started by bennyistanto‎, 07-30-2018 12:13 AM
    1 Attachment(s)
    • 2
    • 329
    bennyistanto
    07-30-2018, 12:24 AM Go to last post

  11. [SOLVED] Maximum length of dry spell

    Started by bennyistanto‎, 11-09-2012 03:22 AM
    2 Attachment(s)
    • 20
    • 5,192
    KelechiKSU
    08-02-2022, 03:07 PM Go to last post

  12. [SOLVED] Maximum cumulative value for the consecutive 3 days of data in 1 year period

    Started by bennyistanto‎, 01-23-2017 05:58 AM
    1 Attachment(s)
    • 5
    • 1,524
    Tony Valko
    01-26-2017, 08:43 AM Go to last post

  13. copying and pasting excel formulae

    Started by bennyrub‎, 05-06-2006 12:55 PM
    • 2
    • 526
    bennyrub
    05-06-2006, 02:40 PM Go to last post

  14. If X, then Y

    Started by bennythedog‎, 03-24-2016 07:30 PM
    2 Attachment(s)
    • 6
    • 847
    bennythedog
    04-04-2016, 08:35 PM Go to last post

  15. COUNTIFS Help

    Started by bennyx_o‎, 01-06-2018 11:33 AM
    3 Attachment(s)
    • 4
    • 376
    Glenn Kennedy
    01-06-2018, 03:02 PM Go to last post

  16. Calculate time Consuming during running Excel built in Function

    Started by bennyys‎, 06-18-2017 01:38 AM
    • 2
    • 380
    bennyys
    06-18-2017, 07:45 AM Go to last post

  17. [SOLVED] Countifs referencing data from another worksheet in the same workbook

    Started by benny_gc‎, 03-23-2017 12:21 AM
    1 Attachment(s)
    • 7
    • 872
    JeteMc
    03-26-2017, 06:14 PM Go to last post

  18. [SOLVED] Vlookup (possibly) help

    Started by benog‎, 11-19-2020 04:13 PM
    4 Attachment(s)
    • 9
    • 424
    benog
    11-23-2020, 07:23 AM Go to last post

  19. Excel VLookUp on another worksheet keeps last known value even if the sheet is deleted

    Started by benoitly‎, 05-02-2013 10:01 PM
    • 3
    • 1,117
    FDibbins
    05-03-2013, 03:59 PM Go to last post

  20. Excel Workbook to Double Check Pay (includes premiums and overtime)

    Started by benoitsm‎, 03-12-2020 01:22 PM
    • 1
    • 263
    FlameRetired
    03-12-2020, 11:43 PM Go to last post

  21. COUNTIFS date from Column A > date in Column B

    Started by benoit_brindamour‎, 10-27-2011 12:16 PM
    • 2
    • 831
    benoit_brindamour
    10-31-2011, 11:04 AM Go to last post

  22. [SOLVED] Converting a date to a text output

    Started by Benoj‎, 02-27-2013 06:17 AM
    1 Attachment(s)
    • 2
    • 425
    Benoj
    02-27-2013, 06:29 AM Go to last post

  23. [SOLVED] Date workings

    Started by benoj2005‎, 08-29-2018 10:41 AM
    5 Attachment(s)
    • 15
    • 590
    benoj2005
    03-25-2019, 10:45 AM Go to last post

  24. Aging values by x number of months

    Started by benoj2005‎, 03-04-2024 11:52 AM
    3 Attachment(s)
    • 6
    • 250
    benoj2005
    03-08-2024, 04:37 AM Go to last post

  25. [SOLVED] Suming dynamic array off column numbers based of criteria

    Started by benoj2005‎, 11-22-2022 04:48 AM
    4 Attachment(s)
    • 4
    • 246
    benoj2005
    11-22-2022, 08:24 AM Go to last post

  26. [SOLVED] Formula to sum cells with multiple values in each cell

    Started by benoj2005‎, 07-29-2018 07:59 AM
    • 6
    • 997
    benoj2005
    07-29-2018, 11:52 AM Go to last post

  27. [SOLVED] Depreciation & re-investment formulas

    Started by benoj2005‎, 11-17-2022 10:50 AM
    4 Attachment(s)
    • 9
    • 404
    HansDouwe
    11-21-2022, 05:26 AM Go to last post

  28. [SOLVED] Sumproduct with multiple arrays of differing column widths

    Started by benoj2005‎, 06-30-2021 04:58 AM
    1 Attachment(s)
    • 9
    • 317
    benoj2005
    06-30-2021, 07:30 AM Go to last post

  29. [SOLVED] Return text based on matching two columns criteria

    Started by benoj2005‎, 09-05-2018 07:01 AM
    1 Attachment(s)
    • 2
    • 330
    benoj2005
    09-05-2018, 07:39 AM Go to last post

  30. [SOLVED] Formula - Find if any part of string matches an array of words

    Started by benoj2005‎, 11-28-2018 07:42 AM
    1 Attachment(s)
    • 2
    • 261
    benoj2005
    11-28-2018, 07:51 AM Go to last post

  31. [SOLVED] Summing up values based off criteria in variable columns

    Started by benoj2005‎, 06-29-2021 10:15 AM
    3 Attachment(s)
    • 9
    • 432
    Richard Buttrey
    06-30-2021, 06:10 AM Go to last post

  32. [SOLVED] Summarising annual data into individual months based off number of employees

    Started by benoj2005‎, 06-16-2021 09:12 AM
    3 Attachment(s)
    • 9
    • 303
    Bo_Ry
    06-17-2021, 03:00 AM Go to last post

  33. [SOLVED] Suming values based of multiple column categories and comparing month to month

    Started by benoj2005‎, 11-25-2021 11:51 AM
    6 Attachment(s)
    • 17
    • 713
    Bo_Ry
    12-24-2021, 03:48 AM Go to last post

  34. [SOLVED] text formula

    Started by benoj2005‎, 10-22-2013 07:44 AM
    1 Attachment(s)
    • 3
    • 386
    benoj2005
    10-22-2013, 07:50 AM Go to last post

  35. Removing a helper column to join two fields for a lookup

    Started by benoj2005‎, 08-02-2012 07:51 AM
    3 Attachment(s)
    • 7
    • 1,031
    Fotis1991
    08-02-2012, 11:15 AM Go to last post

  36. Returning unit price based on Qty from a customer price book with price qty breaks

    Started by benoj2005‎, 08-10-2012 08:11 AM
    2 Attachment(s)
    • 4
    • 1,101
    benoj2005
    08-15-2012, 09:49 AM Go to last post

  37. [SOLVED] Converting times between minutes and fractions and vice versa

    Started by benoj2005‎, 10-23-2012 06:57 AM
    3 Attachment(s)
    • 15
    • 1,224
    benoj2005
    10-23-2012, 07:57 AM Go to last post

  38. [SOLVED] Formula for begins with?

    Started by benoj2005‎, 03-12-2013 11:20 AM
    1 Attachment(s)
    • 3
    • 462
    benoj2005
    03-12-2013, 11:28 AM Go to last post

  39. Sumif on variable row number

    Started by benoj2005‎, 06-07-2013 06:22 AM
    1 Attachment(s)
    • 8
    • 3,118
    benoj2005
    06-07-2013, 06:49 AM Go to last post

  40. Sumifs of non static columns and specific line %

    Started by benoj2005‎, 06-18-2013 07:21 AM
    6 Attachment(s)
    • 29
    • 1,390
    benoj2005
    06-19-2013, 04:31 AM Go to last post

  41. Combined totals for specific columns and rows

    Started by benoj2005‎, 06-19-2013 03:26 AM
    1 Attachment(s)
    • 1
    • 471
    benoj2005
    06-19-2013, 10:07 AM Go to last post

  42. Summarise two lists of data automatically

    Started by benoj2005‎, 06-20-2013 07:04 AM
    2 Attachment(s)
    • 5
    • 519
    benoj2005
    06-24-2013, 03:19 AM Go to last post

  43. [SOLVED] Sumproduct with a range as a criteria?

    Started by benoj2005‎, 02-21-2017 10:43 AM
    2 Attachment(s)
    • 6
    • 703
    AlKey
    02-21-2017, 11:37 AM Go to last post

  44. [SOLVED] general number + [h]:mm

    Started by benoj2005‎, 12-16-2013 09:53 AM
    1 Attachment(s)
    • 8
    • 532
    benoj2005
    12-17-2013, 08:13 AM Go to last post

  45. [SOLVED] Trying to add two times (HH.DD) when some are minus figures

    Started by benoj2005‎, 01-06-2014 10:41 AM
    1 Attachment(s)
    • 5
    • 457
    Jonmo1
    01-06-2014, 10:57 AM Go to last post

  46. [SOLVED] sumproduct handle text as 0

    Started by benoj2005‎, 12-19-2014 11:45 AM
    1 Attachment(s)
    • 2
    • 418
    benoj2005
    12-19-2014, 12:00 PM Go to last post

  47. [SOLVED] wildcard in sumif(s) or sumproduct

    Started by benoj2005‎, 12-29-2014 10:46 AM
    1 Attachment(s)
    • 5
    • 613
    Jonmo1
    12-29-2014, 11:22 AM Go to last post

  48. [SOLVED] number of days between dates by week ending date

    Started by benoj2005‎, 10-22-2015 07:17 AM
    1 Attachment(s)
    • 8
    • 865
    bebo021999
    10-23-2015, 12:19 AM Go to last post

  49. [SOLVED] Finding number of days between dates and categorising by week ending date

    Started by benoj2005‎, 02-05-2016 06:53 AM
    1 Attachment(s)
    • 4
    • 679
    shukla.ankur281190
    02-05-2016, 07:42 AM Go to last post

  50. [SOLVED] Unique Count Formula

    Started by benoj2005‎, 01-04-2017 05:20 AM
    1 Attachment(s)
    • 3
    • 251
    chullan88
    01-04-2017, 05:57 AM Go to last post
+ Post New Thread
Page 503 of 5614 FirstFirst ... 503 ...

Forum Information and Options

Users Browsing this Forum

There are currently 58 users browsing this forum. (4 members & 54 guests)

  1. AliGW,
  2. Czeslaw,
  3. ExcelNewbie92,
  4. td3201

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