+ Post New Thread
Page 101 of 5614 FirstFirst ... 101 ...
Threads 5001 to 5050 of 280655

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

  1. Line Breaks in cells transposing information

    Started by Oymonkey‎, 08-07-2023 10:23 AM
    1 Attachment(s)
    • 1
    • 183
    Fluff13
    08-07-2023, 11:02 AM Go to last post

  2. [SOLVED] Augment Formula to Include Additional Filter

    Started by applehugger‎, 08-04-2023 11:26 AM
    4 Attachment(s)
    • 12
    • 232
    Glenn Kennedy
    08-07-2023, 08:42 AM Go to last post

  3. [SOLVED] Change Month format

    Started by kimudao‎, 08-01-2023 12:31 AM
    1 Attachment(s)
    • 7
    • 259
    FDibbins
    08-06-2023, 11:41 PM Go to last post

  4. Use variable for column in formula

    Started by Len Silva‎, 08-06-2023 05:35 PM
    1 Attachment(s)
    • 1
    • 181
    TMS
    08-06-2023, 06:19 PM Go to last post

  5. Xlookup returns N/A

    Started by Tyrone_Wells‎, 08-06-2023 02:47 PM
    1 Attachment(s)
    • 1
    • 251
    banaanas
    08-06-2023, 04:49 PM Go to last post

  6. [SOLVED] Pulling text/number values from text string

    Started by Eurus53‎, 08-05-2023 10:28 PM
    5 Attachment(s)
    • 22
    • 419
    HansDouwe
    08-06-2023, 02:30 PM Go to last post

  7. [SOLVED] Keep only the last value in a comma separated text cell

    Started by garyb123‎, 08-06-2023 07:47 AM
    1 Attachment(s)
    • 6
    • 384
    garyb123
    08-06-2023, 01:04 PM Go to last post

  8. [SOLVED] sumifs or a better/ different function?

    Started by jml2‎, 08-06-2023 11:56 AM
    • 3
    • 165
    Fluff13
    08-06-2023, 01:01 PM Go to last post

  9. How to convert a user input into hh:mm:ss

    Started by Barefoot_Wanderer‎, 08-02-2023 08:55 AM
    • 5
    • 270
    Pete_UK
    08-06-2023, 08:50 AM Go to last post

  10. add or remove rows from calculations?

    Started by Gagarin-ace‎, 08-06-2023 02:10 AM
    2 Attachment(s)
    • 12
    • 252
    Gagarin-ace
    08-06-2023, 05:29 AM Go to last post

  11. Remove CHAR(10) blank from CONCATENATE formula

    Started by OLLY-7‎, 08-21-2013 04:01 AM
    1 Attachment(s)
    • 13
    • 7,034
    AliGW
    08-06-2023, 01:44 AM Go to last post

  12. [SOLVED] Need formula to look most recent amount from specific month with 1 criteria

    Started by thematrix05‎, 07-31-2023 05:47 PM
    1 Attachment(s)
    • 15
    • 512
    wk9128
    08-06-2023, 01:19 AM Go to last post

  13. [SOLVED] The last Value between Date to Date

    Started by MAHMUZ‎, 08-05-2023 10:36 AM
    3 Attachment(s)
    • 10
    • 276
    wk9128
    08-06-2023, 01:18 AM Go to last post

  14. Mortgage Calculator - Calculate Loan Amount from Monthly Payment

    Started by vinnythering‎, 08-12-2020 04:50 PM
    budget, calculator, finance, mortgage 2 Attachment(s)
    • 12
    • 1,762
    AliGW
    08-06-2023, 12:27 AM Go to last post

  15. [SOLVED] Formula to lookup ID in multiple worksheets then return a value

    Started by tml2424‎, 08-05-2023 12:39 AM
    4 Attachment(s)
    • 5
    • 327
    AliGW
    08-05-2023, 11:58 PM Go to last post

  16. [SOLVED] Help with a formula to calculate productivity bonus

    Started by KenV15‎, 08-05-2023 01:10 AM
    1 Attachment(s)
    • 6
    • 254
    AliGW
    08-05-2023, 11:41 PM Go to last post

  17. [SOLVED] The return value past a specific should be zero...

    Started by Tyrone_Wells‎, 08-05-2023 02:41 PM
    4 Attachment(s)
    • 5
    • 222
    HansDouwe
    08-05-2023, 08:39 PM Go to last post

  18. Mround and Ceiling are not round correctly as per system

    Started by Micfree1‎, 08-05-2023 11:22 AM
    3 Attachment(s)
    • 8
    • 291
    HansDouwe
    08-05-2023, 02:09 PM Go to last post

  19. Summing Columns with Multiple IF Statement

    Started by luka_88‎, 08-05-2023 08:42 AM
    3 Attachment(s)
    • 7
    • 279
    luka_88
    08-05-2023, 01:09 PM Go to last post

  20. [SOLVED] IF Statement with 3 different criteria

    Started by DEEARO‎, 08-05-2023 10:13 AM
    4 Attachment(s)
    • 6
    • 222
    etaf
    08-05-2023, 11:25 AM Go to last post

  21. Time Sheet Formula Help

    Started by Soccerates‎, 07-29-2023 04:39 PM
    • 5
    • 272
    JeteMc
    08-05-2023, 11:04 AM Go to last post

  22. Lightbulb [SOLVED] Create projection recovery of report

    Started by sanjuss2‎, 08-02-2023 01:41 PM
    3 Attachment(s)
    • 7
    • 372
    sanjuss2
    08-05-2023, 10:12 AM Go to last post

  23. OFFSET + COUNTIF (INDEX+MATCH) = NO VALUE for Searchable Drop Down List

    Started by stefan.g‎, 06-18-2023 07:48 AM
    9 Attachment(s)
    • 31
    • 731
    stefan.g
    08-05-2023, 08:35 AM Go to last post

  24. [SOLVED] Maximum Drawdown in Percentage

    Started by soubasa‎, 08-04-2023 07:44 AM
    7 Attachment(s)
    • 14
    • 307
    windknife
    08-05-2023, 07:59 AM Go to last post

  25. Splitting Days across a Range?

    Started by steveherek‎, 08-02-2023 12:26 AM
    3 Attachment(s)
    • 3
    • 273
    HansDouwe
    08-05-2023, 05:55 AM Go to last post

  26. [SOLVED] Using Tables Names in Formula

    Started by cosmica67‎, 08-04-2023 02:41 PM
    1 Attachment(s)
    • 5
    • 176
    AliGW
    08-05-2023, 04:02 AM Go to last post

  27. Moved: Get data from C2 and F3 then show new value in C3, must only work from header

    Started by hendrikbez‎, 08-05-2023 03:42 AM
    •  
    •  

  28. Angry [SOLVED] Timesheet not calculating properly. Looking for help!

    Started by GSPProd‎, 08-04-2023 11:34 AM
    formula, google, if/then, sheets, timesheet 3 Attachment(s)
    • 9
    • 285
    AliGW
    08-05-2023, 03:01 AM Go to last post

  29. Question [SOLVED] Budget reduction column

    Started by brvheart‎, 08-04-2023 01:01 PM
    blank cell, budget, difference, isblank, sumifs
    • 4
    • 238
    AliGW
    08-05-2023, 01:04 AM Go to last post

  30. MAXIF formula to look over multiple sheets

    Started by JaySanctuary‎, 08-02-2023 09:16 AM
    3 Attachment(s)
    • 8
    • 723
    menem
    08-05-2023, 12:09 AM Go to last post

  31. Matching Positive (Debits) and Negative (Credits) to Identify Ledger Balance

    Started by leadjasmine‎, 08-04-2023 05:56 PM
    2 Attachment(s)
    • 5
    • 247
    TMS
    08-04-2023, 07:17 PM Go to last post

  32. [SOLVED] Help with Median IF!

    Started by tenma123‎, 08-04-2023 05:08 PM
    1 Attachment(s)
    • 4
    • 193
    TMS
    08-04-2023, 06:47 PM Go to last post

  33. Formula Not Displaying Negative Values Correctly

    Started by Frankinstyyn‎, 08-04-2023 10:08 AM
    formulas & functions, sum and if 4 Attachment(s)
    • 16
    • 899
    JohnTopley
    08-04-2023, 12:34 PM Go to last post

  34. [SOLVED] average if (ifs) not in a list

    Started by jml2‎, 08-03-2023 03:51 PM
    1 Attachment(s)
    • 3
    • 375
    jml2
    08-04-2023, 12:27 PM Go to last post

  35. Post How do I count a block of numbers in Excel

    Started by SaruwatariKaito‎, 08-04-2023 08:51 AM
    2 Attachment(s)
    • 9
    • 297
    TMS
    08-04-2023, 12:17 PM Go to last post

  36. need to do an excel formula split a grant award for departments between years

    Started by swanjohnny83‎, 08-04-2023 08:53 AM
    excel, sumif
    • 14
    • 374
    AliGW
    08-04-2023, 12:00 PM Go to last post

  37. Question Conditional correction in Excel

    Started by siregarmr‎, 08-02-2023 03:41 PM
    1 Attachment(s)
    • 1
    • 189
    JeteMc
    08-04-2023, 11:43 AM Go to last post

  38. Moved: Remove Column value based on selected 'Effective Date'

    Started by dogbural‎, 08-04-2023 01:30 AM
    •  
    •  

  39. [SOLVED] How to make a Progress Bar that works as amount remaining

    Started by andrew9993‎, 08-04-2023 10:25 AM
    progress bar 1 Attachment(s)
    • 3
    • 184
    AliGW
    08-04-2023, 10:45 AM Go to last post

  40. [SOLVED] How do I count the max 7 lowest scores in this sheet??

    Started by Albert310‎, 08-04-2023 09:09 AM
    3 Attachment(s)
    • 7
    • 172
    Glenn Kennedy
    08-04-2023, 10:41 AM Go to last post

  41. Moved: Function to strip out disallowed characters not working

    Started by MikeMacM‎, 08-04-2023 10:21 AM
    •  
    •  

  42. [SOLVED] Keep a group/family rows together when sorting

    Started by bradd15‎, 07-27-2023 02:04 PM
    4 Attachment(s)
    • 9
    • 574
    bradd15
    08-04-2023, 10:20 AM Go to last post

  43. [SOLVED] HLOOKUP with MATCH and something else

    Started by HD180‎, 08-03-2023 06:43 PM
    1 Attachment(s)
    • 6
    • 225
    HansDouwe
    08-04-2023, 10:02 AM Go to last post

  44. [SOLVED] HOrse Racing - Bookie Account Balances

    Started by Captain_Ahab‎, 06-26-2023 05:52 AM
    3 Attachment(s)
    • 9
    • 413
    JeteMc
    08-04-2023, 09:44 AM Go to last post

  45. [SOLVED] Sumif with Indirect

    Started by sonu1975‎, 08-04-2023 04:49 AM
    3 Attachment(s)
    • 6
    • 327
    HansDouwe
    08-04-2023, 09:43 AM Go to last post

  46. Moved: Applying filter based on numbers inside a sentence. Google Sheet

    Started by vlady‎, 08-04-2023 08:29 AM
    •  
    •  

  47. [SOLVED] Gross Profit Calculation Incorrect

    Started by billy60‎, 08-04-2023 06:29 AM
    2 Attachment(s)
    • 8
    • 206
    AliGW
    08-04-2023, 08:44 AM Go to last post

  48. [SOLVED] Conditional Formatting Formula help - exclude #n/a

    Started by BarbaraDecker‎, 08-04-2023 07:01 AM
    • 3
    • 166
    AliGW
    08-04-2023, 08:16 AM Go to last post

  49. [SOLVED] Formula for Multiple Values

    Started by will789‎, 08-03-2023 11:51 AM
    • 4
    • 251
    AliGW
    08-04-2023, 05:05 AM Go to last post

  50. rotate a list of names based on who took the last turn

    Started by ShelleyM‎, 08-03-2023 08:38 AM
    list, rotate 5 Attachment(s)
    • 9
    • 442
    AliGW
    08-04-2023, 01:53 AM Go to last post
+ Post New Thread
Page 101 of 5614 FirstFirst ... 101 ...

Forum Information and Options

Users Browsing this Forum

There are currently 61 users browsing this forum. (6 members & 55 guests)

  1. crazy8jacky,
  2. Glenn Kennedy,
  3. Gregb11,
  4. lilsnoop,
  5. MrShorty,
  6. Root_

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