+ Post New Thread
Page 1003 of 5611 FirstFirst ... 1003 ...
Threads 50101 to 50150 of 280548

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

  1. Thumbs up Drop down list pulls data from QTR1/QTR2/QTR3/QTR4 from 14 tabs

    Started by mloring1972‎, 02-14-2019 06:20 AM
    1 Attachment(s)
    • 2
    • 872
    Richard Buttrey
    02-14-2019, 06:36 AM Go to last post

  2. IF/INDEX/MATCH?? - for looking up specific cells and quantities

    Started by RickCov‎, 02-14-2019 05:54 AM
    2 Attachment(s)
    • 6
    • 270
    Richard Buttrey
    02-14-2019, 06:31 AM Go to last post

  3. sum based between dates. with out effcting current formula

    Started by pmw19800‎, 02-14-2019 06:18 AM
    1 Attachment(s)
    • 1
    • 259
    PaulM100
    02-14-2019, 06:30 AM Go to last post

  4. Return the top 3 largest amounts in each category based on identifier

    Started by StanLeakup‎, 02-14-2019 03:27 AM
    3 Attachment(s)
    • 2
    • 244
    kvsrinivasamurthy
    02-14-2019, 06:10 AM Go to last post

  5. Cool Excel2010 - Conditional Formatting (Multiple Address List)

    Started by ExcelFan23‎, 02-13-2019 01:01 PM
    2 Attachment(s)
    • 4
    • 313
    ExcelFan23
    02-14-2019, 05:51 AM Go to last post

  6. Keeping a hold of max gap between dates when dates moving

    Started by thoma7329‎, 02-13-2019 07:29 PM
    • 1
    • 250
    XLent
    02-14-2019, 05:18 AM Go to last post

  7. qualitative risk level calculation

    Started by distord‎, 02-13-2019 11:34 AM
    2 Attachment(s)
    • 8
    • 569
    distord
    02-14-2019, 04:41 AM Go to last post

  8. [SOLVED] SUMPRODUCT - Adding New Data Daily

    Started by BigErnKingpin‎, 02-11-2019 08:11 AM
    sumproduct 2 Attachment(s)
    • 10
    • 1,993
    BigErnKingpin
    02-14-2019, 04:25 AM Go to last post

  9. Excel crashes on save to network location

    Started by feoruze‎, 02-14-2019 02:22 AM
    1 Attachment(s)
    • 5
    • 3,359
    AliGW
    02-14-2019, 04:24 AM Go to last post

  10. Divide numbers if conditions are met

    Started by Ossiman‎, 02-14-2019 03:10 AM
    • 1
    • 338
    Pepe Le Mokko
    02-14-2019, 04:12 AM Go to last post

  11. Exclamation Counting unique values between two dates in excel while specifying a criteria?

    Started by oddesy‎, 02-14-2019 01:36 AM
    • 1
    • 343
    AliGW
    02-14-2019, 02:21 AM Go to last post

  12. VLookup formula number match

    Started by 500bloc‎, 02-14-2019 01:19 AM
    • 2
    • 289
    AliGW
    02-14-2019, 01:46 AM Go to last post

  13. Get values from multiple columns on different worksheets into another column

    Started by jehster1‎, 02-14-2019 12:09 AM
    2 Attachment(s)
    • 1
    • 292
    Bo_Ry
    02-14-2019, 01:02 AM Go to last post

  14. [SOLVED] Count Cells that have more than 1 unique combination

    Started by lordfa9‎, 02-13-2019 11:15 PM
    1 Attachment(s)
    • 3
    • 304
    Bo_Ry
    02-14-2019, 12:24 AM Go to last post

  15. Automate Commission Accelerator calculations based on quota attainment range.

    Started by INMD13‎, 02-11-2019 05:32 PM
    attainment, commission, percentage, range, tiers 1 Attachment(s)
    • 2
    • 2,385
    INMD13
    02-14-2019, 12:11 AM Go to last post

  16. [SOLVED] Upper Case a Particular String of Text

    Started by Excell1677‎, 02-13-2019 09:25 PM
    case, partial text, upper
    • 3
    • 358
    Excell1677
    02-13-2019, 10:46 PM Go to last post

  17. [SOLVED] Incorporate an AND function in this formula

    Started by RICK JAMES‎, 02-13-2019 03:37 PM
    2 Attachment(s)
    • 7
    • 328
    RICK JAMES
    02-13-2019, 10:38 PM Go to last post

  18. CountIF formula not working for Churn reporting

    Started by sarahjane2019‎, 02-13-2019 09:01 PM
    churn, countif, customer usage, pivot table, sumif 3 Attachment(s)
    • 2
    • 755
    rcm
    02-13-2019, 09:54 PM Go to last post

  19. Ignoring blanks while keeping matched criteria sorted, without sorting.

    Started by Ghostcode‎, 02-13-2019 08:10 PM
    1 Attachment(s)
    • 2
    • 297
    MarvinP
    02-13-2019, 08:58 PM Go to last post

  20. [SOLVED] Help with writing IF formula

    Started by mdot218‎, 02-12-2019 08:32 PM
    2 Attachment(s)
    • 4
    • 275
    mdot218
    02-13-2019, 06:46 PM Go to last post

  21. Help on Yes/NO per filtered employee

    Started by hawkeyedm2003‎, 02-13-2019 05:59 PM
    • 1
    • 286
    TMS
    02-13-2019, 06:13 PM Go to last post

  22. [SOLVED] More efficient SUMPRODUCT formula?

    Started by mrdomer07‎, 02-11-2019 04:18 PM
    sumif, sumproduct
    • 6
    • 2,818
    TMS
    02-13-2019, 06:11 PM Go to last post

  23. [SOLVED] Formula to find same value

    Started by jerryong‎, 02-12-2019 06:01 PM
    2 Attachment(s)
    • 6
    • 433
    FlameRetired
    02-13-2019, 05:48 PM Go to last post

  24. Question Display Current Balance based on Todays date

    Started by milkjunkie90‎, 02-13-2019 04:30 PM
    balance, formula, savings, today 1 Attachment(s)
    • 1
    • 1,991
    FDibbins
    02-13-2019, 05:42 PM Go to last post

  25. WORKDAY() Function with dynamic multiple holiday ranges

    Started by OzNjB‎, 05-06-2018 08:12 PM
    1 Attachment(s)
    • 5
    • 5,301
    FlameRetired
    02-13-2019, 05:39 PM Go to last post

  26. Retrieving a text string based on multiple criteria

    Started by McKneezy‎, 11-06-2018 02:09 PM
    2 Attachment(s)
    • 10
    • 1,494
    McKneezy
    02-13-2019, 04:41 PM Go to last post

  27. Average with zeros

    Started by schoob123‎, 02-13-2019 12:11 PM
    2 Attachment(s)
    • 7
    • 495
    MrShorty
    02-13-2019, 04:16 PM Go to last post

  28. attendance sheet_need help

    Started by kreesh‎, 02-12-2019 11:05 AM
    2 Attachment(s)
    • 3
    • 304
    kreesh
    02-13-2019, 03:10 PM Go to last post

  29. [SOLVED] Cash-flow planning per day

    Started by VanChester‎, 02-08-2019 01:29 AM
    excel, sumif, sumifs 4 Attachment(s)
    • 5
    • 706
    sergiomabres
    02-13-2019, 02:54 PM Go to last post

  30. Hide text if cell is blank

    Started by drew.parker‎, 02-13-2019 01:36 PM
    • 3
    • 1,242
    Pete_UK
    02-13-2019, 02:48 PM Go to last post

  31. [SOLVED] MAXIFS with Array

    Started by matthew.leroy‎, 02-05-2019 05:27 PM
    • 3
    • 3,069
    AliGW
    02-13-2019, 02:18 PM Go to last post

  32. Lookup formulae

    Started by ross4122‎, 02-12-2019 06:15 PM
    4 Attachment(s)
    • 8
    • 433
    Arnold Layne
    02-13-2019, 02:05 PM Go to last post

  33. Question [SOLVED] transpose/convert range of rows and columns to one column, removing blanks

    Started by loganpmgoa‎, 02-13-2019 12:13 PM
    formula, range to single column, remove blanks, transpose 2 Attachment(s)
    • 10
    • 1,052
    alansidman
    02-13-2019, 01:49 PM Go to last post

  34. [SOLVED] COUNTIF for Text

    Started by Tortus‎, 02-13-2019 12:22 PM
    • 3
    • 350
    Tortus
    02-13-2019, 01:42 PM Go to last post

  35. [SOLVED] Finding lowest and Highest recorded times

    Started by chriswrcg‎, 02-13-2019 12:49 PM
    1 Attachment(s)
    • 3
    • 324
    dosydos
    02-13-2019, 01:10 PM Go to last post

  36. Lookup and substitute

    Started by Highflya1‎, 02-13-2019 12:53 PM
    • 1
    • 331
    dosydos
    02-13-2019, 12:57 PM Go to last post

  37. [SOLVED] Calculate commission without a loop

    Started by marielo‎, 02-13-2019 11:36 AM
    1 Attachment(s)
    • 5
    • 253
    marielo
    02-13-2019, 12:52 PM Go to last post

  38. [SOLVED] From Cell A2, remove text that is found in Cell B2, and display any remaining text in C2

    Started by lespaulfan#1‎, 02-13-2019 12:08 PM
    2 Attachment(s)
    • 5
    • 489
    Pete_UK
    02-13-2019, 12:42 PM Go to last post

  39. [SOLVED] adding up data by date and ID number

    Started by Jonces‎, 02-13-2019 09:05 AM
    2 Attachment(s)
    • 2
    • 216
    kvsrinivasamurthy
    02-13-2019, 12:13 PM Go to last post

  40. [SOLVED] Formlula to return Y or N based percentage value

    Started by bell_man‎, 02-13-2019 12:04 PM
    1 Attachment(s)
    • 2
    • 237
    bell_man
    02-13-2019, 12:12 PM Go to last post

  41. Date ranges translate in to Periods and Quarters

    Started by majidzahoor‎, 02-12-2019 11:44 AM
    2 Attachment(s)
    • 11
    • 366
    majidzahoor
    02-13-2019, 11:47 AM Go to last post

  42. [SOLVED] find overall score based on the number of criteria passed

    Started by J1234C‎, 02-13-2019 10:11 AM
    if functions 1 Attachment(s)
    • 9
    • 389
    J1234C
    02-13-2019, 11:46 AM Go to last post

  43. [SOLVED] Vlookup based on variable start/end date range

    Started by rwh05‎, 02-13-2019 07:17 AM
    1 Attachment(s)
    • 4
    • 675
    rwh05
    02-13-2019, 11:45 AM Go to last post

  44. Attempting to Check Cells for Specific Array Items

    Started by Paradime234‎, 02-12-2019 05:27 PM
    1 Attachment(s)
    • 3
    • 228
    Bo_Ry
    02-13-2019, 11:36 AM Go to last post

  45. [SOLVED] Return Top N values based of Reference ID

    Started by bambamclint‎, 02-07-2019 08:24 PM
    2 Attachment(s)
    • 1
    • 243
    sergiomabres
    02-13-2019, 11:15 AM Go to last post

  46. [SOLVED] SUMPRODUCT that ignores #N/A values

    Started by moneypennie21‎, 02-13-2019 10:08 AM
    #n/a, sumproduct
    • 2
    • 854
    moneypennie21
    02-13-2019, 11:12 AM Go to last post

  47. [SOLVED] Formula to check if all staus are by cell color return Y or N

    Started by bell_man‎, 02-13-2019 10:33 AM
    1 Attachment(s)
    • 1
    • 227
    Special-K
    02-13-2019, 11:06 AM Go to last post

  48. [SOLVED] Lookup Date and find Week Number (Bespoke Calendar)

    Started by Gazsim‎, 02-13-2019 07:57 AM
    date, lookup and match, week 2 Attachment(s)
    • 8
    • 460
    KOKOSEK
    02-13-2019, 10:46 AM Go to last post

  49. ID number searcher

    Started by samurhaj‎, 02-13-2019 09:00 AM
    • 1
    • 215
    alansidman
    02-13-2019, 10:04 AM Go to last post

  50. Pricing based on sheet lower the price higher the margin

    Started by DSemo‎, 02-07-2019 01:31 PM
    1 Attachment(s)
    • 1
    • 255
    sergiomabres
    02-13-2019, 09:57 AM Go to last post
+ Post New Thread
Page 1003 of 5611 FirstFirst ... 1003 ...

Forum Information and Options

Users Browsing this Forum

There are currently 71 users browsing this forum. (4 members & 67 guests)

  1. alarryaaron,
  2. Bernie Deitrick,
  3. billy60

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