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

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

  1. Deferred Revenue and Balance Report

    Started by Newman85‎, Today 07:31 AM
    1 Attachment(s)
    • 3
    • 33
    josephteh
    Today, 09:46 AM Go to last post

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

    Started by Howardc1001‎, Today 07:49 AM
    1 Attachment(s)
    • 4
    • 39
    Howardc1001
    Today, 09:40 AM Go to last post

  3. Extract Data from inconsistent number of rows

    Started by DarrylBurge‎, Today 09:38 AM
    1 Attachment(s)
    • 0
    • 4
    DarrylBurge
    Today, 09:38 AM Go to last post

  4. Copy a formula with the format

    Started by samyraj‎, Today 09:32 AM
    1 Attachment(s)
    • 1
    • 6
    AliGW
    Today, 09:33 AM Go to last post

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

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

  6. Calculating a percentage based on rows above and below

    Started by ExcelNewbie92‎, Yesterday 06:05 AM
    5 Attachment(s)
    • 23
    • 180
    AliGW
    Today, 09:10 AM Go to last post

  7. Help with formula for duplicate data

    Started by LawsonC‎, Today 08:48 AM
    4 Attachment(s)
    • 6
    • 32
    AliGW
    Today, 09:09 AM Go to last post

  8. Redistribute percentages

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

  9. Question about Lambda

    Started by FT00‎, Today 04:47 AM
    2 Attachment(s)
    • 2
    • 78
    HansDouwe
    Today, 08:44 AM Go to last post

  10. Data Grouping

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

  11. Help with IF formula over multiple columns

    Started by MG312‎, Today 07:37 AM
    1 Attachment(s)
    • 0
    • 33
    MG312
    Today, 07:37 AM Go to last post

  12. Formula to move data depending on project start date

    Started by deadparrot‎, Today 06:44 AM
    1 Attachment(s)
    • 0
    • 30
    deadparrot
    Today, 06:44 AM Go to last post

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

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

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

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

  15. Complex Scheduling in Excel

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

  16. Normalization of Hours

    Started by shah.ghazanfar‎, Yesterday 11:29 AM
    1 Attachment(s)
    • 3
    • 62
    shah.ghazanfar
    Today, 06:11 AM Go to last post

  17. [SOLVED] Complex TRANSPOSE problem

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

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

    Started by coach.32‎, Today 03:31 AM
    1 Attachment(s)
    • 2
    • 41
    RaulSerg
    Today, 03:46 AM Go to last post

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

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

  20. Protected sheet killing VLOOKUP from updating

    Started by vdubskey‎, Yesterday 09:52 PM
    1 Attachment(s)
    • 3
    • 63
    AliGW
    Today, 02:26 AM Go to last post

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

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

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

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

  23. Question COUNTIF not following standart when add new line

    Started by RechBR‎, Yesterday 05:57 PM
    • 1
    • 61
    AliGW
    Today, 01:38 AM Go to last post

  24. Two Condition Statement/Formulas

    Started by bclark1‎, Yesterday 08:18 PM
    1 Attachment(s)
    • 3
    • 65
    Phuocam
    Yesterday, 09:00 PM Go to last post

  25. Post [SOLVED] Changing template data

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

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

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

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

    Started by Nova11‎, Yesterday 03:56 PM
    1 Attachment(s)
    • 2
    • 69
    Root_
    Yesterday, 06:56 PM Go to last post

  28. Excel not rounding correctly

    Started by bborzych‎, Yesterday 05:56 PM
    • 1
    • 52
    MrShorty
    Yesterday, 06:27 PM Go to last post

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

    Started by Drexl27‎, Yesterday 01:58 PM
    1 Attachment(s)
    • 3
    • 82
    TMS
    Yesterday, 05:37 PM Go to last post

  30. Extract values from between characters

    Started by Bad Idea Fairy‎, Yesterday 05:02 PM
    2 Attachment(s)
    • 5
    • 52
    Glenn Kennedy
    Yesterday, 05:33 PM Go to last post

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

    Started by lilsnoop‎, Yesterday 04:40 PM
    2 Attachment(s)
    • 5
    • 56
    lilsnoop
    Yesterday, 05:13 PM Go to last post

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

    Started by JCKinNC‎, Yesterday 02:14 PM
    1 Attachment(s)
    • 2
    • 62
    JCKinNC
    Yesterday, 03:55 PM Go to last post

  33. Completion percentage from cells containing values

    Started by Musto85‎, Yesterday 12:22 PM
    3 Attachment(s)
    • 4
    • 67
    etaf
    Yesterday, 02:49 PM Go to last post

  34. Too many arguments issue in the formulae

    Started by nupurs250‎, Yesterday 01:42 PM
    2 Attachment(s)
    • 0
    • 60
    nupurs250
    Yesterday, 01:42 PM Go to last post

  35. why are my date functions not working

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

  36. Calculationg % Contribution when total is negative

    Started by greentea‎, Yesterday 11:32 AM
    1 Attachment(s)
    • 0
    • 56
    greentea
    Yesterday, 11:32 AM Go to last post

  37. Help Extracting Specific Text From Inconsistent Text Strings

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

  38. [SOLVED] Vlookup from a range of values

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

  39. [SOLVED] Conditionally formatting question with checkboxes.

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

  40. [SOLVED] Averaging the last 4 weeks

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

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

    Started by krishnapg‎, Yesterday 05:08 AM
    excel function, formula
    • 8
    • 109
    kvsrinivasamurthy
    Yesterday, 09:00 AM Go to last post

  42. using =sum formula ignoring spaces

    Started by Writingformulas‎, Yesterday 07:44 AM
    1 Attachment(s)
    • 4
    • 86
    AliGW
    Yesterday, 08:48 AM Go to last post

  43. return a value to another sheet and decrease the amount of stock on that product

    Started by kdolba‎, 04-24-2024 09:04 AM
    2 Attachment(s)
    • 1
    • 78
    Kaper
    Yesterday, 05:42 AM Go to last post

  44. [SOLVED] Wildcard to exclude specific word from list when using SUMIFS

    Started by varbergt‎, Yesterday 04:13 AM
    sumifs, wildcard 3 Attachment(s)
    • 4
    • 65
    AliGW
    Yesterday, 05:04 AM Go to last post

  45. Singale line data

    Started by btparkhe1920‎, Yesterday 12:05 AM
    1 Attachment(s)
    • 3
    • 70
    TMS
    Yesterday, 01:20 AM Go to last post

  46. looking up a string value in a column of 'currency' datatype values

    Started by dv1651st‎, 04-24-2024 10:59 PM
    3 Attachment(s)
    • 2
    • 78
    AliGW
    Yesterday, 12:52 AM Go to last post

  47. [SOLVED] Convert string to date format

    Started by dobracik‎, 04-24-2024 04:01 AM
    1 Attachment(s)
    • 8
    • 126
    Czeslaw
    Yesterday, 12:12 AM Go to last post

  48. [SOLVED] By row/bycol question

    Started by FT00‎, 04-24-2024 01:36 PM
    1 Attachment(s)
    • 2
    • 84
    FT00
    04-24-2024, 09:39 PM Go to last post

  49. AVERAGE/IF Formula issue

    Started by W2OAN‎, 04-24-2024 10:00 AM
    averageif, averageifs, averageifs mulitpul, formula, formulas 1 Attachment(s)
    • 3
    • 86
    wk9128
    04-24-2024, 07:18 PM Go to last post

  50. Post [SOLVED] How can I add value based on two different variables?

    Started by D2S‎, 04-23-2024 11:23 PM
    2 Attachment(s)
    • 5
    • 109
    wk9128
    04-24-2024, 06:54 PM Go to last post
+ Post New Thread
Page 1 of 5614 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 110 users browsing this forum. (9 members & 101 guests)

  1. ben8563,
  2. Danilo Flaiban,
  3. DarrylBurge,
  4. HansDouwe,
  5. Howardc1001,
  6. Phuocam,
  7. racer3,
  8. samyraj

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