+ Post New Thread
Page 499 of 5613 FirstFirst ... 499 ...
Threads 24901 to 24950 of 280617

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

  1. [SOLVED] Looking for to resolve the Match formula in attached file

    Started by suneeshpillai‎, 05-02-2021 09:07 AM
    2 Attachment(s)
    • 8
    • 354
    FDibbins
    05-04-2021, 01:45 AM Go to last post

  2. [SOLVED] How to count partial matches in single cell with multiple concatenated values?

    Started by therealdees‎, 05-01-2021 09:43 PM
    • 4
    • 290
    FDibbins
    05-04-2021, 01:45 AM Go to last post

  3. Substitute text

    Started by bambino86‎, 05-03-2021 11:58 PM
    1 Attachment(s)
    • 3
    • 325
    AliGW
    05-04-2021, 12:41 AM Go to last post

  4. calculate average excluding both Filtered rows & 0 value in cells

    Started by varunistician‎, 04-28-2021 09:48 PM
    1 Attachment(s)
    • 3
    • 608
    bebo021999
    05-03-2021, 10:44 PM Go to last post

  5. Displaying data from multiple sheets with multiple criteria

    Started by afreed33‎, 05-03-2021 07:31 PM
    aggregate, criteria as text, function 1 Attachment(s)
    • 2
    • 386
    thenewkidd
    05-03-2021, 08:23 PM Go to last post

  6. index/match formula to return variable/changing results from different sheet

    Started by Owen1976‎, 04-30-2021 09:19 AM
    3 Attachment(s)
    • 15
    • 439
    cubangt
    05-03-2021, 05:46 PM Go to last post

  7. Mixing organisational data types

    Started by samdthompson‎, 05-03-2021 02:32 PM
    data types
    • 2
    • 274
    samdthompson
    05-03-2021, 04:47 PM Go to last post

  8. [SOLVED] Formula to check width and length from multiple cells and return text

    Started by WAAZUPEE‎, 05-03-2021 11:45 AM
    1 Attachment(s)
    • 2
    • 227
    WAAZUPEE
    05-03-2021, 04:12 PM Go to last post

  9. Populating cells based on dependent drop down lists within a table

    Started by heapy41‎, 05-03-2021 03:40 PM
    1 Attachment(s)
    • 1
    • 212
    JohnTopley
    05-03-2021, 04:01 PM Go to last post

  10. [SOLVED] IFERROR Index and Match formula not returning expected result

    Started by Ron Purpura‎, 05-03-2021 03:36 PM
    1 Attachment(s)
    • 2
    • 194
    Ron Purpura
    05-03-2021, 03:52 PM Go to last post

  11. [SOLVED] Formula: Only count "Y"s in Column B if a certain criteria is met in Column A

    Started by Micky.ripley‎, 05-03-2021 12:59 PM
    countif, sumif 1 Attachment(s)
    • 6
    • 383
    Fluff13
    05-03-2021, 03:13 PM Go to last post

  12. Debt Repayment

    Started by Chandrashekhar‎, 05-27-2009 12:35 AM
    2 Attachment(s)
    • 2
    • 1,178
    JeteMc
    05-03-2021, 01:39 PM Go to last post

  13. Highest to 6 scores from 8 weeks

    Started by John Henworth‎, 05-03-2021 06:28 AM
    4 Attachment(s)
    • 8
    • 329
    Richard Buttrey
    05-03-2021, 12:56 PM Go to last post

  14. [SOLVED] Referencing cells

    Started by Schroeder70‎, 04-28-2021 03:35 PM
    1 Attachment(s)
    • 8
    • 414
    JohnTopley
    05-03-2021, 12:31 PM Go to last post

  15. using roundup on multiple formulas

    Started by Petewxm‎, 05-03-2021 08:58 AM
    • 6
    • 426
    AliGW
    05-03-2021, 11:59 AM Go to last post

  16. WTA : How is the formula in column amount with different percentage?

    Started by vrontire‎, 04-27-2021 10:58 PM
    2 Attachment(s)
    • 6
    • 326
    JeteMc
    05-03-2021, 11:41 AM Go to last post

  17. [SOLVED] COMBINING Revenue and Expenses to construct a excel bank ledger

    Started by sunboy‎, 04-29-2021 10:31 PM
    8 Attachment(s)
    • 15
    • 576
    sunboy
    05-03-2021, 11:25 AM Go to last post

  18. [SOLVED] extract all rows on even numbers

    Started by codeBeast‎, 05-03-2021 05:10 AM
    • 2
    • 347
    JohnTopley
    05-03-2021, 10:01 AM Go to last post

  19. [SOLVED] Payment forecast

    Started by flexi2323‎, 05-02-2021 01:17 PM
    2 Attachment(s)
    • 3
    • 436
    JohnTopley
    05-03-2021, 10:00 AM Go to last post

  20. Is there a formula that works similar to goal seek?

    Started by jinthesensei‎, 05-03-2021 07:39 AM
    • 2
    • 457
    jinthesensei
    05-03-2021, 09:14 AM Go to last post

  21. [SOLVED] Count all the specific Description base on name

    Started by jasond1992‎, 05-03-2021 04:34 AM
    countif, match 4 Attachment(s)
    • 2
    • 391
    jasond1992
    05-03-2021, 04:53 AM Go to last post

  22. Moved: @ - Structured Table Referencing causing dramas

    Started by JeffGrant‎, 05-03-2021 04:25 AM
    •  
    •  

  23. [SOLVED] Expand a formula to other cells - given the complexity of the formula, a bit tricky

    Started by Schroeder70‎, 05-02-2021 08:01 AM
    3 Attachment(s)
    • 12
    • 484
    JohnTopley
    05-03-2021, 04:32 AM Go to last post

  24. Automatically populate cells with conditional formatting rules based on drop box selection

    Started by HSawyer4288‎, 05-02-2021 11:56 PM
    1 Attachment(s)
    • 7
    • 299
    JohnTopley
    05-03-2021, 04:23 AM Go to last post

  25. Question SUMIFS with multiple titles/conditions

    Started by karim1998‎, 05-03-2021 03:31 AM
    excel, formulas, sumif, sumsif
    • 2
    • 446
    etaf
    05-03-2021, 03:43 AM Go to last post

  26. Categorize items based on free text

    Started by amohannadi‎, 04-27-2021 06:35 AM
    2 Attachment(s)
    • 3
    • 359
    JeteMc
    05-03-2021, 12:01 AM Go to last post

  27. Manipulate Data Tables

    Started by sarah696‎, 05-02-2021 04:44 PM
    8 Attachment(s)
    • 9
    • 343
    sarah696
    05-02-2021, 11:06 PM Go to last post

  28. Finding the correct formula

    Started by Luther_K‎, 05-02-2021 07:21 PM
    • 1
    • 322
    Richard Buttrey
    05-02-2021, 08:05 PM Go to last post

  29. [SOLVED] Find the percentage a cell is in a time range and the average time within each

    Started by cableghost‎, 04-30-2021 06:05 PM
    average, time 13 Attachment(s)
    • 56
    • 1,845
    cableghost
    05-02-2021, 07:11 PM Go to last post

  30. [SOLVED] Help with VLOOKUP: alphanumeric lookup values

    Started by ertrodrigues‎, 05-02-2021 02:33 PM
    • 5
    • 3,093
    FlameRetired
    05-02-2021, 04:25 PM Go to last post

  31. formula to highlight the top 3, 5 values in a row (for eg., in cells FA2 to GE2)

    Started by raja1964‎, 04-30-2021 01:24 PM
    2 Attachment(s)
    • 3
    • 264
    protonLeah
    05-02-2021, 04:00 PM Go to last post

  32. Lightbulb How to replace " from a Text?

    Started by Sybon‎, 05-02-2021 07:54 AM
    clean, replace, special character, substitute
    • 10
    • 498
    Rick Rothstein
    05-02-2021, 03:23 PM Go to last post

  33. Lightbulb [SOLVED] Adding multiple If conditions to a VLOOKUP function formula

    Started by Khaldon‎, 05-02-2021 11:42 AM
    2 Attachment(s)
    • 5
    • 310
    Khaldon
    05-02-2021, 02:35 PM Go to last post

  34. VPM Mix Sub-Calculations

    Started by warmstrong77‎, 04-27-2021 01:18 PM
    1 Attachment(s)
    • 1
    • 292
    FlameRetired
    05-02-2021, 02:12 PM Go to last post

  35. [SOLVED] Left, Right, Mid, or Substitute function to separate values into desired columns

    Started by bjnockle‎, 05-01-2021 08:59 PM
    2 Attachment(s)
    • 7
    • 347
    kvsrinivasamurthy
    05-02-2021, 10:40 AM Go to last post

  36. [SOLVED] Highlighting cells between columns in a row

    Started by Bilidikid‎, 05-02-2021 09:11 AM
    highlighting 2 Attachment(s)
    • 8
    • 379
    AliGW
    05-02-2021, 10:02 AM Go to last post

  37. How many IDs in column A match two criteria in column B?

    Started by J4KARTA‎, 04-24-2021 12:43 PM
    4 Attachment(s)
    • 10
    • 465
    J4KARTA
    05-02-2021, 09:41 AM Go to last post

  38. [SOLVED] Repeat Data using Dynamic Formula

    Started by leprince2007‎, 05-01-2021 08:17 AM
    1 Attachment(s)
    • 6
    • 377
    Fluff13
    05-02-2021, 08:23 AM Go to last post

  39. [SOLVED] Formula to increase a unique Id number that uses text and numbers

    Started by Stryfe‎, 05-02-2021 04:05 AM
    • 1
    • 236
    JohnTopley
    05-02-2021, 04:41 AM Go to last post

  40. [SOLVED] Returning unique values based on duplicate criteria

    Started by Excelfresh‎, 05-01-2021 06:44 PM
    duplicate, index + match 2 Attachment(s)
    • 7
    • 525
    JohnTopley
    05-02-2021, 02:48 AM Go to last post

  41. [SOLVED] Returning outstanding invoice amount for partial payments

    Started by mehdi_154‎, 04-12-2021 09:29 AM
    2 Attachment(s)
    • 8
    • 659
    mehdi_154
    05-02-2021, 02:47 AM Go to last post

  42. [SOLVED] Non Array Formula to Extract Unique Values

    Started by bjnockle‎, 04-30-2021 05:42 AM
    1 Attachment(s)
    • 3
    • 440
    AliGW
    05-02-2021, 02:44 AM Go to last post

  43. [SOLVED] Revenue and expenses list

    Started by sunboy‎, 05-01-2021 03:30 PM
    4 Attachment(s)
    • 8
    • 420
    Bo_Ry
    05-02-2021, 01:16 AM Go to last post

  44. [SOLVED] DATEDIF not working

    Started by Peterino‎, 05-01-2021 09:14 AM
    1 Attachment(s)
    • 5
    • 5,365
    Rick Rothstein
    05-01-2021, 06:44 PM Go to last post

  45. [SOLVED] Formula to alamgamate and edit?

    Started by LMills77‎, 04-30-2021 05:02 AM
    2 Attachment(s)
    • 10
    • 349
    JohnTopley
    05-01-2021, 04:08 PM Go to last post

  46. [SOLVED] Replace a term in one column with value in next column

    Started by reags‎, 05-01-2021 01:48 AM
    3 Attachment(s)
    • 10
    • 549
    AliGW
    05-01-2021, 03:53 PM Go to last post

  47. Adding rules for using keywords

    Started by Browne‎, 05-01-2021 09:51 AM
    2 Attachment(s)
    • 3
    • 334
    JohnTopley
    05-01-2021, 01:21 PM Go to last post

  48. Date formatting

    Started by chris8877‎, 05-01-2021 09:20 AM
    3 Attachment(s)
    • 2
    • 261
    Czeslaw
    05-01-2021, 09:58 AM Go to last post

  49. Group Countif formula with multiple conditions

    Started by suneeshpillai‎, 05-01-2021 05:29 AM
    3 Attachment(s)
    • 7
    • 368
    JohnTopley
    05-01-2021, 09:42 AM Go to last post

  50. [SOLVED] Formula to count finish times x amount of people

    Started by MR_STOPA‎, 04-30-2021 02:24 PM
    4 Attachment(s)
    • 9
    • 358
    JohnTopley
    05-01-2021, 09:02 AM Go to last post
+ Post New Thread
Page 499 of 5613 FirstFirst ... 499 ...

Forum Information and Options

Users Browsing this Forum

There are currently 64 users browsing this forum. (5 members & 59 guests)

  1. Estevaoba,
  2. ExceLogan,
  3. JeteMc,
  4. Phuocam

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