+ Post New Thread
Page 1 of 5613 1 ...
Threads 1 to 50 of 280619

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

  1. How to find the no. of text values in one column depending on criteria in another column?

    Started by Tabbii‎, Today 03:55 PM
    3 Attachment(s)
    • 5
    • 63
    Estevaoba
    Today, 08:03 PM Go to last post

  2. IF Function to check if x date is before y date (not working)

    Started by Drexl27‎, Today 08:01 PM
    1 Attachment(s)
    • 0
    • 2
    Drexl27
    Today, 08:01 PM Go to last post

  3. Add (B) + (C) ; then add value to equal to = 19

    Started by 43Matt‎, Today 07:46 PM
    • 1
    • 13
    Pete_UK
    Today, 07:50 PM Go to last post

  4. Index and match to find a column number

    Started by tays01s‎, 04-17-2024 04:11 PM
    index, matach 3 Attachment(s)
    • 7
    • 129
    JeteMc
    Today, 07:15 PM Go to last post

  5. using vlookup to find different instances

    Started by jacc14‎, 04-21-2024 03:40 PM
    vlookup 4 Attachment(s)
    • 11
    • 144
    wk9128
    Today, 07:07 PM Go to last post

  6. Conditionally formatting question with checkboxes.

    Started by Tricks420‎, 04-20-2024 10:55 AM
    3 Attachment(s)
    • 6
    • 102
    Tricks420
    Today, 03:06 PM Go to last post

  7. Populate sheet with specific data from a different sheet

    Started by Valexana‎, Today 11:46 AM
    3 Attachment(s)
    • 1
    • 75
    Estevaoba
    Today, 02:56 PM Go to last post

  8. Logical Formula

    Started by Han_05‎, Today 09:56 AM
    1 Attachment(s)
    • 4
    • 87
    Han_05
    Today, 02:42 PM Go to last post

  9. Lightbulb summation based on multiple criterias from different sheets with indirect function

    Started by sanjuss2‎, 04-19-2024 11:27 AM
    2 Attachment(s)
    • 1
    • 76
    JeteMc
    Today, 01:59 PM Go to last post

  10. Complex Scheduling in Excel

    Started by evee‎, Today 12:33 AM
    schedule generator, schedules, scheduling with excel 2 Attachment(s)
    • 5
    • 125
    Hydraulics
    Today, 01:55 PM Go to last post

  11. OFFSET formula for dynamic range

    Started by Stuepef‎, Today 11:39 AM
    counta, dynamic range, dynamic range for row, offset formula 1 Attachment(s)
    • 1
    • 49
    Estevaoba
    Today, 01:46 PM Go to last post

  12. Question How to calculate the diameter of a sprial.

    Started by SjofaaSj‎, Today 08:02 AM
    3 Attachment(s)
    • 6
    • 100
    Pete_UK
    Today, 01:36 PM Go to last post

  13. Force user to delete content of cell

    Started by KerahJoy‎, Today 09:59 AM
    clear, data validation, new data
    • 2
    • 51
    KerahJoy
    Today, 12:35 PM Go to last post

  14. How to count a specific phrase in an array using sumproduct with criteria

    Started by Fuddy_Duddy‎, Today 12:24 PM
    • 1
    • 28
    TMS
    Today, 12:31 PM Go to last post

  15. mathing / look up formula help

    Started by rhino80‎, Today 04:13 AM
    3 Attachment(s)
    • 6
    • 85
    TMS
    Today, 12:27 PM Go to last post

  16. [SOLVED] Need Help Merging Formulas

    Started by Destyn‎, Yesterday 05:03 PM
    • 4
    • 86
    Destyn
    Today, 12:17 PM Go to last post

  17. Filter Function issue

    Started by oneblondebrow‎, Today 11:26 AM
    2 Attachment(s)
    • 3
    • 45
    etaf
    Today, 12:09 PM Go to last post

  18. Question [SOLVED] Summing up Supplier amounts from the same column

    Started by Dazzastark‎, Yesterday 10:49 AM
    2 Attachment(s)
    • 7
    • 107
    alansidman
    Today, 11:59 AM Go to last post

  19. Help Extracting Specific Text From Inconsistent Text Strings

    Started by ZANDRY10085‎, 04-16-2024 07:56 PM
    5 Attachment(s)
    • 10
    • 181
    ZANDRY10085
    Today, 11:57 AM Go to last post

  20. [SOLVED] Conditional Formatting to highlight one row based on *text* in other cells

    Started by SeoulGal‎, Today 03:52 AM
    • 9
    • 77
    Pete_UK
    Today, 11:49 AM Go to last post

  21. [SOLVED] TOCOL function to show non-zero values only?

    Started by Efendi‎, Today 07:54 AM
    filter, tocol 4 Attachment(s)
    • 8
    • 73
    Czeslaw
    Today, 10:02 AM Go to last post

  22. Power Query - Extract data from worksheet

    Started by Kenny Yip‎, Today 04:46 AM
    1 Attachment(s)
    • 1
    • 57
    alansidman
    Today, 09:42 AM Go to last post

  23. Listing data from one sheet to another while liming number of entries

    Started by bekwiet‎, 04-19-2024 11:32 PM
    6 Attachment(s)
    • 19
    • 147
    JeteMc
    Today, 09:07 AM Go to last post

  24. Question Returning a list of parts from reference date

    Started by miribilist123‎, 03-26-2024 12:57 PM
    multi tab, referencing data, vlookup 3 Attachment(s)
    • 4
    • 90
    AliGW
    Today, 08:36 AM Go to last post

  25. Data Validation based on another data validation

    Started by miribilist123‎, Today 07:57 AM
    1 Attachment(s)
    • 3
    • 61
    AliGW
    Today, 08:33 AM Go to last post

  26. [SOLVED] The problem of cumulative sum of merging units

    Started by metrostar‎, 04-21-2024 10:06 AM
    4 Attachment(s)
    • 7
    • 203
    kvsrinivasamurthy
    Today, 07:54 AM Go to last post

  27. [SOLVED] Convert different rows to one column

    Started by geniusufo007‎, Today 03:58 AM
    2 Attachment(s)
    • 10
    • 86
    Czeslaw
    Today, 07:49 AM Go to last post

  28. [SOLVED] Increment number based on Location 2

    Started by josephteh‎, Yesterday 10:52 AM
    2 Attachment(s)
    • 6
    • 91
    Fluff13
    Today, 06:31 AM Go to last post

  29. How to calculate best numbers 3 i a certain rank or order (european championship)

    Started by gittermaster‎, 05-14-2016 02:02 PM
    8 Attachment(s)
    • 9
    • 1,028
    Kaper
    Today, 06:15 AM Go to last post

  30. [SOLVED] =INDEX dependent on value in cell

    Started by DarrylBurge‎, 04-19-2024 06:47 AM
    3 Attachment(s)
    • 6
    • 105
    DarrylBurge
    Today, 05:56 AM Go to last post

  31. [SOLVED] Using excel professional plus 2021 for Microsoft 365 function

    Started by geniusufo007‎, Today 03:32 AM
    1 Attachment(s)
    • 6
    • 62
    AliGW
    Today, 04:24 AM Go to last post

  32. Moved: Radar chart help (I tried)

    Started by MattExcelLearner‎, Today 03:02 AM
    •  
    •  

  33. Single Value Arrays and DROP

    Started by Glenn Kennedy‎, Yesterday 01:05 PM
    3 Attachment(s)
    • 4
    • 87
    AliGW
    Today, 02:50 AM Go to last post

  34. [SOLVED] Drop down list hides used items

    Started by edriks‎, Yesterday 09:54 AM
    3 Attachment(s)
    • 6
    • 73
    AliGW
    Today, 02:28 AM Go to last post

  35. [SOLVED] Continue to my last Thread discussion

    Started by Friend1‎, 04-19-2024 02:33 PM
    3 Attachment(s)
    • 5
    • 128
    windknife
    Yesterday, 09:47 PM Go to last post

  36. Match two criteria in two columns

    Started by alo2279‎, 04-18-2024 09:34 PM
    3 Attachment(s)
    • 4
    • 96
    windknife
    Yesterday, 09:46 PM Go to last post

  37. [SOLVED] To Only show result if 3 criteria is met.

    Started by FT00‎, Yesterday 01:03 PM
    2 Attachment(s)
    • 2
    • 60
    FT00
    Yesterday, 09:44 PM Go to last post

  38. [SOLVED] part of formula from drop down option

    Started by Excl3454‎, Yesterday 05:50 PM
    choice menu, formula, replace 2 Attachment(s)
    • 3
    • 81
    wk9128
    Yesterday, 09:02 PM Go to last post

  39. Post [SOLVED] IF Value(text) = duplicate then return Value(text) -1 -2 -3

    Started by RickVB‎, 04-19-2024 09:58 AM
    1 Attachment(s)
    • 6
    • 81
    wk9128
    Yesterday, 08:36 PM Go to last post

  40. [SOLVED] DATEDIF Being Inconsistent

    Started by Drexl27‎, Yesterday 05:13 PM
    2 Attachment(s)
    • 2
    • 55
    Drexl27
    Yesterday, 06:48 PM Go to last post

  41. [SOLVED] Function to join cells text together

    Started by Jay325‎, Yesterday 06:22 PM
    1 Attachment(s)
    • 3
    • 46
    TMS
    Yesterday, 06:44 PM Go to last post

  42. [SOLVED] Formula to insert text into a table looking at time/location

    Started by Jay325‎, 04-21-2024 06:08 PM
    4 Attachment(s)
    • 13
    • 99
    TMS
    Yesterday, 06:34 PM Go to last post

  43. [SOLVED] Enforce a Date Format 'yyyy-mm-dd' onto a Column in a .csv file.

    Started by noboffinme‎, 04-21-2024 09:08 PM
    • 6
    • 89
    noboffinme
    Yesterday, 05:33 PM Go to last post

  44. Red face Formula for if a value is above, below or within a range

    Started by elly_gallio‎, 05-30-2015 02:54 PM
    formula assistance
    • 5
    • 2,425
    bearlythere
    Yesterday, 05:03 PM Go to last post

  45. unauthorized changes - not by me- to linked S.S.

    Started by glynhunt‎, Yesterday 02:41 PM
    • 1
    • 53
    6StringJazzer
    Yesterday, 03:08 PM Go to last post

  46. Post excel formula not returns to right value

    Started by Zaid3010‎, 04-20-2024 11:43 PM
    1 Attachment(s)
    • 5
    • 96
    TMS
    Yesterday, 02:51 PM Go to last post

  47. [SOLVED] FALSE result from deeply nested IF formula

    Started by Apaka‎, 04-21-2024 04:40 PM
    3 Attachment(s)
    • 17
    • 131
    AliGW
    Yesterday, 12:17 PM Go to last post

  48. [SOLVED] Use XMATCH and XLOOKUP To Find Result In Dynamic Range

    Started by JN831‎, Yesterday 11:13 AM
    2 Attachment(s)
    • 5
    • 65
    Fluff13
    Yesterday, 11:56 AM Go to last post

  49. [SOLVED] trying to return a value using Xlookup and match from a price table

    Started by iks181‎, 04-21-2024 01:12 PM
    xlookup 1 Attachment(s)
    • 7
    • 82
    TMS
    Yesterday, 11:02 AM Go to last post

  50. [SOLVED] lookup a value, but need two identifiers

    Started by Edward Hyde‎, 04-18-2024 10:25 AM
    5 Attachment(s)
    • 18
    • 191
    TMS
    Yesterday, 10:49 AM Go to last post
+ Post New Thread
Page 1 of 5613 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 71 users browsing this forum. (3 members & 68 guests)

  1. 43Matt,
  2. Drexl27,
  3. Estevaoba

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