+ Post New Thread
Page 53 of 5619 FirstFirst ... 53 ...
Threads 2601 to 2650 of 280927

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

  1. how to automatically change cell value in a drop down list depending on another

    Started by TAWAB‎, 12-27-2023 06:20 AM
    • 3
    • 154
    BadlySpelledBuoy
    12-27-2023, 06:41 AM Go to last post

  2. How to combine 2 different filter formula from 2 different sheets

    Started by GoldenChicken‎, 12-27-2023 03:43 AM
    1 Attachment(s)
    • 3
    • 302
    AliGW
    12-27-2023, 04:41 AM Go to last post

  3. list all values that begin with a specific letter

    Started by rewmel‎, 12-24-2023 05:15 PM
    5 Attachment(s)
    • 13
    • 420
    rewmel
    12-27-2023, 02:45 AM Go to last post

  4. [SOLVED] Hyperlink address no longer valid

    Started by emthau‎, 12-25-2023 09:47 AM
    2 Attachment(s)
    • 3
    • 506
    ORoos
    12-26-2023, 11:41 PM Go to last post

  5. [SOLVED] Conditional Format For Date Falling In between 2 Dates

    Started by Abdur_rahman‎, 12-19-2023 11:29 AM
    2 Attachment(s)
    • 6
    • 587
    JeteMc
    12-26-2023, 07:54 PM Go to last post

  6. [SOLVED] If(and

    Started by jlschae154‎, 12-26-2023 01:41 PM
    1 Attachment(s)
    • 5
    • 224
    Pete_UK
    12-26-2023, 03:30 PM Go to last post

  7. Auto-populating formulas and Data Validation based on 1 cell's data validation result

    Started by Newtonus_Prime‎, 12-26-2023 10:58 AM
    1 Attachment(s)
    • 1
    • 195
    DJunqueira
    12-26-2023, 11:38 AM Go to last post

  8. Summation of multiple sequences

    Started by wsed2468‎, 12-26-2023 01:42 AM
    3 Attachment(s)
    • 12
    • 275
    windknife
    12-26-2023, 06:06 AM Go to last post

  9. [SOLVED] Function to extract string

    Started by sharathnarayanan‎, 12-26-2023 02:14 AM
    3 Attachment(s)
    • 8
    • 223
    HansDouwe
    12-26-2023, 03:26 AM Go to last post

  10. [SOLVED] Function to remove last two digits

    Started by sharathnarayanan‎, 12-26-2023 02:04 AM
    1 Attachment(s)
    • 8
    • 217
    sharathnarayanan
    12-26-2023, 03:13 AM Go to last post

  11. Trying to get data from a spreadsheet and break it down per customer and per tech.

    Started by ghurty‎, 12-25-2023 12:08 PM
    9 Attachment(s)
    • 21
    • 427
    HansDouwe
    12-25-2023, 10:11 PM Go to last post

  12. [SOLVED] How to detect duplicates using a formula?

    Started by rizwanulhasan‎, 12-21-2023 11:35 PM
    3 Attachment(s)
    • 46
    • 665
    HansDouwe
    12-25-2023, 07:15 AM Go to last post

  13. How to remove passward

    Started by btparkhe1920‎, 12-25-2023 03:10 AM
    1 Attachment(s)
    • 1
    • 138
    AliGW
    12-25-2023, 03:30 AM Go to last post

  14. Bond portfolio automation

    Started by ireadbooks2‎, 12-22-2023 08:11 PM
    5 Attachment(s)
    • 14
    • 909
    DJunqueira
    12-25-2023, 02:29 AM Go to last post

  15. [SOLVED] Excel Formula to check if the date fall inbetween 2 dates

    Started by Abdur_rahman‎, 12-18-2023 10:31 AM
    3 Attachment(s)
    • 11
    • 310
    Abdur_rahman
    12-25-2023, 01:18 AM Go to last post

  16. formula if

    Started by xam99‎, 12-24-2023 05:52 PM
    • 3
    • 199
    HansDouwe
    12-24-2023, 06:27 PM Go to last post

  17. [SOLVED] list all values that begin with a specific letter

    Started by Andy Swain‎, 12-18-2018 05:32 AM
    1 Attachment(s)
    • 11
    • 549
    AliGW
    12-24-2023, 04:46 PM Go to last post

  18. [SOLVED] V-lookup & H-lookup combo: find the day

    Started by megabolic‎, 12-24-2023 08:49 AM
    2 Attachment(s)
    • 6
    • 204
    Glenn Kennedy
    12-24-2023, 12:51 PM Go to last post

  19. Question [SOLVED] dynamic link to an other workbook by changing the name in a cell

    Started by SimplyS‎, 12-24-2023 10:36 AM
    dynamic links
    • 3
    • 217
    SimplyS
    12-24-2023, 12:18 PM Go to last post

  20. [SOLVED] Matrix sorted from smallest number to biggest number

    Started by cahayagalax‎, 12-23-2023 03:06 PM
    4 Attachment(s)
    • 17
    • 270
    JohnTopley
    12-24-2023, 05:34 AM Go to last post

  21. [SOLVED] Array multiplication

    Started by Ekac‎, 12-23-2023 03:50 AM
    7 Attachment(s)
    • 15
    • 399
    HansDouwe
    12-24-2023, 02:51 AM Go to last post

  22. Solver LPX

    Started by genzia‎, 12-15-2023 01:35 PM
    1 Attachment(s)
    • 3
    • 266
    Alf
    12-24-2023, 02:06 AM Go to last post

  23. Need a formula to calculate the (imperial) weight of steel plate

    Started by spencergraves13‎, 05-19-2015 09:33 AM
    formula, plate, spreadsheet, steel plate 2 Attachment(s)
    • 5
    • 5,533
    6StringJazzer
    12-23-2023, 07:04 PM Go to last post

  24. Iteration

    Started by graiggoriz‎, 12-20-2023 02:29 PM
    1 Attachment(s)
    • 2
    • 209
    JeteMc
    12-23-2023, 02:57 PM Go to last post

  25. [SOLVED] Match with Prefix

    Started by FT00‎, 12-22-2023 12:08 AM
    2 Attachment(s)
    • 9
    • 216
    windknife
    12-23-2023, 12:20 PM Go to last post

  26. Combine Designation For Individual-Data Is Spread Among Multiple Cells

    Started by Varun338195‎, 12-23-2023 09:52 AM
    4 Attachment(s)
    • 11
    • 215
    Varun338195
    12-23-2023, 12:14 PM Go to last post

  27. [SOLVED] Understanding a formula

    Started by Len Silva‎, 12-22-2023 11:44 AM
    4 Attachment(s)
    • 5
    • 186
    6StringJazzer
    12-23-2023, 11:18 AM Go to last post

  28. Need help with creation of price formula

    Started by neuri‎, 12-19-2023 03:33 AM
    1 Attachment(s)
    • 4
    • 241
    JeteMc
    12-23-2023, 11:13 AM Go to last post

  29. [SOLVED] Copy the cell content as text and not as formula value

    Started by boninm‎, 12-23-2023 08:54 AM
    1 Attachment(s)
    • 3
    • 129
    JohnTopley
    12-23-2023, 10:08 AM Go to last post

  30. [SOLVED] Required Conditional formating in Excel

    Started by RUPESHRH‎, 12-23-2023 02:29 AM
    5 Attachment(s)
    • 12
    • 221
    AliGW
    12-23-2023, 09:37 AM Go to last post

  31. Conditional Formatting and Protected Locked Cells Not Working

    Started by TheNateDog‎, 12-20-2023 08:00 PM
    conditional formatting, formulas, lock cell, lock column, protected cells 2 Attachment(s)
    • 8
    • 276
    Gregb11
    12-23-2023, 08:19 AM Go to last post

  32. [SOLVED] Pulls names from list in order

    Started by jeffreybrown‎, 12-23-2023 03:59 AM
    2 Attachment(s)
    • 2
    • 186
    jeffreybrown
    12-23-2023, 04:19 AM Go to last post

  33. [SOLVED] Hyperlink in custom list drop-down list under data validation

    Started by Etax‎, 12-18-2023 10:58 PM
    7 Attachment(s)
    • 17
    • 517
    Etax
    12-23-2023, 02:53 AM Go to last post

  34. Question Convert * with / in formula Excel for calculations to change results

    Started by Muhammad Farooq Mirz‎, 12-23-2023 02:05 AM
    "* to / in excel", "convert formula value", excel formula character
    • 1
    • 105
    AliGW
    12-23-2023, 02:11 AM Go to last post

  35. Allow excel to read a rounded number as a whole number in a table?

    Started by Kenbat‎, 12-22-2023 08:30 AM
    lookup, lookup 2 value in table, roundup 5 Attachment(s)
    • 8
    • 341
    josephteh
    12-22-2023, 11:51 PM Go to last post

  36. INDEX-MATCH formula not working

    Started by Drexl27‎, 12-22-2023 08:07 PM
    1 Attachment(s)
    • 6
    • 168
    TMS
    12-22-2023, 09:16 PM Go to last post

  37. [SOLVED] Is there a way to loop through an Index/Match formula

    Started by Excel987‎, 12-22-2023 05:45 PM
    2 Attachment(s)
    • 5
    • 385
    Excel987
    12-22-2023, 07:57 PM Go to last post

  38. Smile [SOLVED] Matching Leave Requests to a Rota

    Started by cmarchant97‎, 12-22-2023 03:57 PM
    index, lookup, match
    • 1
    • 158
    Pete_UK
    12-22-2023, 07:30 PM Go to last post

  39. [SOLVED] What is happening with this formula?

    Started by Venomous Duck‎, 12-21-2023 01:15 PM
    • 9
    • 322
    cwayneu
    12-22-2023, 05:23 PM Go to last post

  40. [SOLVED] Need formula to show a current department for employee

    Started by PitchNinja‎, 12-22-2023 03:49 PM
    2 Attachment(s)
    • 4
    • 186
    DJunqueira
    12-22-2023, 04:38 PM Go to last post

  41. Formula to Make Calculation Based on Items Selected

    Started by Erik G‎, 12-22-2023 01:37 PM
    1 Attachment(s)
    • 4
    • 169
    Estevaoba
    12-22-2023, 02:24 PM Go to last post

  42. [SOLVED] [Power Query] Looking at the previous week's value in a conditional column

    Started by DizerX‎, 12-21-2023 08:05 AM
    demand, excel, power query, risk, weeks 5 Attachment(s)
    • 10
    • 306
    DJunqueira
    12-22-2023, 01:47 PM Go to last post

  43. Formula to populate column based on criteria from 2 different columns

    Started by casian11art‎, 12-22-2023 08:03 AM
    2 Attachment(s)
    • 3
    • 111
    HansDouwe
    12-22-2023, 12:41 PM Go to last post

  44. [SOLVED] Index and Match with multiple criteria and wild card?

    Started by jbaich‎, 12-21-2023 07:15 PM
    index, match, multiple criteria, or condition
    • 2
    • 358
    TMS
    12-22-2023, 11:19 AM Go to last post

  45. DAX measure to calculate the percentage change in stock price

    Started by The_Snook‎, 12-20-2023 12:51 PM
    2 Attachment(s)
    • 2
    • 235
    The_Snook
    12-22-2023, 11:15 AM Go to last post

  46. Question Formula that auto increments filename from linked workbook

    Started by Anna198143‎, 12-21-2023 08:04 AM
    1 Attachment(s)
    • 5
    • 156
    DJunqueira
    12-22-2023, 09:15 AM Go to last post

  47. Group by ID and Sort by Highest first & Export thebest from each group

    Started by no9kris‎, 12-22-2023 05:53 AM
    export #macro to export, group by column, order and rearranging 3 Attachment(s)
    • 2
    • 193
    no9kris
    12-22-2023, 09:14 AM Go to last post

  48. Custom number format to show trend

    Started by bhenlee‎, 12-22-2023 08:00 AM
    1 Attachment(s)
    • 2
    • 126
    HansDouwe
    12-22-2023, 09:07 AM Go to last post

  49. Need to return Friday as Start of the week

    Started by bhenlee‎, 12-22-2023 06:46 AM
    • 6
    • 216
    HansDouwe
    12-22-2023, 08:11 AM Go to last post

  50. Dynamically change Table name in Formula based on cell reference

    Started by WaylettChris‎, 12-22-2023 07:19 AM
    dynamic table; lookup
    • 2
    • 214
    Glenn Kennedy
    12-22-2023, 07:48 AM Go to last post
+ Post New Thread
Page 53 of 5619 FirstFirst ... 53 ...

Forum Information and Options

Users Browsing this Forum

There are currently 64 users browsing this forum. (0 members & 64 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