+ Post New Thread
Page 1 of 5611 1 ...
Threads 1 to 50 of 280514

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

  1. Post Countif - only up to where the required text changes?

    Started by jed76‎, Today 03:47 AM
    countif, excel, function 1 Attachment(s)
    • 15
    • 129
    AliGW
    Today, 06:42 AM Go to last post

  2. titles association with by-products

    Started by dim mor‎, 04-15-2024 05:34 AM
    5 Attachment(s)
    • 18
    • 171
    AliGW
    Today, 05:33 AM Go to last post

  3. Question Grouping data values in one column based on another column (picture included to explain)

    Started by ant665321‎, Yesterday 11:36 AM
    3 Attachment(s)
    • 4
    • 75
    AliGW
    Today, 04:18 AM Go to last post

  4. [SOLVED] XLOOKUP or FILTER matrix result expected but #VALUE! returned

    Started by dxfoxd‎, Yesterday 12:59 PM
    2 Attachment(s)
    • 3
    • 73
    HansDouwe
    Today, 03:53 AM Go to last post

  5. Moved: Need Help Creating a Master Workbook from Multiple Workbooks Which Updates

    Started by kimsem‎, Today 12:56 AM
    •  
    •  

  6. Rule to turn on specific cells

    Started by 2tall2call‎, Yesterday 06:12 PM
    • 2
    • 45
    AliGW
    Today, 01:09 AM Go to last post

  7. Looking for a way to filter a text variable

    Started by Newtonus_Prime‎, Yesterday 11:51 AM
    2 Attachment(s)
    • 3
    • 102
    AliGW
    Today, 12:56 AM Go to last post

  8. [SOLVED] Need help nesting SUM and AND in multiple IFs formula!

    Started by rubiod3‎, Yesterday 04:09 PM
    and formula, if formula, ifs formula, nested formula, sum formula
    • 2
    • 41
    AliGW
    Today, 12:41 AM Go to last post

  9. [SOLVED] COUNTIFS issues

    Started by wolfm‎, Yesterday 12:35 AM
    2 Attachment(s)
    • 6
    • 87
    wolfm
    Today, 12:10 AM Go to last post

  10. formula that searches an array

    Started by okcsteve‎, 04-16-2024 10:44 PM
    2 Attachment(s)
    • 7
    • 117
    okcsteve
    Yesterday, 10:41 PM Go to last post

  11. I have a column total that should be adjusted by (a cell total multiplied by another cell)

    Started by sanda_dennisp‎, Yesterday 06:07 PM
    1 Attachment(s)
    • 1
    • 41
    Gregb11
    Yesterday, 10:39 PM Go to last post

  12. [SOLVED] Multiple checks across text values for condition to be returned - 4 possible outcomes

    Started by LL11‎, 04-16-2024 10:09 PM
    2 Attachment(s)
    • 4
    • 71
    LL11
    Yesterday, 10:24 PM Go to last post

  13. [SOLVED] 20 days - Return Date from the Calendar days

    Started by RJ1969‎, 03-25-2024 07:53 PM
    13 Attachment(s)
    • 49
    • 522
    TMS
    Yesterday, 07:41 PM Go to last post

  14. Index and match to find a column number

    Started by tays01s‎, Yesterday 04:11 PM
    index, matach 2 Attachment(s)
    • 1
    • 35
    Glenn Kennedy
    Yesterday, 05:41 PM Go to last post

  15. Generate a table with repeating values based on input parameter

    Started by HighGoblinInvestigat‎, Yesterday 02:31 PM
    date, fomula, table 2 Attachment(s)
    • 1
    • 68
    CK76
    Yesterday, 05:27 PM Go to last post

  16. Calculate the number of representatives an organization can have based on membership size

    Started by drterry‎, Yesterday 04:12 PM
    calculate, calculation, formula
    • 1
    • 38
    Bernie Deitrick
    Yesterday, 04:57 PM Go to last post

  17. Moved: Sequence and/or Networkdays Formula in Google Sheets

    Started by dschwichtenberg‎, Yesterday 04:31 PM
    •  
    •  

  18. Countifs Mutiple Columns and Criteria Times

    Started by alo2279‎, 04-15-2024 03:34 PM
    2 Attachment(s)
    • 6
    • 106
    CK76
    Yesterday, 03:42 PM Go to last post

  19. [SOLVED] Returning output before delimiters

    Started by wolfm‎, 04-16-2024 02:30 PM
    2 Attachment(s)
    • 9
    • 84
    TMS
    Yesterday, 02:57 PM Go to last post

  20. formula that supplies a Date based on stock price criteria

    Started by okcsteve‎, 04-16-2024 09:39 PM
    2 Attachment(s)
    • 3
    • 92
    okcsteve
    Yesterday, 02:48 PM Go to last post

  21. % of vacant units using 2 pivot tables - Dynamic

    Started by jeptik‎, 04-16-2024 11:41 AM
    1 Attachment(s)
    • 3
    • 40
    jeptik
    Yesterday, 02:02 PM Go to last post

  22. [SOLVED] FILTER FUNCTION compare with array.

    Started by dxfoxd‎, 04-16-2024 06:23 PM
    1 Attachment(s)
    • 3
    • 65
    Glenn Kennedy
    Yesterday, 12:49 PM Go to last post

  23. Alternative to Filter(Filter()) formula

    Started by showboat‎, Yesterday 11:03 AM
    1 Attachment(s)
    • 1
    • 49
    BE_receiving
    Yesterday, 12:40 PM Go to last post

  24. If Function Help

    Started by Depressedcorporate‎, Yesterday 11:04 AM
    • 2
    • 50
    AliGW
    Yesterday, 11:49 AM Go to last post

  25. [SOLVED] How to convert from Table 1 to Table 2

    Started by metrostar‎, Yesterday 08:49 AM
    4 Attachment(s)
    • 5
    • 86
    Czeslaw
    Yesterday, 10:18 AM Go to last post

  26. Extracting Year, Month, Day, and Time from a String

    Started by boynejs‎, Yesterday 09:55 AM
    2 Attachment(s)
    • 3
    • 51
    AliGW
    Yesterday, 10:07 AM Go to last post

  27. Fornula for Highest Quantity

    Started by RUPESHRH‎, Yesterday 07:41 AM
    2 Attachment(s)
    • 3
    • 71
    TMS
    Yesterday, 09:51 AM Go to last post

  28. Help Extracting Specific Text From Inconsistent Text Strings

    Started by ZANDRY10085‎, 04-16-2024 07:56 PM
    1 Attachment(s)
    • 2
    • 68
    ZANDRY10085
    Yesterday, 09:42 AM Go to last post

  29. [SOLVED] Dynamic drop-down lists

    Started by paulma1960‎, 04-16-2024 11:17 AM
    2 Attachment(s)
    • 3
    • 77
    Estevaoba
    Yesterday, 08:29 AM Go to last post

  30. formula to retun multiple values

    Started by dimmere19‎, 04-16-2024 04:43 PM
    2 Attachment(s)
    • 5
    • 83
    Glenn Kennedy
    Yesterday, 07:20 AM Go to last post

  31. [SOLVED] Calculation of step tax with sumproduct function under the condition of non-exemption

    Started by Yaghoub61‎, Yesterday 06:03 AM
    5 Attachment(s)
    • 7
    • 69
    windknife
    Yesterday, 06:48 AM Go to last post

  32. Rounding values to 2 decimel while keeping total 100%

    Started by Fusionista‎, 04-12-2024 03:17 AM
    2 Attachment(s)
    • 15
    • 211
    AliGW
    Yesterday, 06:37 AM Go to last post

  33. Need to format phone number properly

    Started by Gardnofkids‎, 04-16-2024 10:45 AM
    • 5
    • 96
    HansDouwe
    Yesterday, 04:39 AM Go to last post

  34. Calculate elapsed hours between two date/time excluding weekends.

    Started by Jfreder6‎, 04-16-2024 08:35 PM
    2 Attachment(s)
    • 3
    • 52
    HansDouwe
    Yesterday, 04:33 AM Go to last post

  35. Not getting specific data from certain year !

    Started by sonu1975‎, 04-16-2024 09:46 AM
    2 Attachment(s)
    • 5
    • 65
    AliGW
    Yesterday, 03:56 AM Go to last post

  36. [SOLVED] Drop Down List Items

    Started by Dj_Seagal‎, 04-16-2024 02:34 PM
    2 Attachment(s)
    • 10
    • 118
    AliGW
    Yesterday, 03:16 AM Go to last post

  37. Red face [SOLVED] Formula to remove a character first and last of the text in a cell

    Started by angie_lin‎, Yesterday 01:52 AM
    • 4
    • 49
    AliGW
    Yesterday, 02:12 AM Go to last post

  38. [SOLVED] need help with two formulas in one table

    Started by okcsteve‎, 04-15-2024 08:29 PM
    1 Attachment(s)
    • 2
    • 94
    AliGW
    Yesterday, 01:22 AM Go to last post

  39. [SOLVED] combine 2 data sheets based on target colum

    Started by pejoi‎, 04-16-2024 09:35 PM
    based colum, nest formulas, vlookup 3 Attachment(s)
    • 5
    • 77
    pejoi
    Yesterday, 12:41 AM Go to last post

  40. [SOLVED] Correction in Formula

    Started by RUPESHRH‎, 04-16-2024 04:51 AM
    2 Attachment(s)
    • 9
    • 89
    wk9128
    04-16-2024, 08:17 PM Go to last post

  41. Question [SOLVED] Summary Page that pulls information from different columns into a two primary columns

    Started by maplesyrup22‎, 04-16-2024 04:09 PM
    1 Attachment(s)
    • 4
    • 68
    wk9128
    04-16-2024, 08:16 PM Go to last post

  42. Looking for a way to get SUM of data

    Started by Newtonus_Prime‎, 04-16-2024 04:41 PM
    1 Attachment(s)
    • 4
    • 59
    TMS
    04-16-2024, 07:36 PM Go to last post

  43. Calculate percentage of each client separately

    Started by Fusionista‎, 04-10-2024 07:45 AM
    4 Attachment(s)
    • 11
    • 204
    Fusionista
    04-16-2024, 03:44 PM Go to last post

  44. [SOLVED] Issues getting SUM formula to work

    Started by Newtonus_Prime‎, 04-16-2024 02:35 PM
    2 Attachment(s)
    • 3
    • 61
    etaf
    04-16-2024, 03:03 PM Go to last post

  45. Is there a formula to join values but start over after blank rows?

    Started by Sandi770‎, 04-16-2024 01:33 PM
    4 Attachment(s)
    • 2
    • 52
    Sandi770
    04-16-2024, 02:33 PM Go to last post

  46. [SOLVED] Category Amounts Year Over Year Analysis

    Started by billy60‎, 04-16-2024 09:35 AM
    2 Attachment(s)
    • 7
    • 116
    billy60
    04-16-2024, 01:08 PM Go to last post

  47. Referencing another workbook and used by multiple users.

    Started by GeekBlueNose‎, 04-16-2024 12:15 PM
    • 0
    • 39
    GeekBlueNose
    04-16-2024, 12:15 PM Go to last post

  48. Count of time within a time

    Started by Peter.Smith‎, 04-16-2024 11:22 AM
    2 Attachment(s)
    • 3
    • 54
    Glenn Kennedy
    04-16-2024, 11:53 AM Go to last post

  49. Why doesn't Excel assign the value 0 to those cells that contain text

    Started by viewotst‎, 04-02-2024 03:26 PM
    • 31
    • 291
    6StringJazzer
    04-16-2024, 11:43 AM Go to last post

  50. Count number of cells based on a date in one column and a money value in another

    Started by redsheep79‎, 04-16-2024 11:37 AM
    excel, excel formula
    • 1
    • 37
    AliGW
    04-16-2024, 11:38 AM Go to last post
+ Post New Thread
Page 1 of 5611 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 68 users browsing this forum. (7 members & 61 guests)

  1. 9A4172,
  2. ant665321,
  3. etaf,
  4. HansDouwe,
  5. jed76,
  6. Lou2024,
  7. windknife

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