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

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. [SOLVED] 20 days - Return Date from the Calendar days

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

  2. Rule to turn on specific cells

    Started by 2tall2call‎, Today 06:12 PM
    • 1
    • 31
    Glenn Kennedy
    Today, 06:19 PM Go to last post

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

    Started by sanda_dennisp‎, Today 06:07 PM
    1 Attachment(s)
    • 0
    • 24
    sanda_dennisp
    Today, 06:07 PM Go to last post

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

    Started by dxfoxd‎, Today 12:59 PM
    2 Attachment(s)
    • 2
    • 58
    dxfoxd
    Today, 06:07 PM Go to last post

  5. Index and match to find a column number

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

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

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

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

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

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

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

  9. Looking for a way to filter a text variable

    Started by Newtonus_Prime‎, Today 11:51 AM
    2 Attachment(s)
    • 2
    • 91
    Estevaoba
    Today, 04:29 PM Go to last post

  10. Need help nesting SUM and AND in multiple IFs formula!

    Started by rubiod3‎, Today 04:09 PM
    and formula, if formula, ifs formula, nested formula, sum formula
    • 1
    • 24
    rubiod3
    Today, 04:20 PM Go to last post

  11. Countifs Mutiple Columns and Criteria Times

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

  12. [SOLVED] Returning output before delimiters

    Started by wolfm‎, Yesterday 02:30 PM
    2 Attachment(s)
    • 9
    • 81
    TMS
    Today, 02:57 PM Go to last post

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

    Started by ant665321‎, Today 11:36 AM
    2 Attachment(s)
    • 1
    • 41
    alansidman
    Today, 02:49 PM Go to last post

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

    Started by okcsteve‎, Yesterday 09:39 PM
    2 Attachment(s)
    • 3
    • 90
    okcsteve
    Today, 02:48 PM Go to last post

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

    Started by jeptik‎, Yesterday 11:41 AM
    1 Attachment(s)
    • 3
    • 39
    jeptik
    Today, 02:02 PM Go to last post

  16. [SOLVED] FILTER FUNCTION compare with array.

    Started by dxfoxd‎, Yesterday 06:23 PM
    1 Attachment(s)
    • 3
    • 62
    Glenn Kennedy
    Today, 12:49 PM Go to last post

  17. Alternative to Filter(Filter()) formula

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

  18. COUNTIFS issues

    Started by wolfm‎, Today 12:35 AM
    2 Attachment(s)
    • 5
    • 75
    wolfm
    Today, 12:22 PM Go to last post

  19. If Function Help

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

  20. formula that searches an array

    Started by okcsteve‎, Yesterday 10:44 PM
    2 Attachment(s)
    • 5
    • 94
    okcsteve
    Today, 11:18 AM Go to last post

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

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

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

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

  23. Fornula for Highest Quantity

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

  24. Help Extracting Specific Text From Inconsistent Text Strings

    Started by ZANDRY10085‎, Yesterday 07:56 PM
    1 Attachment(s)
    • 2
    • 63
    ZANDRY10085
    Today, 09:42 AM Go to last post

  25. titles association with by-products

    Started by dim mor‎, 04-15-2024 05:34 AM
    4 Attachment(s)
    • 11
    • 128
    AliGW
    Today, 08:34 AM Go to last post

  26. [SOLVED] Dynamic drop-down lists

    Started by paulma1960‎, Yesterday 11:17 AM
    2 Attachment(s)
    • 3
    • 75
    Estevaoba
    Today, 08:29 AM Go to last post

  27. formula to retun multiple values

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

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

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

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

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

  30. Need to format phone number properly

    Started by Gardnofkids‎, Yesterday 10:45 AM
    • 5
    • 95
    HansDouwe
    Today, 04:39 AM Go to last post

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

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

  32. Not getting specific data from certain year !

    Started by sonu1975‎, Yesterday 09:46 AM
    2 Attachment(s)
    • 5
    • 63
    AliGW
    Today, 03:56 AM Go to last post

  33. [SOLVED] Drop Down List Items

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

  34. Multiple checks across text values for condition to be returned - 4 possible outcomes

    Started by LL11‎, Yesterday 10:09 PM
    2 Attachment(s)
    • 3
    • 59
    bebo021999
    Today, 03:15 AM Go to last post

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

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

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

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

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

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

  38. [SOLVED] Correction in Formula

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

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

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

  40. Looking for a way to get SUM of data

    Started by Newtonus_Prime‎, Yesterday 04:41 PM
    1 Attachment(s)
    • 4
    • 57
    TMS
    Yesterday, 07:36 PM Go to last post

  41. Calculate percentage of each client separately

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

  42. [SOLVED] Issues getting SUM formula to work

    Started by Newtonus_Prime‎, Yesterday 02:35 PM
    2 Attachment(s)
    • 3
    • 60
    etaf
    Yesterday, 03:03 PM Go to last post

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

    Started by Sandi770‎, Yesterday 01:33 PM
    4 Attachment(s)
    • 2
    • 51
    Sandi770
    Yesterday, 02:33 PM Go to last post

  44. [SOLVED] Category Amounts Year Over Year Analysis

    Started by billy60‎, Yesterday 09:35 AM
    2 Attachment(s)
    • 7
    • 114
    billy60
    Yesterday, 01:08 PM Go to last post

  45. Referencing another workbook and used by multiple users.

    Started by GeekBlueNose‎, Yesterday 12:15 PM
    • 0
    • 36
    GeekBlueNose
    Yesterday, 12:15 PM Go to last post

  46. Count of time within a time

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

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

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

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

    Started by redsheep79‎, Yesterday 11:37 AM
    excel, excel formula
    • 1
    • 36
    AliGW
    Yesterday, 11:38 AM Go to last post

  49. Index Match, Horizontal and Vertical Criteria

    Started by jharvey87‎, Yesterday 10:09 AM
    1 Attachment(s)
    • 2
    • 44
    JohnTopley
    Yesterday, 10:28 AM Go to last post

  50. Calculate or input value

    Started by noshali‎, 04-15-2024 02:38 PM
    1 Attachment(s)
    • 8
    • 106
    6StringJazzer
    Yesterday, 10:20 AM Go to last post
+ Post New Thread
Page 1 of 5611 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 73 users browsing this forum. (3 members & 70 guests)

  1. andresventura,
  2. R0CKY

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