+ Post New Thread
Page 1053 of 5615 FirstFirst ... 1053 ...
Threads 52601 to 52650 of 280709

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,909
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. New member help with a formula for formatting a serial number

    Started by Buzbee‎, 11-29-2018 06:13 PM
    1 Attachment(s)
    • 7
    • 360
    Buzbee
    12-01-2018, 07:04 AM Go to last post

  2. [SOLVED] sumif with multiple sum range

    Started by Vivek2705‎, 12-01-2018 05:48 AM
    mutiple sum ranges, sumif
    • 3
    • 31,004
    Bo_Ry
    12-01-2018, 06:25 AM Go to last post

  3. Formula with offset xRow 4,2,4,2,4 ...

    Started by daboho‎, 12-01-2018 06:17 AM
    • 1
    • 219
    Glenn Kennedy
    12-01-2018, 06:21 AM Go to last post

  4. Averageifs help

    Started by parbynat‎, 12-01-2018 05:26 AM
    • 3
    • 300
    avk
    12-01-2018, 05:50 AM Go to last post

  5. [SOLVED] Count number of duplicate records.

    Started by Vivek2705‎, 11-28-2018 08:53 AM
    count duplicate records
    • 10
    • 1,120
    etaf
    12-01-2018, 05:42 AM Go to last post

  6. Can someone please breakdown the formula below into bite-sized chunks or explain it to me

    Started by SethDark‎, 12-01-2018 03:35 AM
    • 2
    • 238
    STUARTXL
    12-01-2018, 04:14 AM Go to last post

  7. [SOLVED] Array/Function to for corresponding numbers

    Started by Karnik‎, 12-01-2018 12:14 AM
    1 Attachment(s)
    • 3
    • 218
    Karnik
    12-01-2018, 02:46 AM Go to last post

  8. [SOLVED] Array Formula with nested IF/THEN in average - how to ignore zeros

    Started by crunsemo‎, 11-30-2018 09:14 PM
    1 Attachment(s)
    • 2
    • 490
    crunsemo
    12-01-2018, 02:34 AM Go to last post

  9. Shifting Entire Array Based on Cell Value Outside Array (Amortization Table)

    Started by LoanHelp1‎, 11-30-2018 10:28 AM
    1 Attachment(s)
    • 5
    • 320
    Bo_Ry
    12-01-2018, 12:12 AM Go to last post

  10. [SOLVED] Index-match

    Started by dss11‎, 11-30-2018 02:19 PM
    • 4
    • 328
    63falcondude
    12-01-2018, 12:03 AM Go to last post

  11. Subtracting values based on dates from specific cases

    Started by Shellystar1‎, 11-29-2018 05:05 PM
    date, subtract 3 Attachment(s)
    • 11
    • 677
    Bo_Ry
    11-30-2018, 10:09 PM Go to last post

  12. Counting ONLY consecutive days worked starting from a user defined date

    Started by Tazdude24‎, 11-08-2018 05:15 PM
    2 Attachment(s)
    • 4
    • 476
    Tazdude24
    11-30-2018, 09:47 PM Go to last post

  13. Random Negative Returns

    Started by mussonip‎, 11-30-2018 06:28 PM
    formulas, negative numbers, random assignment
    • 4
    • 757
    Richard Buttrey
    11-30-2018, 07:52 PM Go to last post

  14. Change color on cells if match

    Started by dss11‎, 11-30-2018 04:57 PM
    2 Attachment(s)
    • 9
    • 4,621
    Fluff13
    11-30-2018, 06:42 PM Go to last post

  15. [SOLVED] Stacking Range of Columns?

    Started by Reece2M4‎, 11-30-2018 04:31 PM
    4 Attachment(s)
    • 7
    • 656
    FlameRetired
    11-30-2018, 06:32 PM Go to last post

  16. [SOLVED] Get Total From Other Cells w/ Formulas

    Started by LagBoi‎, 11-30-2018 03:50 PM
    2 Attachment(s)
    • 3
    • 218
    Aardigspook
    11-30-2018, 04:52 PM Go to last post

  17. [SOLVED] Using two Vlookups to subtract, how to show "No Data" if Neither exist

    Started by AMille‎, 11-30-2018 02:31 PM
    • 4
    • 482
    AMille
    11-30-2018, 04:43 PM Go to last post

  18. Trying to show 0 if SUM<1, but the SUM if calculation is over zero.

    Started by amoberg‎, 11-30-2018 03:55 PM
    • 4
    • 408
    Sam Capricci
    11-30-2018, 04:30 PM Go to last post

  19. [SOLVED] Format Formula with Formatted Result

    Started by bigtunelover‎, 11-30-2018 02:36 PM
    cell format, concatenate, format cell
    • 11
    • 714
    Sam Capricci
    11-30-2018, 04:16 PM Go to last post

  20. [SOLVED] Calculation limit

    Started by dekueb‎, 11-30-2018 04:44 AM
    • 3
    • 202
    Glenn Kennedy
    11-30-2018, 03:46 PM Go to last post

  21. Help with a formula which will provide a value after two text cells are selected

    Started by J.osephw‎, 11-30-2018 12:34 PM
    2 Attachment(s)
    • 9
    • 300
    davesexcel
    11-30-2018, 03:36 PM Go to last post

  22. Combining multiple LOOKUP formulas

    Started by mhkeim‎, 11-30-2018 03:07 PM
    • 1
    • 289
    Richard Buttrey
    11-30-2018, 03:21 PM Go to last post

  23. [SOLVED] #DIV/0! error when array

    Started by phbryan‎, 11-30-2018 01:52 PM
    arrays as criteria 1 Attachment(s)
    • 2
    • 361
    phbryan
    11-30-2018, 03:18 PM Go to last post

  24. "+" & "-" numbers formula

    Started by vojc‎, 11-30-2018 09:20 AM
    3 Attachment(s)
    • 9
    • 324
    vojc
    11-30-2018, 02:57 PM Go to last post

  25. Diasplay values based on date

    Started by jtakajr‎, 11-29-2018 04:48 PM
    3 Attachment(s)
    • 8
    • 282
    Sam Capricci
    11-30-2018, 02:37 PM Go to last post

  26. Index-match

    Started by dss11‎, 11-30-2018 02:20 PM
    • 1
    • 332
    Sam Capricci
    11-30-2018, 02:27 PM Go to last post

  27. How can I see the formula used in this example

    Started by debbys‎, 11-30-2018 01:35 PM
    3 Attachment(s)
    • 6
    • 211
    63falcondude
    11-30-2018, 02:04 PM Go to last post

  28. adding flight times in a rolling time window- both forward and backward looking

    Started by aapilotgouge‎, 11-29-2018 11:56 PM
    2 Attachment(s)
    • 4
    • 355
    shg
    11-30-2018, 02:04 PM Go to last post

  29. [SOLVED] Capturing more than one 'match' in an array

    Started by Sedgeway‎, 11-30-2018 12:10 PM
    2 Attachment(s)
    • 8
    • 300
    Sedgeway
    11-30-2018, 01:55 PM Go to last post

  30. need to ignore blank values in AVERAGEA formula

    Started by powersml07‎, 11-30-2018 10:53 AM
    1 Attachment(s)
    • 4
    • 291
    Glenn Kennedy
    11-30-2018, 01:47 PM Go to last post

  31. Sum columns until target value met & report header date

    Started by bishopisgreat‎, 11-30-2018 01:13 PM
    2 Attachment(s)
    • 4
    • 361
    63falcondude
    11-30-2018, 01:37 PM Go to last post

  32. [SOLVED] [SOLVED] Sequential numbering of duplicates. COUNTIF but showing 1, 2, 3 etc.

    Started by Tigerlilygem‎, 11-30-2018 11:26 AM
    1 Attachment(s)
    • 3
    • 1,062
    Tigerlilygem
    11-30-2018, 01:12 PM Go to last post

  33. Make cell value dependent on the value of other cells.

    Started by jadedshade‎, 11-30-2018 12:48 PM
    • 3
    • 313
    63falcondude
    11-30-2018, 01:02 PM Go to last post

  34. Comparing Results against an average result

    Started by njw499‎, 11-30-2018 12:32 PM
    1 Attachment(s)
    • 1
    • 1,069
    Richard Buttrey
    11-30-2018, 12:50 PM Go to last post

  35. [SOLVED] MIN formula return lowest. Need 2nd lowest.

    Started by PeteABC123‎, 11-29-2018 12:48 PM
    • 7
    • 1,488
    PeteABC123
    11-30-2018, 12:36 PM Go to last post

  36. Assigned ships for each fleet

    Started by badongxd‎, 11-22-2018 10:42 PM
    8 Attachment(s)
    • 8
    • 410
    JeteMc
    11-30-2018, 11:13 AM Go to last post

  37. Counting cells that contain specific text within a date range

    Started by walkdaplank24‎, 11-30-2018 07:01 AM
    1 Attachment(s)
    • 3
    • 266
    etaf
    11-30-2018, 10:56 AM Go to last post

  38. Inserting string with Cyrillic character into a formula.

    Started by efijal‎, 11-29-2018 07:55 AM
    characters, cyrillic, formula, string, vba
    • 3
    • 1,220
    CK76
    11-30-2018, 10:01 AM Go to last post

  39. duplicate the image

    Started by lukaskoh‎, 11-29-2018 04:33 AM
    quality picture 2 Attachment(s)
    • 3
    • 255
    Logit
    11-30-2018, 09:58 AM Go to last post

  40. Question Proper use of table references in Conditional Formatting

    Started by mjcarman01‎, 11-30-2018 08:39 AM
    • 1
    • 2,439
    rorya
    11-30-2018, 08:45 AM Go to last post

  41. Formula to pull data when multiple criteria are met.

    Started by mike rand‎, 11-29-2018 01:37 PM
    1 Attachment(s)
    • 8
    • 327
    63falcondude
    11-30-2018, 08:31 AM Go to last post

  42. Formula to add one to the previous column, with one exception

    Started by scheidc‎, 11-22-2018 12:53 PM
    4 Attachment(s)
    • 15
    • 546
    63falcondude
    11-30-2018, 08:21 AM Go to last post

  43. [SOLVED] Count unique values from a column with conditions

    Started by Fullspeeduws‎, 11-29-2018 02:37 PM
    countif
    • 3
    • 450
    63falcondude
    11-30-2018, 08:19 AM Go to last post

  44. [SOLVED] Cell = oranges when B1=x and B2=y

    Started by Wiigit‎, 11-29-2018 01:50 PM
    • 9
    • 291
    63falcondude
    11-30-2018, 08:18 AM Go to last post

  45. Calculate cost of service over 5 years, based on services due frequency

    Started by libra91‎, 11-30-2018 05:31 AM
    1 Attachment(s)
    • 2
    • 276
    libra91
    11-30-2018, 06:17 AM Go to last post

  46. Question Sort Column data based on another columns content

    Started by shanoprepress‎, 11-29-2018 02:27 PM
    sort 1 Attachment(s)
    • 4
    • 465
    shanoprepress
    11-30-2018, 06:14 AM Go to last post

  47. Data from different workbooks

    Started by beepetark‎, 11-29-2018 08:53 AM
    • 3
    • 230
    Glenn Kennedy
    11-30-2018, 04:10 AM Go to last post

  48. Savings Plan

    Started by KingpinNOS‎, 11-29-2018 02:59 AM
    • 6
    • 292
    FDibbins
    11-30-2018, 02:53 AM Go to last post

  49. Question Constant and Relative Questions

    Started by kxkxkxx‎, 11-29-2018 03:54 PM
    formulas & functions, sum across months
    • 3
    • 358
    AliGW
    11-30-2018, 02:52 AM Go to last post

  50. [SOLVED] Bloomberg: Country

    Started by Keibri‎, 11-28-2018 02:52 AM
    • 5
    • 6,937
    FDibbins
    11-30-2018, 02:31 AM Go to last post
+ Post New Thread
Page 1053 of 5615 FirstFirst ... 1053 ...

Forum Information and Options

Users Browsing this Forum

There are currently 76 users browsing this forum. (10 members & 66 guests)

  1. AliGW,
  2. ExcelNewbie92,
  3. Gregb11,
  4. Lafsen,
  5. MubiJazz,
  6. not_excel-ing,
  7. Pete_UK,
  8. RogueStab,
  9. TMS,
  10. zbor

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