+ Post New Thread
Page 1 of 5610 1 ...
Threads 1 to 50 of 280468

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

  1. [SOLVED] titles association with by-products

    Started by dim mor‎, Yesterday 05:34 AM
    2 Attachment(s)
    • 7
    • 85
    AliGW
    Today, 01:10 AM Go to last post

  2. Question Arranging DATA accordingly/removing unwanted TEXT

    Started by tempertrap‎, Yesterday 11:49 PM
    1 Attachment(s)
    • 1
    • 27
    FDibbins
    Today, 12:19 AM Go to last post

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

    Started by gloriousglenn‎, Yesterday 12:03 PM
    1 Attachment(s)
    • 3
    • 74
    Estevaoba
    Yesterday, 10:29 PM Go to last post

  4. Calculate or input value

    Started by noshali‎, Yesterday 02:38 PM
    • 3
    • 60
    6StringJazzer
    Yesterday, 09:59 PM Go to last post

  5. need help with two formulas in one table

    Started by okcsteve‎, Yesterday 08:29 PM
    1 Attachment(s)
    • 0
    • 45
    okcsteve
    Yesterday, 08:29 PM Go to last post

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

    Started by Sam Burton‎, Yesterday 06:33 PM
    1 Attachment(s)
    • 5
    • 111
    wk9128
    Yesterday, 08:17 PM Go to last post

  7. 20 days - Return Date from the Calendar days

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

  8. Group number values into equal groups

    Started by thedunna‎, Yesterday 10:38 AM
    1 Attachment(s)
    • 7
    • 97
    Pete_UK
    Yesterday, 07:40 PM Go to last post

  9. Countifs Mutiple Columns and Criteria Times

    Started by alo2279‎, Yesterday 03:34 PM
    2 Attachment(s)
    • 3
    • 72
    HansDouwe
    Yesterday, 06:50 PM Go to last post

  10. Combining duplicated based off data in another column

    Started by Jfreder6‎, Yesterday 06:22 PM
    1 Attachment(s)
    • 1
    • 28
    wk9128
    Yesterday, 06:36 PM Go to last post

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

    Started by Newtonus_Prime‎, Yesterday 12:53 PM
    3 Attachment(s)
    • 7
    • 102
    HansDouwe
    Yesterday, 05:18 PM Go to last post

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

    Started by Fusionista‎, 04-12-2024 03:17 AM
    1 Attachment(s)
    • 8
    • 129
    Fusionista
    Yesterday, 02:36 PM Go to last post

  13. 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
    • 126
    RKMH
    Yesterday, 01:29 PM Go to last post

  14. Need to fix IF AND formula for Windows Excel 365 MSO(Version 2308)

    Started by Shaybay01‎, 04-11-2024 09:08 PM
    5 Attachment(s)
    • 12
    • 174
    Shaybay01
    Yesterday, 01:04 PM Go to last post

  15. [SOLVED] Sum 52 cells worth of data within a larger range working backwards & excluding blank cells

    Started by Luna_1992‎, Yesterday 10:38 AM
    2 Attachment(s)
    • 4
    • 68
    Fluff13
    Yesterday, 11:11 AM Go to last post

  16. Calculate Completion Date and Time with Conditions and Exclusions

    Started by EllenAW‎, Yesterday 07:25 AM
    2 Attachment(s)
    • 3
    • 79
    HansDouwe
    Yesterday, 11:00 AM Go to last post

  17. Barcode functions

    Started by phillyd023‎, 03-29-2024 01:37 PM
    • 2
    • 80
    phillyd023
    Yesterday, 10:56 AM Go to last post

  18. Two way (Row & Column) lookup using Index Match

    Started by nagesh.tvsr‎, Yesterday 08:31 AM
    3 Attachment(s)
    • 7
    • 79
    etaf
    Yesterday, 09:45 AM Go to last post

  19. Filter with time window (Array function?)

    Started by timenewroman‎, Yesterday 09:29 AM
    1 Attachment(s)
    • 1
    • 53
    AliGW
    Yesterday, 09:31 AM Go to last post

  20. [SOLVED] Excel formula to find out what workday of a month is a particular date

    Started by samyraj‎, Yesterday 05:02 AM
    3 Attachment(s)
    • 3
    • 59
    HansDouwe
    Yesterday, 09:13 AM Go to last post

  21. [SOLVED] Sum Every Nth column Starting From Column 1

    Started by blackburnsexcel‎, Yesterday 08:37 AM
    • 6
    • 74
    AliGW
    Yesterday, 08:56 AM Go to last post

  22. [SOLVED] Accumulative Addition Formula

    Started by omlette_boy‎, Yesterday 04:39 AM
    1 Attachment(s)
    • 13
    • 103
    windknife
    Yesterday, 06:21 AM Go to last post

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

    Started by kennji31‎, Yesterday 05:59 AM
    1 Attachment(s)
    • 3
    • 50
    AliGW
    Yesterday, 06:07 AM Go to last post

  24. [SOLVED] Index Match 2 Criteria

    Started by TimLevs‎, Yesterday 05:43 AM
    2 Attachment(s)
    • 5
    • 59
    Pete_UK
    Yesterday, 06:06 AM Go to last post

  25. Moved: Conditional Sum through many sheets

    Started by SledgeTitan‎, 04-12-2024 06:50 AM
    •  
    •  

  26. [SOLVED] Help with formula

    Started by dandi10‎, Yesterday 05:14 AM
    excel formula 2 Attachment(s)
    • 3
    • 61
    etaf
    Yesterday, 05:36 AM Go to last post

  27. Averaging Time Duration

    Started by raemaurer21‎, 04-10-2024 06:58 PM
    1 Attachment(s)
    • 13
    • 140
    Pete_UK
    Yesterday, 04:39 AM Go to last post

  28. [SOLVED] Need assistance with formatting output to 2 decimals

    Started by skydivetom‎, Yesterday 03:23 AM
    • 3
    • 42
    AliGW
    Yesterday, 04:02 AM Go to last post

  29. [SOLVED] Formula to find data in another sheet

    Started by Oeysbrei‎, Yesterday 02:35 AM
    2 Attachment(s)
    • 7
    • 64
    AliGW
    Yesterday, 03:56 AM Go to last post

  30. [SOLVED] Finding partial match in databse with FILTER and XLOOPUP

    Started by aethsilgne‎, 04-14-2024 12:06 PM
    countif, databse, filter, partial, xlookup 9 Attachment(s)
    • 19
    • 181
    AliGW
    Yesterday, 03:39 AM Go to last post

  31. Average total cost on a tiered pricing table

    Started by Littleowl‎, 04-14-2024 07:38 AM
    3 Attachment(s)
    • 3
    • 110
    kvsrinivasamurthy
    Yesterday, 02:22 AM Go to last post

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

    Started by Sam Burton‎, 04-13-2024 11:41 PM
    3 Attachment(s)
    • 5
    • 129
    Sam Burton
    Yesterday, 01:32 AM Go to last post

  33. Using Sumproduct to Count Dates Ignoring Blanks

    Started by CamBoss125‎, 04-11-2024 01:03 AM
    2 Attachment(s)
    • 7
    • 134
    bebo021999
    04-14-2024, 10:31 PM Go to last post

  34. Same formula for different workbook

    Started by craig37862‎, 04-12-2024 03:26 PM
    2 Attachment(s)
    • 3
    • 89
    JeteMc
    04-14-2024, 09:43 PM Go to last post

  35. XIRR Formula error

    Started by bmahfouz‎, 04-11-2024 12:43 PM
    1 Attachment(s)
    • 7
    • 137
    MrShorty
    04-14-2024, 09:30 PM Go to last post

  36. Formula to find wich raw has cells with matching criteria

    Started by ZuluNation‎, 04-14-2024 12:53 PM
    • 3
    • 68
    Gregb11
    04-14-2024, 09:19 PM Go to last post

  37. #NUM error in XIRR formula

    Started by wmjenner‎, 04-12-2024 07:53 PM
    2 Attachment(s)
    • 5
    • 83
    MrShorty
    04-14-2024, 02:28 PM Go to last post

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

    Started by toplisek‎, 04-14-2024 01:45 PM
    • 1
    • 44
    etaf
    04-14-2024, 01:53 PM Go to last post

  39. Assign Serial Numbers to each product code

    Started by EdliraAlbania‎, 04-12-2024 03:56 AM
    4 Attachment(s)
    • 6
    • 119
    Glenn Kennedy
    04-14-2024, 01:50 PM Go to last post

  40. [SOLVED] Trying to Number Rows that Start with a Specific Word or Phrase

    Started by Modify_inc‎, 04-14-2024 12:54 PM
    2 Attachment(s)
    • 13
    • 77
    etaf
    04-14-2024, 01:49 PM Go to last post

  41. formula to make dropdown list change upon selections

    Started by pmsherry‎, 04-14-2024 04:43 AM
    1 Attachment(s)
    • 1
    • 69
    Estevaoba
    04-14-2024, 01:10 PM Go to last post

  42. [SOLVED] Adding year to date data based on selected month

    Started by Touta75‎, 04-12-2024 04:59 PM
    3 Attachment(s)
    • 8
    • 87
    AliGW
    04-14-2024, 01:09 PM Go to last post

  43. [SOLVED] making a login page

    Started by Bailymaus‎, 04-11-2024 10:27 AM
    3 Attachment(s)
    • 5
    • 133
    ORoos
    04-14-2024, 11:21 AM Go to last post

  44. [SOLVED] Extract Two Highest Values From a Range, Skipping Blank Cells

    Started by jyurek‎, 04-13-2024 09:40 PM
    max values, skip blanks array 2 Attachment(s)
    • 7
    • 115
    AliGW
    04-14-2024, 10:36 AM Go to last post

  45. Remove all text Xcept some

    Started by DesertDweller9‎, 04-13-2024 01:44 PM
    • 10
    • 123
    windknife
    04-14-2024, 09:22 AM Go to last post

  46. [SOLVED] Index and Matching

    Started by dianaCatz‎, 04-13-2024 05:53 PM
    2 Attachment(s)
    • 5
    • 90
    Glenn Kennedy
    04-14-2024, 09:10 AM Go to last post

  47. Vlookup and indirect and match formula

    Started by dianaCatz‎, 04-14-2024 07:15 AM
    1 Attachment(s)
    • 1
    • 53
    JohnTopley
    04-14-2024, 08:23 AM Go to last post

  48. [SOLVED] Give a distinct sequence number for every data type in Col A and Col B

    Started by Ravana‎, 04-14-2024 03:01 AM
    3 Attachment(s)
    • 14
    • 113
    MohamedGadAllah
    04-14-2024, 08:14 AM Go to last post

  49. Conditional Formatting: Don't format blank cells

    Started by Waseem0888‎, 04-14-2024 06:13 AM
    2 Attachment(s)
    • 1
    • 60
    6StringJazzer
    04-14-2024, 07:35 AM Go to last post

  50. How to calculate the day?

    Started by lalaarif1‎, 04-13-2024 09:13 AM
    1 Attachment(s)
    • 3
    • 103
    JohnTopley
    04-14-2024, 05:34 AM Go to last post
+ Post New Thread
Page 1 of 5610 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 54 users browsing this forum. (3 members & 51 guests)

  1. excelacademy,
  2. hazel4077,
  3. konskons

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