+ Post New Thread
Page 1 of 5699 1 ...
Threads 1 to 50 of 284913

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

  1. Match closest value using two cells.

    Started by Louise1998Excel‎, 04-02-2025 09:57 AM
    4 Attachment(s)
    • 8
    • 225
    Louise1998Excel
    Today, 04:36 AM Go to last post

  2. [SOLVED] Turn Text (numbers) to Date

    Started by Frick‎, Yesterday 03:56 PM
    1 Attachment(s)
    • 11
    • 112
    Czeslaw
    Today, 02:02 AM Go to last post

  3. Replacing A Result with Alternative Text, Calculating FICA & Splitting Time by Period

    Started by Dexter2‎, 03-23-2025 09:23 PM
    7 Attachment(s)
    • 16
    • 524
    Dexter2
    Today, 12:53 AM Go to last post

  4. Check box or Radio Button when selected will provide current date and time

    Started by Frick‎, Yesterday 05:42 PM
    2 Attachment(s)
    • 3
    • 68
    protonLeah
    Today, 12:09 AM Go to last post

  5. Excel Solver Help

    Started by tepgor‎, 03-29-2025 11:36 PM
    3 Attachment(s)
    • 3
    • 237
    6StringJazzer
    Yesterday, 11:06 PM Go to last post

  6. Changing a negative number into a positive umber

    Started by LAWitcher‎, 03-28-2025 11:21 AM
    2 Attachment(s)
    • 9
    • 260
    6StringJazzer
    Yesterday, 11:02 PM Go to last post

  7. [SOLVED] Dependent drop down lists with duplicate values

    Started by a2424‎, 04-02-2025 06:07 AM
    4 Attachment(s)
    • 8
    • 233
    windknife
    Yesterday, 10:54 PM Go to last post

  8. Help with Index/Match Formula

    Started by narrowgate88‎, Yesterday 05:30 PM
    1 Attachment(s)
    • 5
    • 70
    Gregb11
    Yesterday, 10:47 PM Go to last post

  9. [SOLVED] CHOOSE Function Help

    Started by SqueekyWheel‎, Yesterday 08:13 PM
    2 Attachment(s)
    • 4
    • 92
    Adtxc
    Yesterday, 10:43 PM Go to last post

  10. [SOLVED] identify anyone without a learning assigned in previous 12 month period

    Started by Stehop61‎, Yesterday 02:19 PM
    4 Attachment(s)
    • 9
    • 124
    MarvinP
    Yesterday, 06:22 PM Go to last post

  11. Moved: fonction SOMME_SI_COULEUR

    Started by Fred94‎, Yesterday 04:53 PM
    •  
    •  

  12. Help pulling data from multiple workbooks

    Started by EleK74‎, 04-02-2025 01:26 PM
    help a noob 2 Attachment(s)
    • 6
    • 175
    Bernie Deitrick
    Yesterday, 09:20 AM Go to last post

  13. [SOLVED] Help with Lookup Formula

    Started by SqueekyWheel‎, 04-02-2025 08:51 PM
    2 Attachment(s)
    • 4
    • 138
    SqueekyWheel
    04-02-2025, 10:00 PM Go to last post

  14. Power Query nth day of the Month Based on date and Day of Week

    Started by alo2279‎, 04-02-2025 02:41 PM
    1 Attachment(s)
    • 1
    • 89
    MarvinP
    04-02-2025, 03:57 PM Go to last post

  15. [SOLVED] How to Retun Only One Match from Two Tables

    Started by ClericalOfficer‎, 04-02-2025 11:31 AM
    2 Attachment(s)
    • 16
    • 146
    TMS
    04-02-2025, 12:33 PM Go to last post

  16. [SOLVED] Need help making this formula recognize YEAR when filtering data

    Started by Newtonus_Prime‎, 04-01-2025 02:26 PM
    • 3
    • 161
    6StringJazzer
    04-02-2025, 12:21 PM Go to last post

  17. Custom Data Validation

    Started by stu_C‎, 04-02-2025 05:54 AM
    • 3
    • 141
    6StringJazzer
    04-02-2025, 09:59 AM Go to last post

  18. Post Possible to have a single cell updated with latest currency conversion on monthly sheets?

    Started by Spondoosh‎, 04-02-2025 07:50 AM
    1 Attachment(s)
    • 2
    • 91
    Spondoosh
    04-02-2025, 09:34 AM Go to last post

  19. [SOLVED] Sum till there is change in sign

    Started by goodboy‎, 04-02-2025 08:00 AM
    2 Attachment(s)
    • 3
    • 87
    JohnTopley
    04-02-2025, 08:42 AM Go to last post

  20. Date being replaced by text in monthly financial period but still acting as a date

    Started by patakfrite‎, 04-01-2025 06:01 PM
    2 Attachment(s)
    • 4
    • 142
    patakfrite
    04-02-2025, 07:49 AM Go to last post

  21. Conver text to numbers to sum in excel

    Started by DimitrisPap‎, 04-02-2025 03:59 AM
    3 Attachment(s)
    • 4
    • 126
    Czeslaw
    04-02-2025, 06:57 AM Go to last post

  22. Pour words on a and b vs criteria on a1 and b1

    Started by makinmomb‎, 04-01-2025 12:21 PM
    6 Attachment(s)
    • 13
    • 175
    JohnTopley
    04-02-2025, 03:51 AM Go to last post

  23. [SOLVED] Works except for last two rows

    Started by rafcaf‎, 04-01-2025 09:03 PM
    1 Attachment(s)
    • 1
    • 105
    6StringJazzer
    04-01-2025, 09:41 PM Go to last post

  24. [SOLVED] Search for repeating names in a range of cells

    Started by Reiner94‎, 04-01-2025 01:36 PM
    2 Attachment(s)
    • 3
    • 126
    Reiner94
    04-01-2025, 05:18 PM Go to last post

  25. Help with Index and Match

    Started by greentea‎, 04-01-2025 12:48 PM
    2 Attachment(s)
    • 3
    • 116
    6StringJazzer
    04-01-2025, 03:21 PM Go to last post

  26. [SOLVED] Sum a range of column rows using index/match

    Started by iantix‎, 03-30-2025 09:51 AM
    6 Attachment(s)
    • 26
    • 399
    TMS
    04-01-2025, 12:52 PM Go to last post

  27. [SOLVED] create space on phone numbers

    Started by makinmomb‎, 04-01-2025 04:14 AM
    • 5
    • 110
    popipipo
    04-01-2025, 12:17 PM Go to last post

  28. [SOLVED] Lookup and total sum based upon 2 criteria

    Started by mrguinness‎, 04-01-2025 11:50 AM
    2 Attachment(s)
    • 4
    • 102
    AliGW
    04-01-2025, 12:17 PM Go to last post

  29. Drop-Down List - Subsequent cells are driven by drop down list

    Started by tacnola‎, 03-31-2025 03:24 PM
    2 Attachment(s)
    • 6
    • 156
    MarvinP
    04-01-2025, 10:51 AM Go to last post

  30. [SOLVED] find a value in a 13 x 4 table, return column number

    Started by Ozzie22‎, 04-01-2025 09:57 AM
    1 Attachment(s)
    • 11
    • 115
    Fluff13
    04-01-2025, 10:32 AM Go to last post

  31. [SOLVED] Conditional Formatting - mark last non zero in a row

    Started by Cards1‎, 03-20-2025 09:12 AM
    5 Attachment(s)
    • 14
    • 216
    AliGW
    04-01-2025, 09:58 AM Go to last post

  32. [SOLVED] How to get the automatic score

    Started by arindamsenaxa‎, 04-01-2025 05:28 AM
    excel formula, formula, mis-matched 1 Attachment(s)
    • 6
    • 123
    AliGW
    04-01-2025, 07:27 AM Go to last post

  33. Want to arrange identical name in a left column

    Started by UZR1‎, 03-27-2025 07:16 AM
    3 Attachment(s)
    • 10
    • 276
    TMS
    03-31-2025, 08:26 PM Go to last post

  34. [SOLVED] Help with Statistic Formula

    Started by SqueekyWheel‎, 03-29-2025 01:06 PM
    1 Attachment(s)
    • 5
    • 220
    TMS
    03-31-2025, 06:08 PM Go to last post

  35. [SOLVED] Simple formula. Hopefully a simple solution

    Started by Falksdw‎, 03-31-2025 12:48 PM
    #value error, formula advice
    • 5
    • 128
    TMS
    03-31-2025, 03:14 PM Go to last post

  36. Question Calendar

    Started by robsonslz‎, 03-31-2025 12:15 PM
    3 Attachment(s)
    • 2
    • 118
    6StringJazzer
    03-31-2025, 01:57 PM Go to last post

  37. [SOLVED] phone number organise

    Started by makinmomb‎, 03-31-2025 10:55 AM
    1 Attachment(s)
    • 4
    • 130
    Czeslaw
    03-31-2025, 12:22 PM Go to last post

  38. [SOLVED] Formula to calculate cash out by weeks

    Started by Dbbfes‎, 03-31-2025 05:37 AM
    2 Attachment(s)
    • 3
    • 170
    JeteMc
    03-31-2025, 11:42 AM Go to last post

  39. Highlight row for every first unique value

    Started by Kennethc‎, 03-31-2025 09:25 AM
    1 Attachment(s)
    • 8
    • 137
    6StringJazzer
    03-31-2025, 11:01 AM Go to last post

  40. [SOLVED] Conditional Formatting - Copy across columns/Rows

    Started by Wilgoss‎, 03-31-2025 03:22 AM
    2 Attachment(s)
    • 3
    • 101
    etaf
    03-31-2025, 04:34 AM Go to last post

  41. Power Query - Seeking for the support to group the rows

    Started by noorsadhik‎, 03-24-2025 02:19 PM
    2 Attachment(s)
    • 6
    • 166
    JeteMc
    03-30-2025, 11:33 PM Go to last post

  42. Revenue Calc for Active Projects Using a Number of Months For The Duration

    Started by Accountant89‎, 03-28-2025 05:30 PM
    4 Attachment(s)
    • 7
    • 245
    JeteMc
    03-30-2025, 09:24 PM Go to last post

  43. VLOOKUP - #N/A ERROR file list of pics - match with Alt Text for same pic list

    Started by RECS-1958‎, 03-30-2025 07:21 AM
    vlookup #na 2 Attachment(s)
    • 2
    • 141
    Pete_UK
    03-30-2025, 11:15 AM Go to last post

  44. What is VLOOKUP?

    Started by slc1992‎, 03-28-2025 11:16 PM
    • 2
    • 133
    6StringJazzer
    03-29-2025, 12:16 PM Go to last post

  45. [SOLVED] reshuffling over blank cell in a row

    Started by UZR1‎, 03-29-2025 04:19 AM
    2 Attachment(s)
    • 5
    • 156
    djclements
    03-29-2025, 11:28 AM Go to last post

  46. help with formula

    Started by ozil‎, 03-28-2025 01:15 PM
    1 Attachment(s)
    • 9
    • 355
    AliGW
    03-29-2025, 10:36 AM Go to last post

  47. [SOLVED] Sum IFs

    Started by arrowmaker100‎, 03-28-2025 11:18 AM
    1 Attachment(s)
    • 4
    • 163
    popipipo
    03-29-2025, 06:24 AM Go to last post

  48. Change a number into a date

    Started by Frick‎, 03-17-2025 02:13 PM
    1 Attachment(s)
    • 5
    • 165
    Czeslaw
    03-29-2025, 01:26 AM Go to last post

  49. make model and year formula using VIN and data tables

    Started by nlogan85‎, 03-27-2025 06:06 PM
    3 Attachment(s)
    • 16
    • 333
    TMS
    03-28-2025, 07:42 PM Go to last post

  50. [SOLVED] Change column E (Amount (Foreign Currency)) into numbers

    Started by Limor_OP‎, 03-28-2025 11:07 AM
    1 Attachment(s)
    • 5
    • 116
    Fluff13
    03-28-2025, 04:12 PM Go to last post
+ Post New Thread
Page 1 of 5699 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 516 users browsing this forum. (2 members & 514 guests)

  1. Louise1998Excel,
  2. Phuocam

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