+ Post New Thread
Page 10 of 5614 FirstFirst ... 10 ...
Threads 451 to 500 of 280672

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

  1. [SOLVED] Sum based on two conditions

    Started by Thom7890‎, 04-03-2024 11:49 AM
    1 Attachment(s)
    • 2
    • 81
    Pete_UK
    04-03-2024, 12:31 PM Go to last post

  2. [SOLVED] Copy an excel sheet and automatically update the date to the last day of the next month

    Started by Bruno Trafaria‎, 04-02-2024 03:36 PM
    3 Attachment(s)
    • 16
    • 129
    Bruno Trafaria
    04-03-2024, 11:30 AM Go to last post

  3. replace duplicates

    Started by DanNet‎, 04-02-2024 12:15 PM
    duplicate to unqiue 6 Attachment(s)
    • 19
    • 115
    AliGW
    04-03-2024, 09:37 AM Go to last post

  4. [SOLVED] Total time formula

    Started by Zewa‎, 04-03-2024 05:27 AM
    1 Attachment(s)
    • 2
    • 54
    Pete_UK
    04-03-2024, 09:06 AM Go to last post

  5. [SOLVED] formula or vba to copy adjacent cells based on criteria in column A from column E

    Started by JEAN1972‎, 04-03-2024 02:22 AM
    8 Attachment(s)
    • 12
    • 316
    ORoos
    04-03-2024, 08:54 AM Go to last post

  6. Commission calculator

    Started by chucky_chan‎, 04-02-2024 12:15 PM
    • 3
    • 121
    Pete_UK
    04-03-2024, 08:48 AM Go to last post

  7. [SOLVED] Weighted Average Formula Excluding Zeros

    Started by jeptik‎, 04-01-2024 03:30 PM
    2 Attachment(s)
    • 7
    • 98
    josephteh
    04-03-2024, 08:43 AM Go to last post

  8. [SOLVED] Count cells that have been formatted by conditional formatting

    Started by viewotst‎, 04-03-2024 05:36 AM
    2 Attachment(s)
    • 11
    • 148
    AliGW
    04-03-2024, 08:18 AM Go to last post

  9. [SOLVED] SUM Merged + Non-merged cells

    Started by RoscoW88‎, 04-03-2024 06:57 AM
    1 Attachment(s)
    • 5
    • 122
    AliGW
    04-03-2024, 07:41 AM Go to last post

  10. [SOLVED] Index/ Match formula not returning the correct value

    Started by Grilleman‎, 04-03-2024 07:05 AM
    1 Attachment(s)
    • 4
    • 62
    AliGW
    04-03-2024, 07:20 AM Go to last post

  11. [SOLVED] adjust lookup formula to another column not giving expected results

    Started by JEAN1972‎, 04-03-2024 04:36 AM
    2 Attachment(s)
    • 3
    • 113
    JEAN1972
    04-03-2024, 06:46 AM Go to last post

  12. [SOLVED] Copying data from one sheet to another

    Started by Fusionista‎, 03-12-2024 10:37 AM
    3 Attachment(s)
    • 6
    • 123
    AliGW
    04-03-2024, 06:24 AM Go to last post

  13. [SOLVED] Combine Two UNIQUE Lists into one

    Started by RoscoW88‎, 04-03-2024 04:17 AM
    2 Attachment(s)
    • 4
    • 106
    AliGW
    04-03-2024, 05:00 AM Go to last post

  14. [SOLVED] Indented Bom Cost Roll Up Help

    Started by davidandrew23‎, 10-23-2012 03:32 PM
    3 Attachment(s)
    • 9
    • 6,998
    AliGW
    04-03-2024, 04:44 AM Go to last post

  15. [SOLVED] Highest No' Count " TRUE " value contaning contunuesly in columns

    Started by sbvaram‎, 04-03-2024 02:58 AM
    3 Attachment(s)
    • 4
    • 73
    AliGW
    04-03-2024, 03:16 AM Go to last post

  16. [SOLVED] Position of letter Q in these words

    Started by makinmomb‎, 04-01-2024 11:51 PM
    2 Attachment(s)
    • 9
    • 91
    AliGW
    04-03-2024, 02:51 AM Go to last post

  17. Dynamic Lookup That Omits Blank Rows In the Results

    Started by GeddB‎, 03-14-2024 11:59 PM
    complicated formula, dynamic array 2 Attachment(s)
    • 6
    • 170
    AliGW
    04-03-2024, 01:15 AM Go to last post

  18. Thumbs up [SOLVED] SLA Exclude non-working Days, Weekend & Public Holidays

    Started by Hyz‎, 09-07-2023 05:13 AM
    excel, excel formula 7 Attachment(s)
    • 6
    • 344
    Hyz
    04-03-2024, 01:12 AM Go to last post

  19. Searching range in second workbook for part number and returning value from specific cell

    Started by Hitman Hotrods‎, 04-02-2024 03:44 PM
    • 1
    • 54
    6StringJazzer
    04-02-2024, 10:23 PM Go to last post

  20. Equity drawdown recovery

    Started by kshagr24‎, 04-01-2024 01:05 PM
    bernie deitrick 1 Attachment(s)
    • 1
    • 77
    JeteMc
    04-02-2024, 08:06 PM Go to last post

  21. [SOLVED] Change Source of formulas to own workbook?

    Started by akedm‎, 04-02-2024 04:20 PM
    1 Attachment(s)
    • 5
    • 186
    TMS
    04-02-2024, 07:46 PM Go to last post

  22. [SOLVED] Help extracting values from cell

    Started by Newtonus_Prime‎, 04-02-2024 04:02 PM
    2 Attachment(s)
    • 7
    • 141
    TMS
    04-02-2024, 05:32 PM Go to last post

  23. IF formula Not working

    Started by BADebbie‎, 04-02-2024 05:08 PM
    • 1
    • 49
    TMS
    04-02-2024, 05:30 PM Go to last post

  24. Finding Max and Mins from Groups in a List

    Started by jcbrymesser‎, 04-02-2024 10:38 AM
    • 1
    • 68
    alansidman
    04-02-2024, 04:28 PM Go to last post

  25. Auto-populate a range with selected rows from a second range... But the NIGHTMARISH way!

    Started by PUPIXCELLIUM‎, 03-28-2024 09:48 PM
    2 Attachment(s)
    • 9
    • 155
    PUPIXCELLIUM
    04-02-2024, 04:08 PM Go to last post

  26. #N/A won't go away despite IFERROR/IFNA filters

    Started by guy1000‎, 04-01-2024 05:32 PM
    excel, formula, len 3 Attachment(s)
    • 9
    • 164
    guy1000
    04-02-2024, 03:41 PM Go to last post

  27. Extracting data from multiple cells/rows

    Started by Epixx1337‎, 04-02-2024 11:50 AM
    3 Attachment(s)
    • 1
    • 84
    Bernie Deitrick
    04-02-2024, 03:22 PM Go to last post

  28. Question Formula to count comma's within the cells of a column?

    Started by Fjmaniaci‎, 04-02-2024 01:04 PM
    #excel #formula
    • 3
    • 88
    Fluff13
    04-02-2024, 01:18 PM Go to last post

  29. [SOLVED] sumifs to add if there's a date

    Started by jomili‎, 04-02-2024 11:34 AM
    1 Attachment(s)
    • 3
    • 89
    Fluff13
    04-02-2024, 01:05 PM Go to last post

  30. [SOLVED] Calculate accurate weightings with upper limit

    Started by wasgeezy‎, 04-02-2024 11:05 AM
    1 Attachment(s)
    • 4
    • 75
    wasgeezy
    04-02-2024, 11:37 AM Go to last post

  31. [SOLVED] Adding data at the top (instead of the bottom)

    Started by jomili‎, 03-26-2024 09:39 AM
    3 Attachment(s)
    • 5
    • 122
    Bernie Deitrick
    04-02-2024, 11:29 AM Go to last post

  32. [SOLVED] Adding pounds and ounces

    Started by Irish steelhead jigs‎, 04-02-2024 08:32 AM
    2 Attachment(s)
    • 16
    • 130
    TMS
    04-02-2024, 11:17 AM Go to last post

  33. Sumproduct giving error

    Started by [email protected]‎, 04-02-2024 10:47 AM
    1 Attachment(s)
    • 2
    • 55
    CARACALLA
    04-02-2024, 11:17 AM Go to last post

  34. sumifs Indirect #Name Error

    Started by Peaky_Blinder‎, 04-02-2024 07:58 AM
    6 Attachment(s)
    • 24
    • 182
    AliGW
    04-02-2024, 11:10 AM Go to last post

  35. [SOLVED] Need to Query specific data from 2 tables

    Started by Newtonus_Prime‎, 03-29-2024 02:44 PM
    2 Attachment(s)
    • 5
    • 185
    JeteMc
    04-02-2024, 10:38 AM Go to last post

  36. [SOLVED] Filter formula returns #SPILL cells have #N/A values and blank values

    Started by varbergt‎, 04-02-2024 07:07 AM
    #spill, filter 2 Attachment(s)
    • 4
    • 84
    AliGW
    04-02-2024, 09:11 AM Go to last post

  37. [SOLVED] 2 IF formulas causing problems

    Started by varbergt‎, 04-02-2024 04:25 AM
    if formula, if formulas 3 Attachment(s)
    • 6
    • 91
    AliGW
    04-02-2024, 05:01 AM Go to last post

  38. [SOLVED] Formulas for Latest Service Details

    Started by billy60‎, 03-29-2024 10:42 AM
    8 Attachment(s)
    • 34
    • 288
    wk9128
    04-01-2024, 07:52 PM Go to last post

  39. [SOLVED] Conditional Formatting for Due Date

    Started by Kenny Yip‎, 03-24-2024 11:40 PM
    2 Attachment(s)
    • 9
    • 140
    wk9128
    04-01-2024, 07:51 PM Go to last post

  40. Sumifs not working after power query?

    Started by paulanderson‎, 04-01-2024 06:31 PM
    1 Attachment(s)
    • 2
    • 89
    wk9128
    04-01-2024, 07:49 PM Go to last post

  41. [SOLVED] Formula to work out the Invoice Due Date

    Started by jesteban‎, 04-01-2024 08:19 AM
    2 Attachment(s)
    • 7
    • 128
    etaf
    04-01-2024, 05:18 PM Go to last post

  42. [SOLVED] Data Validation with Ifs

    Started by Len Silva‎, 04-01-2024 02:42 PM
    2 Attachment(s)
    • 2
    • 69
    Len Silva
    04-01-2024, 04:28 PM Go to last post

  43. XLOOKUP a cell# with multiple columns return

    Started by ngbruno‎, 03-19-2024 02:15 PM
    3 Attachment(s)
    • 5
    • 165
    ngbruno
    04-01-2024, 02:11 PM Go to last post

  44. [SOLVED] Help with #NUM! error

    Started by SamStam‎, 03-28-2024 09:10 AM
    2 Attachment(s)
    • 6
    • 206
    SamStam
    04-01-2024, 12:38 PM Go to last post

  45. [SOLVED] Lookup and compare part numbers and quantities from 2 sheets

    Started by BryanP97‎, 04-01-2024 10:57 AM
    2 Attachment(s)
    • 1
    • 74
    etaf
    04-01-2024, 11:11 AM Go to last post

  46. Separating Data into different Columns

    Started by kookai21‎, 03-31-2024 09:09 AM
    5 Attachment(s)
    • 6
    • 152
    kvsrinivasamurthy
    04-01-2024, 10:43 AM Go to last post

  47. [SOLVED] sumif with <> in criteria

    Started by yllew‎, 02-28-2024 02:41 AM
    2 Attachment(s)
    • 5
    • 225
    yllew
    04-01-2024, 09:11 AM Go to last post

  48. Drawdown- calculate size and length of multiple drawdown phases (non-VBA)

    Started by chipps24‎, 02-02-2015 07:44 AM
    3 Attachment(s)
    • 20
    • 18,961
    AliGW
    04-01-2024, 09:06 AM Go to last post

  49. [SOLVED] Problems getting a column to SPILL down

    Started by Marvo‎, 04-01-2024 07:53 AM
    1 Attachment(s)
    • 6
    • 68
    Fluff13
    04-01-2024, 08:19 AM Go to last post

  50. [SOLVED] Conditional formatting to highlight percentages

    Started by viewotst‎, 03-29-2024 09:43 AM
    9 Attachment(s)
    • 13
    • 184
    viewotst
    04-01-2024, 08:15 AM Go to last post
+ Post New Thread
Page 10 of 5614 FirstFirst ... 10 ...

Forum Information and Options

Users Browsing this Forum

There are currently 120 users browsing this forum. (6 members & 114 guests)

  1. cat_oulala,
  2. Drexl27,
  3. JohnTopley,
  4. Newman85

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