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

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

  1. SUMPRODUCT and SUBTOTAL for STRUCTURED TABLE

    Started by EmmeEnne1979‎, Yesterday 01:20 PM
    2 Attachment(s)
    • 5
    • 70
    AliGW
    Today, 02:19 AM Go to last post

  2. Automatic fill up

    Started by pbruyere‎, Yesterday 02:16 PM
    2 Attachment(s)
    • 4
    • 56
    AliGW
    Today, 01:40 AM Go to last post

  3. lookup a value, but need two identifiers

    Started by Edward Hyde‎, Yesterday 10:25 AM
    2 Attachment(s)
    • 5
    • 55
    AliGW
    Today, 01:39 AM Go to last post

  4. Conditional Format for calendar with specific variables

    Started by mebert80‎, Yesterday 10:37 PM
    1 Attachment(s)
    • 1
    • 20
    AliGW
    Today, 01:09 AM Go to last post

  5. Smile INDIRECT() result to change based on adjacent cell

    Started by lea092‎, Yesterday 10:24 PM
    if(, indirect(
    • 1
    • 34
    AliGW
    Today, 01:00 AM Go to last post

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

    Started by sanda_dennisp‎, 04-17-2024 06:07 PM
    1 Attachment(s)
    • 3
    • 68
    Gregb11
    Yesterday, 10:45 PM Go to last post

  7. Match two criteria in two columns

    Started by alo2279‎, Yesterday 09:34 PM
    3 Attachment(s)
    • 2
    • 47
    windknife
    Yesterday, 10:10 PM Go to last post

  8. XLOOKUP or FILTER matrix result expected but #VALUE! returned

    Started by dxfoxd‎, 04-17-2024 12:59 PM
    4 Attachment(s)
    • 8
    • 114
    HansDouwe
    Yesterday, 08:52 PM Go to last post

  9. Post [SOLVED] Not transferring Employee names to main sheets

    Started by Jordon R‎, Yesterday 08:04 PM
    3 Attachment(s)
    • 7
    • 41
    TMS
    Yesterday, 08:34 PM Go to last post

  10. Post [SOLVED] Weekly Call Logger

    Started by BeardedGrizzly~‎, Yesterday 12:27 PM
    • 1
    • 42
    Logit
    Yesterday, 06:49 PM Go to last post

  11. Angry [SOLVED] SUMIFS will not work correctly

    Started by debun‎, Yesterday 04:12 PM
    sum, sumif, sumsif 1 Attachment(s)
    • 5
    • 64
    TMS
    Yesterday, 06:46 PM Go to last post

  12. [SOLVED] Vat calculation

    Started by sunboy‎, Yesterday 03:42 PM
    4 Attachment(s)
    • 11
    • 85
    TMS
    Yesterday, 06:08 PM Go to last post

  13. [SOLVED] Generate a table with repeating values based on input parameter

    Started by HighGoblinInvestigat‎, 04-17-2024 02:31 PM
    date, fomula, table 2 Attachment(s)
    • 4
    • 109
    CK76
    Yesterday, 04:19 PM Go to last post

  14. [SOLVED] Lookup a value in a matrix and give back the relavant headline

    Started by ThomasB61‎, Yesterday 02:59 PM
    formula, function, vba 1 Attachment(s)
    • 5
    • 57
    TMS
    Yesterday, 03:59 PM Go to last post

  15. Clearing validation upon change

    Started by John Karman‎, Yesterday 01:26 PM
    clearing, validation 1 Attachment(s)
    • 0
    • 46
    John Karman
    Yesterday, 01:26 PM Go to last post

  16. Select every nth cell in a column

    Started by eozkired‎, Yesterday 01:06 PM
    • 1
    • 42
    Bernie Deitrick
    Yesterday, 01:13 PM Go to last post

  17. Red face Pull Values from 'data sheet' into 'check sheet' based on serial no

    Started by adz2‎, Yesterday 11:51 AM
    pull, results 2 Attachment(s)
    • 1
    • 31
    etaf
    Yesterday, 12:00 PM Go to last post

  18. Index and match to find a column number

    Started by tays01s‎, 04-17-2024 04:11 PM
    index, matach 3 Attachment(s)
    • 2
    • 47
    tays01s
    Yesterday, 11:53 AM Go to last post

  19. Data Validation Help Need

    Started by Eric Tsang‎, Yesterday 11:07 AM
    3 Attachment(s)
    • 2
    • 35
    ByteMarks
    Yesterday, 11:53 AM Go to last post

  20. [SOLVED] Conditional formatting to highlights duplicate date from yesterdays date

    Started by dummy777‎, Yesterday 07:47 AM
    4 Attachment(s)
    • 11
    • 110
    HansDouwe
    Yesterday, 11:18 AM Go to last post

  21. 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)
    • 5
    • 71
    JeteMc
    Yesterday, 09:36 AM Go to last post

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

    Started by jed76‎, Yesterday 03:47 AM
    countif, excel, function 1 Attachment(s)
    • 17
    • 168
    jed76
    Yesterday, 07:49 AM Go to last post

  23. Loan Running Balance Not Considering Interest

    Started by billy60‎, Yesterday 07:12 AM
    1 Attachment(s)
    • 0
    • 46
    billy60
    Yesterday, 07:12 AM Go to last post

  24. Question [SOLVED] Grouping data values in one column based on another column (picture included to explain)

    Started by ant665321‎, 04-17-2024 11:36 AM
    3 Attachment(s)
    • 6
    • 93
    ant665321
    Yesterday, 07:09 AM Go to last post

  25. titles association with by-products

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

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

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

  27. Rule to turn on specific cells

    Started by 2tall2call‎, 04-17-2024 06:12 PM
    • 2
    • 49
    AliGW
    Yesterday, 01:09 AM Go to last post

  28. Looking for a way to filter a text variable

    Started by Newtonus_Prime‎, 04-17-2024 11:51 AM
    2 Attachment(s)
    • 3
    • 109
    AliGW
    Yesterday, 12:56 AM Go to last post

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

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

  30. [SOLVED] COUNTIFS issues

    Started by wolfm‎, 04-17-2024 12:35 AM
    2 Attachment(s)
    • 6
    • 94
    wolfm
    Yesterday, 12:10 AM Go to last post

  31. [SOLVED] formula that searches an array

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

  32. [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
    • 76
    LL11
    04-17-2024, 10:24 PM Go to last post

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

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

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

    Started by drterry‎, 04-17-2024 04:12 PM
    calculate, calculation, formula
    • 1
    • 41
    Bernie Deitrick
    04-17-2024, 04:57 PM Go to last post

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

    Started by dschwichtenberg‎, 04-17-2024 04:31 PM
    •  
    •  

  36. Countifs Mutiple Columns and Criteria Times

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

  37. [SOLVED] Returning output before delimiters

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

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

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

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

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

  40. [SOLVED] FILTER FUNCTION compare with array.

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

  41. Alternative to Filter(Filter()) formula

    Started by showboat‎, 04-17-2024 11:03 AM
    1 Attachment(s)
    • 1
    • 52
    BE_receiving
    04-17-2024, 12:40 PM Go to last post

  42. If Function Help

    Started by Depressedcorporate‎, 04-17-2024 11:04 AM
    • 2
    • 52
    AliGW
    04-17-2024, 11:49 AM Go to last post

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

    Started by metrostar‎, 04-17-2024 08:49 AM
    4 Attachment(s)
    • 5
    • 88
    Czeslaw
    04-17-2024, 10:18 AM Go to last post

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

    Started by boynejs‎, 04-17-2024 09:55 AM
    2 Attachment(s)
    • 3
    • 54
    AliGW
    04-17-2024, 10:07 AM Go to last post

  45. Fornula for Highest Quantity

    Started by RUPESHRH‎, 04-17-2024 07:41 AM
    2 Attachment(s)
    • 3
    • 74
    TMS
    04-17-2024, 09:51 AM Go to last post

  46. Help Extracting Specific Text From Inconsistent Text Strings

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

  47. [SOLVED] Dynamic drop-down lists

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

  48. formula to retun multiple values

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

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

    Started by Yaghoub61‎, 04-17-2024 06:03 AM
    5 Attachment(s)
    • 7
    • 71
    windknife
    04-17-2024, 06:48 AM Go to last post

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

    Started by Fusionista‎, 04-12-2024 03:17 AM
    2 Attachment(s)
    • 15
    • 211
    AliGW
    04-17-2024, 06:37 AM Go to last post
+ Post New Thread
Page 1 of 5611 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 79 users browsing this forum. (5 members & 74 guests)

  1. gere,
  2. Pepe Le Mokko,
  3. windknife,
  4. zyq13579

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