+ Post New Thread
Page 4 of 5613 FirstFirst ... 4 ...
Threads 151 to 200 of 280643

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

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

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

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

  3. 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
    • 58
    Bernie Deitrick
    04-17-2024, 04:57 PM Go to last post

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

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

  5. Countifs Mutiple Columns and Criteria Times

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

  6. [SOLVED] Returning output before delimiters

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

  7. [SOLVED] formula that supplies a Date based on stock price criteria

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

  8. [SOLVED] FILTER FUNCTION compare with array.

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

  9. Alternative to Filter(Filter()) formula

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

  10. If Function Help

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

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

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

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

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

  13. [SOLVED] Fornula for Highest Quantity

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

  14. [SOLVED] Dynamic drop-down lists

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

  15. formula to retun multiple values

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

  16. [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
    • 87
    windknife
    04-17-2024, 06:48 AM Go to last post

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

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

  18. Need to format phone number properly

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

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

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

  20. Not getting specific data from certain year !

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

  21. [SOLVED] Drop Down List Items

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

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

    Started by angie_lin‎, 04-17-2024 01:52 AM
    • 4
    • 62
    AliGW
    04-17-2024, 02:12 AM Go to last post

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

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

  24. [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
    • 88
    pejoi
    04-17-2024, 12:41 AM Go to last post

  25. [SOLVED] Correction in Formula

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

  26. Looking for a way to get SUM of data

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

  27. Calculate percentage of each client separately

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

  28. [SOLVED] Issues getting SUM formula to work

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

  29. [SOLVED] Category Amounts Year Over Year Analysis

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

  30. Referencing another workbook and used by multiple users.

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

  31. Count of time within a time

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

  32. [SOLVED] Why doesn't Excel assign the value 0 to those cells that contain text

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

  33. 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
    • 41
    AliGW
    04-16-2024, 11:38 AM Go to last post

  34. Index Match, Horizontal and Vertical Criteria

    Started by jharvey87‎, 04-16-2024 10:09 AM
    1 Attachment(s)
    • 2
    • 56
    JohnTopley
    04-16-2024, 10:28 AM Go to last post

  35. Calculate or input value

    Started by noshali‎, 04-15-2024 02:38 PM
    1 Attachment(s)
    • 8
    • 114
    6StringJazzer
    04-16-2024, 10:20 AM Go to last post

  36. How to make SUM function if red marked text?

    Started by toplisek‎, 04-14-2024 01:45 PM
    1 Attachment(s)
    • 5
    • 90
    JohnTopley
    04-16-2024, 09:37 AM Go to last post

  37. [SOLVED] Sick pay entitlement based on length of service.

    Started by Julaboyce‎, 03-07-2024 10:23 AM
    4 Attachment(s)
    • 12
    • 411
    JeteMc
    04-16-2024, 08:56 AM Go to last post

  38. How to extract text into readable text?

    Started by toplisek‎, 04-08-2024 05:57 AM
    2 Attachment(s)
    • 8
    • 121
    ben8563
    04-16-2024, 08:00 AM Go to last post

  39. Historic currency conversion

    Started by gb24!‎, 04-16-2024 06:42 AM
    currency conversion, historical data 2 Attachment(s)
    • 4
    • 77
    AliGW
    04-16-2024, 06:52 AM Go to last post

  40. [SOLVED] Weighted Average Calculation

    Started by omlette_boy‎, 04-16-2024 04:30 AM
    2 Attachment(s)
    • 11
    • 134
    HansDouwe
    04-16-2024, 06:52 AM Go to last post

  41. Calculate Completion Date and Time with Conditions and Exclusions

    Started by EllenAW‎, 04-15-2024 07:25 AM
    2 Attachment(s)
    • 5
    • 121
    HansDouwe
    04-16-2024, 06:47 AM Go to last post

  42. Question Slow Index or Match function in large data set

    Started by kennji31‎, 04-15-2024 05:59 AM
    1 Attachment(s)
    • 5
    • 73
    AliGW
    04-16-2024, 05:45 AM Go to last post

  43. [SOLVED] In spec/out of spec formula

    Started by Sam Burton‎, 04-13-2024 11:41 PM
    3 Attachment(s)
    • 6
    • 151
    wk9128
    04-16-2024, 05:11 AM Go to last post

  44. Question Arranging DATA accordingly/removing unwanted TEXT

    Started by tempertrap‎, 04-15-2024 11:49 PM
    1 Attachment(s)
    • 1
    • 56
    FDibbins
    04-16-2024, 12:19 AM Go to last post

  45. [SOLVED] How to Copy and Paste Information if Contents of Another Cell Match

    Started by gloriousglenn‎, 04-15-2024 12:03 PM
    1 Attachment(s)
    • 3
    • 93
    Estevaoba
    04-15-2024, 10:29 PM Go to last post

  46. [SOLVED] Importing data from another worksheet when you type a name

    Started by Sam Burton‎, 04-15-2024 06:33 PM
    1 Attachment(s)
    • 5
    • 132
    wk9128
    04-15-2024, 08:17 PM Go to last post

  47. Group number values into equal groups

    Started by thedunna‎, 04-15-2024 10:38 AM
    1 Attachment(s)
    • 7
    • 118
    Pete_UK
    04-15-2024, 07:40 PM Go to last post

  48. Combining duplicated based off data in another column

    Started by Jfreder6‎, 04-15-2024 06:22 PM
    1 Attachment(s)
    • 1
    • 56
    wk9128
    04-15-2024, 06:36 PM Go to last post

  49. [SOLVED] Help with Formulas to populate a Calendar

    Started by Newtonus_Prime‎, 04-15-2024 12:53 PM
    3 Attachment(s)
    • 7
    • 127
    HansDouwe
    04-15-2024, 05:18 PM Go to last post

  50. Post Hyperlinks returns reference isn't valid

    Started by RKMH‎, 04-11-2024 12:30 PM
    address, hyperlinks, indirect address, indirect cell reference 3 Attachment(s)
    • 4
    • 136
    RKMH
    04-15-2024, 01:29 PM Go to last post
+ Post New Thread
Page 4 of 5613 FirstFirst ... 4 ...

Forum Information and Options

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