+ Post New Thread
Page 1 of 5705 1 ...
Threads 1 to 50 of 285240

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

  1. Excel formula to derrive specific data from another sheet as per entries

    Started by arnabnestle‎, Today 02:08 AM
    1 Attachment(s)
    • 0
    • 5
    arnabnestle
    Today, 02:08 AM Go to last post

  2. Function for Conditional Formatting

    Started by sunriver61‎, Yesterday 05:41 PM
    2 Attachment(s)
    • 2
    • 52
    ORoos
    Today, 12:33 AM Go to last post

  3. Can VLOOKUP formula be used to return results for multiply different values found?

    Started by Smyth1‎, Yesterday 08:24 PM
    2 Attachment(s)
    • 2
    • 78
    alansidman
    Today, 12:16 AM Go to last post

  4. Dynamic Array Formula to Filter if Specific Test is Present

    Started by 77highland‎, Yesterday 01:13 PM
    filter, index, search, unique 1 Attachment(s)
    • 7
    • 110
    TMS
    Yesterday, 11:56 PM Go to last post

  5. Calculate cost per share

    Started by timbit1‎, Yesterday 07:29 PM
    2 Attachment(s)
    • 1
    • 47
    alansidman
    Yesterday, 11:47 PM Go to last post

  6. [SOLVED] Ignore #N/A from Filter(Filter)

    Started by 77highland‎, Yesterday 05:00 PM
    filter, hstack, iferr, iferror, ifna 1 Attachment(s)
    • 4
    • 53
    TMS
    Yesterday, 06:30 PM Go to last post

  7. Accumulating value over specfic start and end date with percentages

    Started by rsb1776‎, Yesterday 10:36 AM
    2 Attachment(s)
    • 5
    • 135
    6StringJazzer
    Yesterday, 03:59 PM Go to last post

  8. Help with Automatic Updates to Formulas

    Started by AnnCart10‎, Yesterday 12:14 PM
    1 Attachment(s)
    • 1
    • 72
    Bernie Deitrick
    Yesterday, 02:25 PM Go to last post

  9. Calculating product profit and margin

    Started by orangeco‎, 05-13-2025 04:07 PM
    2 Attachment(s)
    • 9
    • 189
    orangeco
    Yesterday, 01:54 PM Go to last post

  10. Lookup with closest date

    Started by nmau10‎, Yesterday 02:47 AM
    4 Attachment(s)
    • 6
    • 112
    FlameRetired
    Yesterday, 01:34 PM Go to last post

  11. FILTER ( ) with SEARCH ( )

    Started by Excel_vba‎, 05-15-2025 11:02 PM
    filter, index, iserror, match, search 1 Attachment(s)
    • 3
    • 96
    Excel_vba
    Yesterday, 12:20 PM Go to last post

  12. [SOLVED] Countif for Visible Columns only

    Started by DarrylBurge2‎, Yesterday 08:48 AM
    1 Attachment(s)
    • 12
    • 89
    TMS
    Yesterday, 12:04 PM Go to last post

  13. [SOLVED] Need sum for all months till chosen month

    Started by vijayca‎, Yesterday 10:50 AM
    1 Attachment(s)
    • 3
    • 71
    wk9128
    Yesterday, 11:36 AM Go to last post

  14. [SOLVED] VLOOKUP, pulling info from sheet2 & sheet3, to display on sheet1, from M13:NM13

    Started by galvinpaddy‎, Yesterday 09:44 AM
    • 10
    • 80
    cysu11
    Yesterday, 10:47 AM Go to last post

  15. [SOLVED] How to start from A List obtained B Column effect

    Started by choletseng‎, Yesterday 09:25 AM
    1 Attachment(s)
    • 3
    • 140
    wk9128
    Yesterday, 09:58 AM Go to last post

  16. [SOLVED] Sum up even numbers cumulatively and keep odd numbers constant

    Started by metrostar‎, Yesterday 09:14 AM
    1 Attachment(s)
    • 7
    • 103
    wk9128
    Yesterday, 09:57 AM Go to last post

  17. [SOLVED] Conditional formatting of dates as they grow old.

    Started by ChrisPudd‎, 05-13-2025 07:02 AM
    • 8
    • 124
    AliGW
    Yesterday, 09:48 AM Go to last post

  18. [SOLVED] Dynamic Array Formula to Remove Duplicates with Criteria

    Started by 77highland‎, 05-15-2025 08:38 PM
    filter, hstack, index, match, unique 1 Attachment(s)
    • 7
    • 117
    TMS
    Yesterday, 09:36 AM Go to last post

  19. [SOLVED] Highlight duplicate values within a column and exclude text

    Started by Michael Dee‎, 05-13-2025 10:09 AM
    2 Attachment(s)
    • 5
    • 116
    Michael Dee
    Yesterday, 09:21 AM Go to last post

  20. [SOLVED] Need help with a couple formulas and checkbox's in my sheet.

    Started by PTLS‎, 05-07-2025 06:12 AM
    11 Attachment(s)
    • 43
    • 919
    JeteMc
    Yesterday, 09:06 AM Go to last post

  21. [SOLVED] formula Extracting specific word from cell

    Started by amy_d2‎, Yesterday 02:28 AM
    1 Attachment(s)
    • 2
    • 59
    AliGW
    Yesterday, 02:47 AM Go to last post

  22. Status Grouping

    Started by chakkaravarthy.m‎, Yesterday 01:40 AM
    • 2
    • 67
    AliGW
    Yesterday, 02:07 AM Go to last post

  23. Status Grouping based on another column(Entity)

    Started by chakkaravarthy.m‎, Yesterday 01:55 AM
    1 Attachment(s)
    • 1
    • 54
    wk9128
    Yesterday, 01:57 AM Go to last post

  24. [SOLVED] Arrays using LEFT ( )

    Started by Excel_vba‎, 05-15-2025 02:01 PM
    array left 4 Attachment(s)
    • 15
    • 170
    TMS
    Yesterday, 12:58 AM Go to last post

  25. Changing 4.30 (4 hours 30 minutes) into 4.50 (4 hours 30 minutes)

    Started by Warmond‎, 05-14-2025 03:31 AM
    1 Attachment(s)
    • 5
    • 159
    Rick Rothstein
    05-15-2025, 10:37 PM Go to last post

  26. Dynamic Array to Return Selected Results with Matching Criteria

    Started by 77highland‎, 05-07-2025 11:22 AM
    filter, htack, index, sort 7 Attachment(s)
    • 23
    • 653
    Gregb11
    05-15-2025, 08:08 PM Go to last post

  27. Question [SOLVED] Formula help

    Started by dekueb‎, 05-15-2025 05:10 AM
    2 Attachment(s)
    • 3
    • 96
    wk9128
    05-15-2025, 07:20 PM Go to last post

  28. [SOLVED] I want to convert the result of a function to the actual number

    Started by Small Towne‎, 05-15-2025 12:13 PM
    3 Attachment(s)
    • 6
    • 142
    wk9128
    05-15-2025, 07:18 PM Go to last post

  29. How to create a dynamic formula range for a gantt chart

    Started by JulianS96‎, 05-15-2025 05:00 AM
    1 Attachment(s)
    • 2
    • 80
    6StringJazzer
    05-15-2025, 02:53 PM Go to last post

  30. [SOLVED] Formula to return lowest value of Unique Duplicates

    Started by JDarling‎, 05-14-2025 01:45 PM
    3 Attachment(s)
    • 8
    • 198
    TMS
    05-15-2025, 11:26 AM Go to last post

  31. How to pull the data with multiple validations

    Started by Merrysa‎, 05-15-2025 09:43 AM
    1 Attachment(s)
    • 1
    • 57
    JohnTopley
    05-15-2025, 09:57 AM Go to last post

  32. [SOLVED] Multiple "optional" filters

    Started by Bren123‎, 05-14-2025 09:52 AM
    2 Attachment(s)
    • 3
    • 108
    Bernie Deitrick
    05-15-2025, 09:48 AM Go to last post

  33. [SOLVED] Update paste-links year on year automatically?

    Started by Rroger_D‎, 05-11-2025 12:55 AM
    • 12
    • 151
    AliGW
    05-15-2025, 08:31 AM Go to last post

  34. [SOLVED] Skip values/cells that do not match

    Started by Excel0983‎, 05-15-2025 04:53 AM
    2 Attachment(s)
    • 3
    • 84
    windknife
    05-15-2025, 08:01 AM Go to last post

  35. [SOLVED] Formula Extract first non-Blank row below account number

    Started by Howardc1001‎, 05-14-2025 08:30 AM
    2 Attachment(s)
    • 6
    • 136
    wk9128
    05-15-2025, 06:59 AM Go to last post

  36. Copy formula to Cell based on another Cell Value

    Started by lewis94‎, 05-13-2025 08:46 AM
    1 Attachment(s)
    • 8
    • 188
    ByteMarks
    05-15-2025, 06:41 AM Go to last post

  37. How do you keep a formula constant when inserting a row in Excel?

    Started by chakkaravarthy.m‎, 05-15-2025 04:00 AM
    • 4
    • 58
    wk9128
    05-15-2025, 05:29 AM Go to last post

  38. [SOLVED] Find xx day of the month from a given date

    Started by L plates‎, 05-15-2025 04:21 AM
    1 Attachment(s)
    • 2
    • 62
    L plates
    05-15-2025, 05:01 AM Go to last post

  39. Forecasting using two different date ranges and forecast ratios

    Started by lguest‎, 05-15-2025 03:54 AM
    1 Attachment(s)
    • 3
    • 78
    djclements
    05-15-2025, 04:55 AM Go to last post

  40. [SOLVED] Using a Macro to base an action from a dynamic formula result in a column.

    Started by Sedge‎, 05-14-2025 02:11 PM
    • 3
    • 91
    Sedge
    05-14-2025, 06:12 PM Go to last post

  41. [SOLVED] Need help on Dget formula.

    Started by KEN05‎, 05-10-2025 05:35 AM
    2 Attachment(s)
    • 13
    • 566
    KEN05
    05-14-2025, 04:01 PM Go to last post

  42. [SOLVED] How to use a formula to calculate different lines

    Started by AceForSale‎, 05-14-2025 12:29 PM
    2 Attachment(s)
    • 3
    • 76
    etaf
    05-14-2025, 03:52 PM Go to last post

  43. IF statement - include another cell value in the reference string

    Started by sunriver61‎, 05-14-2025 02:50 PM
    • 1
    • 65
    JohnTopley
    05-14-2025, 02:56 PM Go to last post

  44. [SOLVED] Condition Base Formula Required

    Started by RUPESHRH‎, 05-13-2025 09:48 AM
    1 Attachment(s)
    • 12
    • 196
    JeteMc
    05-14-2025, 02:09 PM Go to last post

  45. Formula to evaluate software version numbers (if greater than X release)

    Started by ckhan84‎, 05-14-2025 11:00 AM
    2 Attachment(s)
    • 4
    • 99
    alansidman
    05-14-2025, 01:40 PM Go to last post

  46. Logic to delete Newest Date from custom sort Preferred Type

    Started by dluhut‎, 05-02-2025 12:11 PM
    6 Attachment(s)
    • 13
    • 667
    dluhut
    05-14-2025, 12:25 PM Go to last post

  47. Post [SOLVED] COUNTIF Formula for counting multiple criteria in one column

    Started by Trentdguy‎, 05-14-2025 09:35 AM
    countif 1 Attachment(s)
    • 2
    • 71
    Trentdguy
    05-14-2025, 10:10 AM Go to last post

  48. Alternative for Countifs

    Started by ruidon‎, 05-13-2025 03:02 PM
    • 7
    • 152
    ruidon
    05-14-2025, 07:58 AM Go to last post

  49. Various Condition Based Formula

    Started by RUPESHRH‎, 05-14-2025 05:55 AM
    1 Attachment(s)
    • 1
    • 55
    AliGW
    05-14-2025, 06:00 AM Go to last post

  50. query to pick the top five values for every stock for individual month

    Started by raja1964‎, 05-13-2025 01:12 PM
    3 Attachment(s)
    • 4
    • 101
    JohnTopley
    05-14-2025, 03:49 AM Go to last post
+ Post New Thread
Page 1 of 5705 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 748 users browsing this forum. (0 members & 748 guests)

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