+ Post New Thread
Page 1 of 5614 1 ...
Threads 1 to 50 of 280680

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

  1. Selecting Blank cells and deleting those cells and the 2 cells directly above each Blank

    Started by coach.32‎, Yesterday 03:31 AM
    2 Attachment(s)
    • 4
    • 75
    wk9128
    Yesterday, 09:24 PM Go to last post

  2. Question [SOLVED] Solver Function Fails...

    Started by qoaqnejddl‎, Yesterday 05:34 PM
    excel issue, simplex lp, solver 2 Attachment(s)
    • 4
    • 63
    qoaqnejddl
    Yesterday, 06:15 PM Go to last post

  3. Copy a formula with the format

    Started by samyraj‎, Yesterday 09:32 AM
    1 Attachment(s)
    • 3
    • 54
    wk9128
    Yesterday, 06:11 PM Go to last post

  4. Referencing another workbook and used by multiple users.

    Started by GeekBlueNose‎, 04-16-2024 12:15 PM
    • 1
    • 61
    puffinator
    Yesterday, 06:00 PM Go to last post

  5. Question [SOLVED] Another Combining Columns Question

    Started by bushwacked‎, Yesterday 11:34 AM
    1 Attachment(s)
    • 3
    • 65
    TMS
    Yesterday, 05:21 PM Go to last post

  6. Failed If function

    Started by leovilla‎, Yesterday 03:00 PM
    2 Attachment(s)
    • 12
    • 99
    TMS
    Yesterday, 05:03 PM Go to last post

  7. Sequence Numbers Based on Certain Columns B, D, G

    Started by Ravana‎, Yesterday 01:05 PM
    2 Attachment(s)
    • 1
    • 45
    HansDouwe
    Yesterday, 04:01 PM Go to last post

  8. Question about Lambda

    Started by FT00‎, Yesterday 04:47 AM
    2 Attachment(s)
    • 6
    • 121
    HansDouwe
    Yesterday, 03:32 PM Go to last post

  9. Help on lookup to pull most recent value based on most recent date for larger dataset

    Started by cwwazy‎, Yesterday 02:37 PM
    formula 4 Attachment(s)
    • 1
    • 101
    etaf
    Yesterday, 03:29 PM Go to last post

  10. Power Pivot Measure ifblank then 0

    Started by trisoldee‎, Yesterday 02:16 PM
    • 0
    • 29
    trisoldee
    Yesterday, 02:16 PM Go to last post

  11. Question Randomize Golf Teams Based on Skill Level

    Started by CARCHER05‎, Yesterday 01:21 PM
    1 Attachment(s)
    • 0
    • 38
    CARCHER05
    Yesterday, 01:21 PM Go to last post

  12. Question Help Using Offset to Count Values in Sections

    Started by larissao‎, Yesterday 11:59 AM
    • 3
    • 47
    TMS
    Yesterday, 01:20 PM Go to last post

  13. [SOLVED] Formula to move data depending on project start date

    Started by deadparrot‎, Yesterday 06:44 AM
    2 Attachment(s)
    • 7
    • 76
    Glenn Kennedy
    Yesterday, 12:35 PM Go to last post

  14. Issue w/ DATEDIF (Treating Dec to Feb as 1 month)

    Started by Drexl27‎, 04-25-2024 01:58 PM
    1 Attachment(s)
    • 7
    • 113
    TMS
    Yesterday, 12:21 PM Go to last post

  15. [SOLVED] Help with IF formula over multiple columns

    Started by MG312‎, Yesterday 07:37 AM
    2 Attachment(s)
    • 2
    • 65
    MG312
    Yesterday, 11:43 AM Go to last post

  16. [SOLVED] Protected sheet killing VLOOKUP from updating

    Started by vdubskey‎, 04-25-2024 09:52 PM
    1 Attachment(s)
    • 7
    • 91
    AliGW
    Yesterday, 11:22 AM Go to last post

  17. Moved: Extract Data from inconsistent number of rows

    Started by DarrylBurge‎, Yesterday 09:38 AM
    •  
    •  

  18. [SOLVED] Help with formula for duplicate data

    Started by LawsonC‎, Yesterday 08:48 AM
    4 Attachment(s)
    • 8
    • 79
    AliGW
    Yesterday, 11:03 AM Go to last post

  19. Too many arguments issue in the formulae

    Started by nupurs250‎, 04-25-2024 01:42 PM
    2 Attachment(s)
    • 1
    • 74
    Glenn Kennedy
    Yesterday, 11:00 AM Go to last post

  20. [SOLVED] Calculating a percentage based on rows above and below

    Started by ExcelNewbie92‎, 04-25-2024 06:05 AM
    5 Attachment(s)
    • 27
    • 199
    AliGW
    Yesterday, 10:58 AM Go to last post

  21. Deferred Revenue and Balance Report

    Started by Newman85‎, Yesterday 07:31 AM
    1 Attachment(s)
    • 5
    • 60
    josephteh
    Yesterday, 10:48 AM Go to last post

  22. [SOLVED] Extract values from between characters

    Started by Bad Idea Fairy‎, 04-25-2024 05:02 PM
    2 Attachment(s)
    • 7
    • 65
    Glenn Kennedy
    Yesterday, 10:33 AM Go to last post

  23. [SOLVED] Using Textjoin to Extract Values in Col E1 to G50 in B2

    Started by Howardc1001‎, Yesterday 07:49 AM
    1 Attachment(s)
    • 5
    • 69
    ByteMarks
    Yesterday, 09:54 AM Go to last post

  24. [SOLVED] How do I get a macro to insert all the way down a column until last entry

    Started by tweacle‎, Yesterday 08:04 AM
    • 3
    • 56
    tweacle
    Yesterday, 09:21 AM Go to last post

  25. Redistribute percentages

    Started by jlesco89‎, Yesterday 08:39 AM
    percentages, redistribute 2 Attachment(s)
    • 1
    • 41
    HansDouwe
    Yesterday, 08:52 AM Go to last post

  26. Data Grouping

    Started by Magalela‎, 04-24-2024 06:55 AM
    1 Attachment(s)
    • 2
    • 60
    Magalela
    Yesterday, 08:08 AM Go to last post

  27. Running Total - SUM($A$1:A1)

    Started by blackburnsexcel‎, Yesterday 04:36 AM
    • 5
    • 74
    ByteMarks
    Yesterday, 06:31 AM Go to last post

  28. [SOLVED] Index Function within the last 28 days

    Started by Narbar_123‎, Yesterday 05:55 AM
    1 Attachment(s)
    • 3
    • 49
    AliGW
    Yesterday, 06:27 AM Go to last post

  29. Complex Scheduling in Excel

    Started by evee‎, 04-23-2024 12:33 AM
    schedule generator, schedules, scheduling with excel 2 Attachment(s)
    • 7
    • 176
    Hydraulics
    Yesterday, 06:14 AM Go to last post

  30. Normalization of Hours

    Started by shah.ghazanfar‎, 04-25-2024 11:29 AM
    1 Attachment(s)
    • 3
    • 64
    shah.ghazanfar
    Yesterday, 06:11 AM Go to last post

  31. [SOLVED] Complex TRANSPOSE problem

    Started by RubenvanHout‎, Yesterday 03:02 AM
    5 Attachment(s)
    • 9
    • 99
    RubenvanHout
    Yesterday, 04:12 AM Go to last post

  32. lookup if a number is within X of a range of numbers

    Started by td3201‎, Yesterday 12:24 AM
    • 1
    • 83
    TMS
    Yesterday, 02:29 AM Go to last post

  33. [SOLVED] Power Query - Extract data from worksheet

    Started by Kenny Yip‎, 04-23-2024 04:46 AM
    3 Attachment(s)
    • 6
    • 122
    Kenny Yip
    Yesterday, 02:20 AM Go to last post

  34. [SOLVED] Help on lookup to pull most recent value based on most recent date

    Started by cwwazy‎, 04-25-2024 05:09 PM
    formula, look up, max 3 Attachment(s)
    • 10
    • 193
    TMS
    Yesterday, 01:54 AM Go to last post

  35. Question COUNTIF not following standart when add new line

    Started by RechBR‎, 04-25-2024 05:57 PM
    • 1
    • 70
    AliGW
    Yesterday, 01:38 AM Go to last post

  36. Two Condition Statement/Formulas

    Started by bclark1‎, 04-25-2024 08:18 PM
    1 Attachment(s)
    • 3
    • 78
    Phuocam
    04-25-2024, 09:00 PM Go to last post

  37. Post [SOLVED] Changing template data

    Started by Jordon R‎, 04-23-2024 10:10 PM
    3 Attachment(s)
    • 14
    • 195
    wk9128
    04-25-2024, 07:51 PM Go to last post

  38. total and average patient counts through admit/discharge dates

    Started by crazy8jacky‎, 04-24-2024 11:05 AM
    3 Attachment(s)
    • 12
    • 140
    crazy8jacky
    04-25-2024, 07:03 PM Go to last post

  39. Populate cell with a specific date by checking a given date range.

    Started by Nova11‎, 04-25-2024 03:56 PM
    1 Attachment(s)
    • 2
    • 71
    Root_
    04-25-2024, 06:56 PM Go to last post

  40. Excel not rounding correctly

    Started by bborzych‎, 04-25-2024 05:56 PM
    • 1
    • 52
    MrShorty
    04-25-2024, 06:27 PM Go to last post

  41. [SOLVED] Formula to return last non blank value in column when data filtered?

    Started by lilsnoop‎, 04-25-2024 04:40 PM
    2 Attachment(s)
    • 5
    • 57
    lilsnoop
    04-25-2024, 05:13 PM Go to last post

  42. Calculating how many days at a certain hour that a ticket was opened

    Started by JCKinNC‎, 04-25-2024 02:14 PM
    1 Attachment(s)
    • 2
    • 67
    JCKinNC
    04-25-2024, 03:55 PM Go to last post

  43. Completion percentage from cells containing values

    Started by Musto85‎, 04-25-2024 12:22 PM
    3 Attachment(s)
    • 4
    • 70
    etaf
    04-25-2024, 02:49 PM Go to last post

  44. why are my date functions not working

    Started by Osprey2‎, 04-24-2024 11:05 AM
    1 Attachment(s)
    • 6
    • 80
    Fluff13
    04-25-2024, 01:07 PM Go to last post

  45. Calculationg % Contribution when total is negative

    Started by greentea‎, 04-25-2024 11:32 AM
    1 Attachment(s)
    • 0
    • 58
    greentea
    04-25-2024, 11:32 AM Go to last post

  46. Help Extracting Specific Text From Inconsistent Text Strings

    Started by ZANDRY10085‎, 04-16-2024 07:56 PM
    6 Attachment(s)
    • 11
    • 200
    JeteMc
    04-25-2024, 10:27 AM Go to last post

  47. [SOLVED] Vlookup from a range of values

    Started by samyraj‎, 04-24-2024 06:58 AM
    2 Attachment(s)
    • 5
    • 72
    AliGW
    04-25-2024, 10:04 AM Go to last post

  48. [SOLVED] Conditionally formatting question with checkboxes.

    Started by Tricks420‎, 04-20-2024 10:55 AM
    11 Attachment(s)
    • 20
    • 180
    AliGW
    04-25-2024, 09:56 AM Go to last post

  49. [SOLVED] Averaging the last 4 weeks

    Started by Narbar_123‎, 04-24-2024 09:33 AM
    3 Attachment(s)
    • 5
    • 106
    Narbar_123
    04-25-2024, 09:35 AM Go to last post

  50. Find unique values in a column(which is identified by column number)

    Started by krishnapg‎, 04-25-2024 05:08 AM
    excel function, formula
    • 8
    • 110
    kvsrinivasamurthy
    04-25-2024, 09:00 AM Go to last post
+ Post New Thread
Page 1 of 5614 1 ...

Forum Information and Options

Users Browsing this Forum

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