+ Post New Thread
Page 113 of 5615 FirstFirst ... 113 ...
Threads 5601 to 5650 of 280702

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

  1. Is it possible to link groups of data to one cell?

    Started by cmash‎, 07-09-2023 08:28 PM
    2 Attachment(s)
    • 1
    • 174
    6StringJazzer
    07-09-2023, 10:53 PM Go to last post

  2. What formula for investment compound interest calculation with dividend reinvested

    Started by KMJ256388‎, 07-08-2023 11:35 PM
    1 Attachment(s)
    • 5
    • 342
    JeteMc
    07-09-2023, 10:12 PM Go to last post

  3. [SOLVED] help with formula to calculate days to be recognised in each month

    Started by a2424‎, 07-07-2023 01:49 AM
    1 Attachment(s)
    • 10
    • 215
    a2424
    07-09-2023, 08:33 PM Go to last post

  4. [SOLVED] Looking to Count Months Dependent of Factors in Other Cells

    Started by gloriousglenn‎, 07-05-2023 10:07 PM
    3 Attachment(s)
    • 9
    • 295
    gloriousglenn
    07-09-2023, 07:54 PM Go to last post

  5. PMT formula incorporating increased yearly payments

    Started by dcshaw83‎, 07-06-2023 01:34 PM
    4 Attachment(s)
    • 7
    • 344
    bsalv
    07-09-2023, 04:00 PM Go to last post

  6. [SOLVED] Need help to find out code wise rate calculation

    Started by KRIXXXX‎, 05-27-2023 04:08 PM
    9 Attachment(s)
    • 25
    • 6,921
    KRIXXXX
    07-09-2023, 11:31 AM Go to last post

  7. [SOLVED] Help to modify conditional formatting formulas that display on time and late based on time

    Started by Longbow 44‎, 07-08-2023 01:17 AM
    3 Attachment(s)
    • 6
    • 343
    Longbow 44
    07-09-2023, 09:11 AM Go to last post

  8. [SOLVED] Summarize data with 2 variables

    Started by donl1150‎, 07-07-2023 06:45 AM
    5 Attachment(s)
    • 15
    • 391
    donl1150
    07-09-2023, 07:56 AM Go to last post

  9. How to separate cell by text color

    Started by zchan‎, 07-07-2023 11:38 AM
    1 Attachment(s)
    • 2
    • 203
    wk9128
    07-09-2023, 04:01 AM Go to last post

  10. [SOLVED] compare dynamic arrays, return missing values

    Started by guillaume0314‎, 07-08-2023 11:02 AM
    4 Attachment(s)
    • 7
    • 419
    AliGW
    07-09-2023, 03:30 AM Go to last post

  11. How to make a spreadsheet dynamic?

    Started by Jefreywith1F‎, 07-08-2023 10:42 PM
    • 2
    • 201
    alansidman
    07-09-2023, 01:02 AM Go to last post

  12. [SOLVED] DAX calculation to exclude outlier values from an analysis

    Started by The_Snook‎, 07-06-2023 03:55 PM
    4 Attachment(s)
    • 6
    • 319
    The_Snook
    07-08-2023, 08:50 PM Go to last post

  13. [SOLVED] text split then create spilling table

    Started by guillaume0314‎, 07-06-2023 04:31 AM
    29 Attachment(s)
    • 67
    • 1,219
    HansDouwe
    07-08-2023, 12:28 PM Go to last post

  14. Countifs by array, date, and including blanks

    Started by tkmagnet‎, 07-06-2023 04:55 PM
    3 Attachment(s)
    • 3
    • 302
    JeteMc
    07-08-2023, 10:35 AM Go to last post

  15. [SOLVED] Formula to Extract Email Addresses

    Started by Howardc1001‎, 07-08-2023 01:37 AM
    2 Attachment(s)
    • 2
    • 172
    Howardc1001
    07-08-2023, 08:19 AM Go to last post

  16. vlook and if combo?

    Started by ROTH1965‎, 07-07-2023 06:27 PM
    3 Attachment(s)
    • 8
    • 254
    HansDouwe
    07-08-2023, 07:35 AM Go to last post

  17. textsplit unknown dimension

    Started by guillaume0314‎, 07-08-2023 05:41 AM
    4 Attachment(s)
    • 4
    • 224
    AliGW
    07-08-2023, 06:29 AM Go to last post

  18. Find the last invenroty value

    Started by phamanh1998‎, 07-08-2023 03:55 AM
    2 Attachment(s)
    • 3
    • 178
    AliGW
    07-08-2023, 04:33 AM Go to last post

  19. Rolling Balance based on Population of Cell

    Started by mralexwild‎, 07-08-2023 03:03 AM
    1 Attachment(s)
    • 3
    • 193
    Pepe Le Mokko
    07-08-2023, 03:28 AM Go to last post

  20. [SOLVED] Average every nth cell - but with formula in the same column

    Started by gromitnz‎, 07-07-2023 12:54 AM
    1 Attachment(s)
    • 4
    • 215
    HansDouwe
    07-07-2023, 09:39 PM Go to last post

  21. Calculate Days Between (DAYS360) Including Start Date

    Started by Sparky156‎, 07-06-2023 03:17 PM
    2 Attachment(s)
    • 5
    • 346
    HansDouwe
    07-07-2023, 08:22 PM Go to last post

  22. INDEX array formula with multiple criteria - avoid duplicates

    Started by hexcelary‎, 07-07-2023 02:00 PM
    • 1
    • 275
    tanasedn
    07-07-2023, 04:27 PM Go to last post

  23. Horizontal Index Match: it only seems to work vertically!

    Started by NickydeVos‎, 07-07-2023 09:39 AM
    2 Attachment(s)
    • 9
    • 251
    NickydeVos
    07-07-2023, 02:14 PM Go to last post

  24. [SOLVED] Extract List of Months Between Two Condition

    Started by MAJID1479‎, 07-07-2023 12:34 PM
    date & text formula 3 Attachment(s)
    • 4
    • 194
    Glenn Kennedy
    07-07-2023, 02:01 PM Go to last post

  25. Question Excel Search a Cell for a List of Words

    Started by aatral‎, 07-07-2023 01:41 AM
    1 Attachment(s)
    • 6
    • 367
    Glenn Kennedy
    07-07-2023, 02:01 PM Go to last post

  26. There is a formula about count IF + date + IF

    Started by smartangel‎, 07-06-2023 02:13 PM
    • 2
    • 211
    JeteMc
    07-07-2023, 01:10 PM Go to last post

  27. unable to display only filtered data in dropdown

    Started by littleangel‎, 07-06-2023 01:59 AM
    excel, excel drop downs, excel dropdown list, excel filter 3 Attachment(s)
    • 7
    • 402
    wk9128
    07-07-2023, 10:41 AM Go to last post

  28. [SOLVED] Formula to Sum values until level is = or lower (BOM)

    Started by lgrbueno‎, 07-05-2023 03:46 PM
    2 Attachment(s)
    • 9
    • 276
    wk9128
    07-07-2023, 10:02 AM Go to last post

  29. [SOLVED] Finding 6 Months (or More) Apart Date

    Started by DharmeshChauhan‎, 07-05-2023 12:57 PM
    6 Attachment(s)
    • 7
    • 258
    JeteMc
    07-07-2023, 09:24 AM Go to last post

  30. Take,ChooseCols,Sort Function Not Showing Output In A Particular Cell

    Started by quentinlemmer‎, 07-07-2023 05:40 AM
    and function, choose function, choose funtion, isblank 6 Attachment(s)
    • 20
    • 456
    Fluff13
    07-07-2023, 08:52 AM Go to last post

  31. [SOLVED] Adding and Substracting - Manual Entry vs. Banking CSV numbers.

    Started by rob1963manwork‎, 07-07-2023 08:40 AM
    1 Attachment(s)
    • 3
    • 136
    AliGW
    07-07-2023, 08:52 AM Go to last post

  32. Moved: Search Box - multiple columns

    Started by Akela928‎, 07-07-2023 08:16 AM
    •  
    •  

  33. UNIQUE formula unlimited range

    Started by bhenlee‎, 07-06-2023 07:33 PM
    • 2
    • 186
    HansDouwe
    07-07-2023, 06:18 AM Go to last post

  34. Smile [SOLVED] Task is to get the sum qty for each day for each machine requirement line wise.

    Started by dulangaj‎, 07-07-2023 04:32 AM
    excel, formula, help a noob 2 Attachment(s)
    • 6
    • 245
    AliGW
    07-07-2023, 05:26 AM Go to last post

  35. [SOLVED] Separating Auto-Updated Data into Categories on other Table

    Started by darylglennt‎, 07-06-2023 11:26 PM
    6 Attachment(s)
    • 5
    • 250
    AliGW
    07-07-2023, 05:01 AM Go to last post

  36. [SOLVED] Calculate February Correctly for Monthly Allocation

    Started by Sparky156‎, 06-30-2023 08:46 PM
    3 Attachment(s)
    • 10
    • 504
    AliGW
    07-07-2023, 01:28 AM Go to last post

  37. [SOLVED] Differentiating Date to Day

    Started by Ian McPherson‎, 06-30-2023 04:44 AM
    1 Attachment(s)
    • 10
    • 352
    Ian McPherson
    07-07-2023, 01:22 AM Go to last post

  38. [SOLVED] Conditional formatting, highlight cells based on time

    Started by Kayz0220‎, 07-06-2023 04:42 PM
    2 Attachment(s)
    • 4
    • 195
    Kayz0220
    07-06-2023, 07:44 PM Go to last post

  39. Count from two columns

    Started by Eddiew300zx123‎, 07-06-2023 08:40 AM
    1 Attachment(s)
    • 4
    • 177
    Fluff13
    07-06-2023, 03:37 PM Go to last post

  40. [SOLVED] Linking values into an adjacent cell to choices in drop down

    Started by louhazosc‎, 07-05-2023 02:15 PM
    3 Attachment(s)
    • 7
    • 389
    JeteMc
    07-06-2023, 02:57 PM Go to last post

  41. Question External excel file, retrieve value, but change NAME in the URL based on cell B3

    Started by stefanwlb‎, 06-28-2023 10:20 AM
    1 Attachment(s)
    • 2
    • 194
    stefanwlb
    07-06-2023, 02:23 PM Go to last post

  42. [SOLVED] Try to make a dynamic graphic

    Started by Vinhas‎, 07-06-2023 08:21 AM
    5 Attachment(s)
    • 9
    • 254
    Joel Chacko
    07-06-2023, 02:18 PM Go to last post

  43. [SOLVED] Dependent Dropdown List

    Started by mindreader‎, 07-05-2023 06:10 AM
    1 Attachment(s)
    • 4
    • 270
    AliGW
    07-06-2023, 02:16 PM Go to last post

  44. sum product with right formula

    Started by priyaxm‎, 07-05-2023 06:24 AM
    2 Attachment(s)
    • 6
    • 208
    AliGW
    07-06-2023, 02:13 PM Go to last post

  45. [SOLVED] How to rank multi criteria by group uniquely?

    Started by Manith‎, 05-30-2023 01:37 PM
    3 Attachment(s)
    • 6
    • 435
    Manith
    07-06-2023, 12:55 PM Go to last post

  46. Moved: Picking datas from other sheets

    Started by manaberto‎, 07-06-2023 10:53 AM
    •  
    •  

  47. [SOLVED] Drag a formula to increment Column Reference

    Started by admat‎, 07-06-2023 09:57 AM
    3 Attachment(s)
    • 8
    • 167
    admat
    07-06-2023, 10:18 AM Go to last post

  48. Combining the results of two coloured cells into one

    Started by andyz888‎, 07-06-2023 08:53 AM
    1 Attachment(s)
    • 8
    • 181
    AliGW
    07-06-2023, 10:13 AM Go to last post

  49. Post Calculate FTE based on start and end date of employee for a number of years

    Started by SJ654‎, 07-06-2023 06:11 AM
    excel, fte calculation
    • 3
    • 444
    AliGW
    07-06-2023, 09:52 AM Go to last post

  50. [SOLVED] Inexplicable Formula Alerts

    Started by Mvaldesi‎, 07-05-2023 02:19 PM
    1 Attachment(s)
    • 2
    • 224
    Mvaldesi
    07-06-2023, 09:31 AM Go to last post
+ Post New Thread
Page 113 of 5615 FirstFirst ... 113 ...

Forum Information and Options

Users Browsing this Forum

There are currently 76 users browsing this forum. (8 members & 68 guests)

  1. AARR,
  2. Ali4772,
  3. Colin Legg,
  4. juddza,
  5. Phuocam,
  6. RaulSerg,
  7. wassup84,
  8. windknife

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