+ Post New Thread
Page 3 of 5701 FirstFirst 3 ...
Threads 101 to 150 of 285021

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

  1. [SOLVED] Vlookup/Xlookup function with few different values

    Started by elad770‎, 04-04-2025 11:41 AM
    3 Attachment(s)
    • 15
    • 304
    CARACALLA
    04-07-2025, 11:17 PM Go to last post

  2. formula help with budget

    Started by LAWitcher‎, 04-07-2025 08:58 PM
    • 2
    • 103
    6StringJazzer
    04-07-2025, 10:20 PM Go to last post

  3. SUMIFS with Date Range and Multiple Criteria in Single Cell Column

    Started by ExcelMeister10520‎, 04-05-2025 01:14 PM
    2 Attachment(s)
    • 4
    • 194
    FlameRetired
    04-07-2025, 07:48 PM Go to last post

  4. [SOLVED] Get opening balance from Provious working day Closing balance

    Started by tpsdas‎, 04-05-2025 12:05 PM
    3 Attachment(s)
    • 21
    • 319
    TMS
    04-07-2025, 05:50 PM Go to last post

  5. [SOLVED] Remander shows in next row until below max

    Started by swiftrain‎, 04-07-2025 01:57 PM
    group, remainder, sum <> or 1 Attachment(s)
    • 2
    • 106
    swiftrain
    04-07-2025, 02:58 PM Go to last post

  6. Correction of Excel Formula

    Started by kpstambul‎, 04-07-2025 08:08 AM
    • 3
    • 165
    AliGW
    04-07-2025, 09:02 AM Go to last post

  7. how to add cell value by 1 with just a click

    Started by albudda‎, 04-06-2025 11:21 AM
    4 Attachment(s)
    • 11
    • 242
    wk9128
    04-07-2025, 08:51 AM Go to last post

  8. [SOLVED] TrimRefs give error when range is blank

    Started by ByteMarks‎, 04-04-2025 12:28 PM
    • 7
    • 285
    TMS
    04-07-2025, 06:01 AM Go to last post

  9. [SOLVED] Formula to update postmenstrual gestation automatically

    Started by ian.nicoll‎, 04-06-2025 11:58 PM
    3 Attachment(s)
    • 7
    • 151
    AliGW
    04-07-2025, 01:36 AM Go to last post

  10. help with formula

    Started by ozil‎, 03-28-2025 01:15 PM
    1 Attachment(s)
    • 12
    • 494
    AliGW
    04-07-2025, 01:05 AM Go to last post

  11. formula to check if a date is in daylight saving time

    Started by RMendonca‎, 09-16-2016 10:11 AM
    daylight saving time 2 Attachment(s)
    • 11
    • 15,599
    6StringJazzer
    04-06-2025, 10:01 PM Go to last post

  12. [SOLVED] Go calculate the number repeatedly

    Started by metrostar‎, 03-25-2025 10:35 AM
    1 Attachment(s)
    • 6
    • 186
    wk9128
    04-06-2025, 09:07 PM Go to last post

  13. [SOLVED] Formula required

    Started by skml‎, 04-06-2025 12:25 PM
    1 Attachment(s)
    • 6
    • 120
    AliGW
    04-06-2025, 12:44 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
    3 Attachment(s)
    • 4
    • 244
    Czeslaw
    04-06-2025, 08:10 AM Go to last post

  15. [SOLVED] Copy a cells contents if the 4th letter in the cell is an "E"

    Started by pdsdownunder‎, 04-06-2025 04:03 AM
    2 Attachment(s)
    • 4
    • 131
    AliGW
    04-06-2025, 04:52 AM Go to last post

  16. How to filter data in Power query with specific date range

    Started by Muhammad Muhammad‎, 04-05-2025 03:09 PM
    • 1
    • 110
    alansidman
    04-05-2025, 05:40 PM Go to last post

  17. [SOLVED] Autofill based on dropdown selection

    Started by jtglanton‎, 04-04-2025 03:56 PM
    2 Attachment(s)
    • 4
    • 223
    AliGW
    04-05-2025, 02:51 AM Go to last post

  18. Help with Index/Match Formula

    Started by narrowgate88‎, 04-03-2025 05:30 PM
    2 Attachment(s)
    • 11
    • 194
    AliGW
    04-04-2025, 12:07 PM Go to last post

  19. [SOLVED] Using countifs formula for multiple criteria within a range

    Started by Craig Foggo‎, 04-04-2025 09:12 AM
    • 3
    • 118
    BadlySpelledBuoy
    04-04-2025, 09:29 AM Go to last post

  20. [SOLVED] Cell referencing not retrieving text from another tab

    Started by brady.boardman‎, 04-04-2025 06:54 AM
    1 Attachment(s)
    • 4
    • 108
    AliGW
    04-04-2025, 07:22 AM Go to last post

  21. Match closest value using two cells.

    Started by Louise1998Excel‎, 04-02-2025 09:57 AM
    4 Attachment(s)
    • 13
    • 349
    TMS
    04-04-2025, 06:28 AM Go to last post

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

    Started by Frick‎, 04-03-2025 03:56 PM
    1 Attachment(s)
    • 11
    • 190
    Czeslaw
    04-04-2025, 02:02 AM Go to last post

  23. [SOLVED] Check box or Radio Button when selected will provide current date and time

    Started by Frick‎, 04-03-2025 05:42 PM
    2 Attachment(s)
    • 3
    • 130
    protonLeah
    04-04-2025, 12:09 AM Go to last post

  24. Excel Solver Help

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

  25. Changing a negative number into a positive umber

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

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

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

  27. [SOLVED] CHOOSE Function Help

    Started by SqueekyWheel‎, 04-03-2025 08:13 PM
    2 Attachment(s)
    • 4
    • 153
    Adtxc
    04-03-2025, 10:43 PM Go to last post

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

    Started by Stehop61‎, 04-03-2025 02:19 PM
    4 Attachment(s)
    • 9
    • 198
    MarvinP
    04-03-2025, 06:22 PM Go to last post

  29. Moved: fonction SOMME_SI_COULEUR

    Started by Fred94‎, 04-03-2025 04:53 PM
    •  
    •  

  30. Help pulling data from multiple workbooks

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

  31. [SOLVED] Help with Lookup Formula

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

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

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

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

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

  34. Custom Data Validation

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

  35. 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
    • 122
    Spondoosh
    04-02-2025, 09:34 AM Go to last post

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

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

  37. 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
    • 179
    patakfrite
    04-02-2025, 07:49 AM Go to last post

  38. Conver text to numbers to sum in excel

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

  39. [SOLVED] Works except for last two rows

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

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

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

  41. Help with Index and Match

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

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

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

  43. [SOLVED] create space on phone numbers

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

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

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

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

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

  46. [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
    • 144
    Fluff13
    04-01-2025, 10:32 AM Go to last post

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

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

  48. [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
    • 154
    AliGW
    04-01-2025, 07:27 AM Go to last post

  49. Want to arrange identical name in a left column

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

  50. [SOLVED] Help with Statistic Formula

    Started by SqueekyWheel‎, 03-29-2025 01:06 PM
    1 Attachment(s)
    • 5
    • 256
    TMS
    03-31-2025, 06:08 PM Go to last post
+ Post New Thread
Page 3 of 5701 FirstFirst 3 ...

Forum Information and Options

Users Browsing this Forum

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