+ Post New Thread
Page 1 of 5711 1 ...
Threads 1 to 50 of 285529

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

  1. Search multiply characters using "Mid" function

    Started by pdsdownunder‎, Today 09:18 PM
    • 1
    • 21
    Gregb11
    Today, 10:24 PM Go to last post

  2. Need Help Calculating Shifts, Differential, and Overlapping Hours.

    Started by Watchs065‎, Yesterday 11:41 PM
    3 Attachment(s)
    • 6
    • 103
    JeteMc
    Today, 10:04 PM Go to last post

  3. Alternative to sequence function

    Started by markharris2004‎, Today 03:55 PM
    2 Attachment(s)
    • 9
    • 100
    protonLeah
    Today, 07:49 PM Go to last post

  4. [SOLVED] Output flexible columns with CHOOSECOLS() or similar function.

    Started by MrShorty‎, Today 03:54 PM
    1 Attachment(s)
    • 6
    • 92
    TMS
    Today, 07:08 PM Go to last post

  5. [SOLVED] Dynamically update a grid based on table data

    Started by DigitalWavez‎, 06-06-2025 07:29 AM
    7 Attachment(s)
    • 24
    • 412
    JeteMc
    Today, 05:53 PM Go to last post

  6. [SOLVED] Convert Table Data into Single Column

    Started by btparkhe1920‎, Today 01:21 AM
    3 Attachment(s)
    • 5
    • 102
    TMS
    Today, 01:33 PM Go to last post

  7. Lookup "SIMILAR" Address

    Started by dluhut‎, Today 12:00 PM
    • 0
    • 62
    dluhut
    Today, 12:00 PM Go to last post

  8. Exclamation [SOLVED] Help with a Countif formula with multiple criteria.

    Started by Johnny247‎, Today 09:16 AM
    2 Attachment(s)
    • 16
    • 122
    Fluff13
    Today, 11:52 AM Go to last post

  9. Help with monthly data

    Started by kvemperor‎, Today 02:52 AM
    2 Attachment(s)
    • 1
    • 93
    JeteMc
    Today, 10:50 AM Go to last post

  10. Bulk UPPER or LOWER Change

    Started by COgreywolf‎, 04-13-2009 11:17 AM
    • 6
    • 1,168
    AliGW
    Today, 10:42 AM Go to last post

  11. Post Change phone number in bulk

    Started by njpacific‎, 12-12-2013 10:17 AM
    replace
    • 5
    • 774
    elsasmith
    Today, 10:40 AM Go to last post

  12. How do I add parenthesis to my phone number list -the area code?

    Started by Alan‎, 05-09-2006 06:15 PM
    • 8
    • 26,157
    elsasmith
    Today, 10:38 AM Go to last post

  13. Combine LET function with COUNTIF

    Started by FierceExcel‎, Today 06:33 AM
    2 Attachment(s)
    • 3
    • 105
    djclements
    Today, 10:28 AM Go to last post

  14. Additional formula for OFFSET in DATA VALIDATION

    Started by timothyjoseph827‎, Today 07:31 AM
    data validation, isblank data validation, offset 1 Attachment(s)
    • 2
    • 89
    6StringJazzer
    Today, 10:17 AM Go to last post

  15. [SOLVED] Conditional formula in excel

    Started by ST03KSY‎, Yesterday 07:35 AM
    3 Attachment(s)
    • 19
    • 200
    TMS
    Today, 09:49 AM Go to last post

  16. [SOLVED] Lookup substring in string and return value

    Started by v.edwards.jr‎, Yesterday 11:18 PM
    1 Attachment(s)
    • 4
    • 101
    AliGW
    Today, 08:58 AM Go to last post

  17. Fetch sale and purchase data in different sheets

    Started by Vikas108‎, 07-01-2025 07:26 AM
    4 Attachment(s)
    • 7
    • 178
    JeteMc
    Today, 08:37 AM Go to last post

  18. Exclamation [SOLVED] Help with Countif formula

    Started by Johnny247‎, Today 05:41 AM
    1 Attachment(s)
    • 2
    • 71
    Johnny247
    Today, 07:38 AM Go to last post

  19. [SOLVED] Spillable Addition

    Started by jomili‎, Yesterday 02:53 PM
    • 7
    • 108
    Fluff13
    Today, 06:34 AM Go to last post

  20. Incorrect Result from SUM function

    Started by Magalela‎, Today 04:21 AM
    1 Attachment(s)
    • 2
    • 78
    zbor
    Today, 04:43 AM Go to last post

  21. [SOLVED] Exclude specific cells

    Started by Switchblade IX‎, Yesterday 11:08 AM
    1 Attachment(s)
    • 6
    • 118
    TMS
    Today, 02:36 AM Go to last post

  22. [SOLVED] Formula to get product result base on horizontal range result

    Started by seercoven‎, Yesterday 10:38 PM
    2 Attachment(s)
    • 5
    • 97
    windknife
    Today, 01:04 AM Go to last post

  23. [SOLVED] Skipping numbers in a sequence

    Started by endrei15‎, 06-30-2025 01:40 PM
    2 Attachment(s)
    • 9
    • 233
    FlameRetired
    Yesterday, 06:29 PM Go to last post

  24. Search for text on multiple sheets and sum cells next to it

    Started by DUDE37876‎, Yesterday 10:19 AM
    4 Attachment(s)
    • 4
    • 109
    Estevaoba
    Yesterday, 05:20 PM Go to last post

  25. Apportioning Values across existing values

    Started by jomili‎, 07-01-2025 12:38 PM
    4 Attachment(s)
    • 28
    • 299
    Bernie Deitrick
    Yesterday, 03:08 PM Go to last post

  26. Getting 0 from Aggregate function while result shown in formula pop-up is positive

    Started by ViniciusLima‎, 06-16-2025 10:17 AM
    aggregate, excel, formula 4 Attachment(s)
    • 5
    • 239
    JeteMc
    Yesterday, 12:48 PM Go to last post

  27. [SOLVED] Personalise Header

    Started by FT00‎, Yesterday 12:20 AM
    3 Attachment(s)
    • 7
    • 119
    AliGW
    Yesterday, 02:45 AM Go to last post

  28. Solver - How to get optimal solution?

    Started by Ctrl+C‎, 06-23-2025 04:49 PM
    open solver, opensolver, solver, solver constraint, solver function 4 Attachment(s)
    • 10
    • 342
    bsalv
    Yesterday, 02:20 AM Go to last post

  29. Rate of Return in Power Query

    Started by Vibee‎, 06-30-2025 10:40 AM
    power query, rate of return 1 Attachment(s)
    • 5
    • 151
    AliGW
    Yesterday, 01:42 AM Go to last post

  30. [SOLVED] Formulae to cap all negative % and more than 100% to 0%

    Started by cks1026‎, 07-01-2025 09:34 PM
    1 Attachment(s)
    • 3
    • 93
    windknife
    07-01-2025, 09:57 PM Go to last post

  31. [SOLVED] BYROW SOMETHINGIFS with criterium per row

    Started by Name invalid‎, 06-27-2025 10:07 AM
    3 Attachment(s)
    • 8
    • 256
    djclements
    07-01-2025, 09:44 PM Go to last post

  32. Problem copying color conditional formatting across rows, columns

    Started by ketco‎, 07-01-2025 01:27 PM
    1 Attachment(s)
    • 2
    • 121
    ketco
    07-01-2025, 08:23 PM Go to last post

  33. Compare two excel files

    Started by Anjali Rao‎, 07-01-2025 02:11 PM
    • 2
    • 86
    JohnTopley
    07-01-2025, 03:08 PM Go to last post

  34. Pro Rata Days in to establish duration

    Started by dchar1‎, 06-30-2025 03:35 PM
    3 Attachment(s)
    • 5
    • 167
    dchar1
    07-01-2025, 02:31 PM Go to last post

  35. [SOLVED] I want to automatize a routine to count 1 repeated event if it repeats in less than 2.

    Started by simaobola‎, 07-01-2025 09:55 AM
    1 Attachment(s)
    • 6
    • 134
    TMS
    07-01-2025, 11:28 AM Go to last post

  36. Importing Stock Options Pricing

    Started by GlockFu‎, 06-27-2025 09:58 PM
    2 Attachment(s)
    • 5
    • 205
    6StringJazzer
    07-01-2025, 08:40 AM Go to last post

  37. [SOLVED] Listing absent staff on a rota - pulling list of people on annual leave

    Started by akjb‎, 06-28-2025 04:27 PM
    3 Attachment(s)
    • 6
    • 217
    JeteMc
    07-01-2025, 08:10 AM Go to last post

  38. [SOLVED] How to use OFFSET.

    Started by joakimphooey‎, 06-30-2025 03:04 PM
    2 Attachment(s)
    • 6
    • 115
    joakimphooey
    07-01-2025, 08:03 AM Go to last post

  39. Post Nesting Formulas

    Started by JalSmith‎, 07-01-2025 01:12 AM
    nesting formulas, nesting issue
    • 1
    • 91
    AliGW
    07-01-2025, 01:15 AM Go to last post

  40. [SOLVED] In countifs formula H should be count as 1 if there is no L alphabet in that row

    Started by keshavtale‎, 06-30-2025 10:38 PM
    2 Attachment(s)
    • 7
    • 137
    AliGW
    07-01-2025, 12:52 AM Go to last post

  41. [SOLVED] Need help with Death & Birth Date Recordation Spreadsheet

    Started by Fred Houck‎, 06-30-2025 03:50 PM
    1 Attachment(s)
    • 3
    • 96
    JohnTopley
    06-30-2025, 05:10 PM Go to last post

  42. Payslip table from master employee list

    Started by anandakuttan‎, 06-30-2025 05:11 AM
    3 Attachment(s)
    • 10
    • 159
    TMS
    06-30-2025, 03:23 PM Go to last post

  43. [SOLVED] Show Percent

    Started by soubasa‎, 06-30-2025 11:08 AM
    2 Attachment(s)
    • 5
    • 91
    AliGW
    06-30-2025, 11:39 AM Go to last post

  44. [SOLVED] Solving for week 4, 5, and 1 at the beginning and end of a month..

    Started by DigitalWavez‎, 06-30-2025 08:45 AM
    2 Attachment(s)
    • 8
    • 154
    DigitalWavez
    06-30-2025, 11:16 AM Go to last post

  45. Sum with Text formula

    Started by john555‎, 06-30-2025 07:35 AM
    • 3
    • 120
    AliGW
    06-30-2025, 09:56 AM Go to last post

  46. Vertical Lines Showing Median

    Started by AxcelSpringer‎, 06-23-2025 08:25 AM
    3 Attachment(s)
    • 5
    • 219
    JeteMc
    06-30-2025, 08:00 AM Go to last post

  47. [SOLVED] Auto formula to pick up a result from 1 cell based on another cell content

    Started by Mena73‎, 06-30-2025 12:07 AM
    3 Attachment(s)
    • 12
    • 168
    AliGW
    06-30-2025, 02:37 AM Go to last post

  48. Question [SOLVED] Formula to complete table using two datasets when multiple conditions are met

    Started by Rowdy1973‎, 06-29-2025 08:20 PM
    2 Attachment(s)
    • 7
    • 124
    Sam Capricci
    06-29-2025, 11:05 PM Go to last post

  49. Question [SOLVED] Contitional Formating

    Started by Mike215‎, 06-29-2025 06:36 PM
    conditional format 1 Attachment(s)
    • 3
    • 109
    JeteMc
    06-29-2025, 09:23 PM Go to last post

  50. [SOLVED] Find the last column value in a row

    Started by excel760‎, 06-27-2025 02:27 PM
    3 Attachment(s)
    • 7
    • 181
    alansidman
    06-29-2025, 03:38 PM Go to last post
+ Post New Thread
Page 1 of 5711 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 475 users browsing this forum. (2 members & 473 guests)

  1. Gregb11,
  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