+ Post New Thread
Page 851 of 5614 FirstFirst ... 851 ...
Threads 42501 to 42550 of 280693

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

  1. Identify run out date and link to week number

    Started by senka311‎, 10-10-2019 05:01 AM
    1 Attachment(s)
    • 3
    • 180
    senka311
    10-10-2019, 07:33 AM Go to last post

  2. Exclamation [SOLVED] Extract multiple strings between different characters

    Started by Phil123456789‎, 09-20-2019 10:19 AM
    extract, extract between strings, extract characters, extract data from cell, extract data from table
    • 9
    • 2,911
    Bosco
    10-10-2019, 07:26 AM Go to last post

  3. Display Calendar from one row into one sheet

    Started by myexcelstar‎, 10-08-2019 11:17 AM
    3 Attachment(s)
    • 5
    • 276
    myexcelstar
    10-10-2019, 07:19 AM Go to last post

  4. Exclamation Duplicates sorted by another column

    Started by martynaaa‎, 10-10-2019 04:26 AM
    • 3
    • 207
    Special-K
    10-10-2019, 06:49 AM Go to last post

  5. [SOLVED] Write a dynamic text based on 3 column

    Started by hessam.p‎, 10-10-2019 02:38 AM
    3 Attachment(s)
    • 5
    • 236
    Glenn Kennedy
    10-10-2019, 03:50 AM Go to last post

  6. [SOLVED] How to add based on competitor and week number

    Started by [email protected]‎, 10-08-2019 09:59 AM
    3 Attachment(s)
    • 8
    • 260
    FDibbins
    10-09-2019, 11:57 PM Go to last post

  7. [SOLVED] Exact Difference of Two Dates

    Started by kmrz‎, 10-08-2019 10:14 PM
    1 Attachment(s)
    • 3
    • 344
    Gregb11
    10-09-2019, 10:41 PM Go to last post

  8. IF AND VLOOKUP Question

    Started by creed1875‎, 10-09-2019 02:00 PM
    • 3
    • 342
    FlameRetired
    10-09-2019, 09:12 PM Go to last post

  9. [SOLVED]Using TEXTJOIN with multiple criterions

    Started by Big_Excel_Noob‎, 10-09-2019 08:24 PM
    • 1
    • 328
    Big_Excel_Noob
    10-09-2019, 08:57 PM Go to last post

  10. [SOLVED] How to get a value in a square matrix with two conditions

    Started by alexlutz‎, 10-09-2019 04:27 PM
    1 Attachment(s)
    • 2
    • 266
    alexlutz
    10-09-2019, 08:11 PM Go to last post

  11. [SOLVED] Find all matches in column A and sum their corresponding values in Column B

    Started by Grizraz‎, 10-09-2019 06:46 PM
    • 2
    • 203
    Grizraz
    10-09-2019, 07:24 PM Go to last post

  12. Question Help Understanding "Return Last Non-Blank Row #" Formula

    Started by Cryptikfox‎, 10-09-2019 01:31 PM
    formula, last non blank row, max, return last row, sumproduct 2 Attachment(s)
    • 4
    • 483
    CAABYYC
    10-09-2019, 05:51 PM Go to last post

  13. time calculation on working hours less weekend

    Started by heber77‎, 10-08-2019 11:11 PM
    • 2
    • 366
    heber77
    10-09-2019, 05:00 PM Go to last post

  14. Sum of empty (or zero) cells in a range of two values

    Started by exadus‎, 10-01-2019 09:02 PM
    7 Attachment(s)
    • 21
    • 453
    FlameRetired
    10-09-2019, 04:41 PM Go to last post

  15. [SOLVED] Capitalize First Letter of All Words and Disregard Rest

    Started by dlc3172‎, 10-09-2019 11:23 AM
    • 10
    • 1,046
    Rick Rothstein
    10-09-2019, 04:40 PM Go to last post

  16. [SOLVED] Using a look-up formula to find the first date among a variaty of dates associated with ID

    Started by Javersoon‎, 10-09-2019 02:10 PM
    date, look up data 1 Attachment(s)
    • 4
    • 388
    Javersoon
    10-09-2019, 04:21 PM Go to last post

  17. [SOLVED] Getting MAX from one dataset within Date Ranges of another

    Started by jrtaylor‎, 10-02-2019 07:48 PM
    maxifs, vlookup 1 Attachment(s)
    • 5
    • 308
    FlameRetired
    10-09-2019, 04:12 PM Go to last post

  18. [SOLVED] Need to run VLookUp with IF Function to get proper rate aout of all different rates

    Started by raviraval86‎, 10-08-2019 05:14 PM
    vlookup, vlookup & if, vlookup & match 4 Attachment(s)
    • 7
    • 549
    Pete_UK
    10-09-2019, 02:34 PM Go to last post

  19. [SOLVED] Lookup with Column and Row Criteria

    Started by eNinjaInTraining‎, 09-26-2019 10:40 AM
    formulas, lookup, multiple criteria 1 Attachment(s)
    • 4
    • 449
    eNinjaInTraining
    10-09-2019, 02:31 PM Go to last post

  20. [SOLVED] Concatenate Two Rows at a Time; Excel not recognizing pattern

    Started by profess‎, 10-09-2019 11:51 AM
    concatenate, pattern recognition, transpose array 1 Attachment(s)
    • 4
    • 715
    Pete_UK
    10-09-2019, 02:27 PM Go to last post

  21. Segmenting a continuously expanding list based on unique values.

    Started by Duct‎, 10-09-2019 08:58 AM
    2 Attachment(s)
    • 1
    • 261
    Bo_Ry
    10-09-2019, 02:20 PM Go to last post

  22. [SOLVED] Date-intervals in =if(and()) function

    Started by Javersoon‎, 09-16-2019 07:54 AM
    date & text formula, if-function
    • 6
    • 372
    Javersoon
    10-09-2019, 01:57 PM Go to last post

  23. [SOLVED] Dynamic Countif Across Columns

    Started by dabrows‎, 10-09-2019 11:48 AM
    1 Attachment(s)
    • 3
    • 272
    dabrows
    10-09-2019, 01:21 PM Go to last post

  24. Add £15 to a value out 7 days in a calendar month , every 7 days out add £15 to a value

    Started by Smarty_Paris‎, 10-09-2019 11:11 AM
    1 Attachment(s)
    • 6
    • 295
    maras_mak
    10-09-2019, 01:18 PM Go to last post

  25. Returning Date based off Value

    Started by KevinYuen08‎, 10-09-2019 11:52 AM
    2 Attachment(s)
    • 1
    • 289
    6StringJazzer
    10-09-2019, 12:45 PM Go to last post

  26. [SOLVED] Help with Dynamic Sum (Sum(Indirect(Index(Match

    Started by mugelbbub‎, 10-09-2019 10:08 AM
    1 Attachment(s)
    • 4
    • 267
    Pete_UK
    10-09-2019, 10:44 AM Go to last post

  27. [SOLVED] Counting number of variants

    Started by jonca‎, 10-09-2019 09:54 AM
    1 Attachment(s)
    • 3
    • 290
    jonca
    10-09-2019, 10:25 AM Go to last post

  28. Mid extract

    Started by hudson andrew‎, 10-09-2019 04:53 AM
    1 Attachment(s)
    • 10
    • 521
    hudson andrew
    10-09-2019, 10:17 AM Go to last post

  29. [SOLVED] IF condition based on column/array

    Started by Naval11‎, 10-09-2019 06:17 AM
    1 Attachment(s)
    • 3
    • 187
    Pete_UK
    10-09-2019, 09:59 AM Go to last post

  30. VAT Calculated from VAT Dropdown List

    Started by AJP90‎, 10-09-2019 06:55 AM
    4 Attachment(s)
    • 11
    • 891
    AJP90
    10-09-2019, 09:48 AM Go to last post

  31. [SOLVED] Multiple Totals In Table At Every Blank Row?

    Started by Ourkid123uk‎, 10-09-2019 08:48 AM
    1 Attachment(s)
    • 5
    • 255
    PaulM100
    10-09-2019, 09:43 AM Go to last post

  32. [SOLVED] XIRR Help - Ignore Cells without Values

    Started by cchase22‎, 08-08-2014 09:03 PM
    xirr 3 Attachment(s)
    • 3
    • 19,778
    operkywall
    10-09-2019, 09:25 AM Go to last post

  33. Pulling nth non zero value in a row?

    Started by spd87‎, 02-21-2014 04:16 PM
    3 Attachment(s)
    • 7
    • 4,197
    ExcelFan117
    10-09-2019, 09:18 AM Go to last post

  34. [SOLVED] Change Date based on due date passed

    Started by Murdo132‎, 10-03-2019 06:08 AM
    2 Attachment(s)
    • 5
    • 382
    JeteMc
    10-09-2019, 08:52 AM Go to last post

  35. [SOLVED] Index & aggregate

    Started by elatreille‎, 10-08-2019 05:48 PM
    index & aggregate 2 Attachment(s)
    • 5
    • 601
    Glenn Kennedy
    10-09-2019, 08:22 AM Go to last post

  36. [SOLVED] How add one more filter?

    Started by vasc‎, 10-07-2019 09:01 AM
    1 Attachment(s)
    • 4
    • 231
    Fluff13
    10-09-2019, 07:58 AM Go to last post

  37. [SOLVED] Shift Rota Help!!

    Started by GordonKy42‎, 10-09-2019 05:59 AM
    2 Attachment(s)
    • 4
    • 308
    WideBoyDixon
    10-09-2019, 07:48 AM Go to last post

  38. [SOLVED] What formula to get the unique value with two criteria.

    Started by felixpanganiban‎, 10-02-2019 12:36 AM
    2 Attachment(s)
    • 6
    • 261
    Glenn Kennedy
    10-09-2019, 07:46 AM Go to last post

  39. How to create a if statement with a iferror statement

    Started by ronald.burke‎, 10-08-2019 11:37 AM
    • 4
    • 427
    Roel Jongman
    10-09-2019, 07:00 AM Go to last post

  40. [SOLVED] How to drag formula with only changing the variables

    Started by Martines91‎, 10-09-2019 05:33 AM
    • 4
    • 285
    Glenn Kennedy
    10-09-2019, 06:42 AM Go to last post

  41. [SOLVED] Catch Data base on date

    Started by azbi‎, 09-30-2019 05:40 AM
    4 Attachment(s)
    • 20
    • 473
    Glenn Kennedy
    10-09-2019, 06:30 AM Go to last post

  42. IF functions to give "Outlier" and a percentage?

    Started by Anna79‎, 10-08-2019 05:12 AM
    • 16
    • 704
    Richard Buttrey
    10-09-2019, 05:17 AM Go to last post

  43. Post [SOLVED] SUMPRODUCT, using INDEX MATCH to find column, return #Value with blank cells

    Started by Giegie‎, 10-09-2019 12:31 AM
    sumproduct #value! error, sumproduct index match 1 Attachment(s)
    • 5
    • 1,343
    Giegie
    10-09-2019, 05:13 AM Go to last post

  44. [SOLVED] Merge 2 worksheets with 1 matching column

    Started by Funkymonkey0073‎, 08-29-2019 10:50 AM
    1 Attachment(s)
    • 1
    • 220
    Funkymonkey0073
    10-09-2019, 04:50 AM Go to last post

  45. [SOLVED] Match data and extract

    Started by viciousvixen‎, 10-08-2019 07:16 AM
    • 2
    • 218
    viciousvixen
    10-09-2019, 04:49 AM Go to last post

  46. Help to match two data sets

    Started by signekolind‎, 10-07-2019 08:41 AM
    1 Attachment(s)
    • 6
    • 259
    Pete_UK
    10-09-2019, 04:47 AM Go to last post

  47. Help with a formulae

    Started by Jwelfincho‎, 10-09-2019 04:11 AM
    • 3
    • 267
    Glenn Kennedy
    10-09-2019, 04:45 AM Go to last post

  48. [SOLVED] How to change the date & time in Excel

    Started by grim72‎, 10-09-2019 03:59 AM
    time and date formulas
    • 2
    • 247
    grim72
    10-09-2019, 04:18 AM Go to last post

  49. Result of SUM function is not working correctly (SUM Time )

    Started by Emil85‎, 10-09-2019 03:18 AM
    1 Attachment(s)
    • 2
    • 190
    XLent
    10-09-2019, 03:53 AM Go to last post

  50. [SOLVED] Complex Formula for Auto-populating function

    Started by g.costapinto‎, 10-08-2019 07:39 AM
    autopopulate, complex formula/array, list 2 Attachment(s)
    • 4
    • 486
    g.costapinto
    10-09-2019, 03:46 AM Go to last post
+ Post New Thread
Page 851 of 5614 FirstFirst ... 851 ...

Forum Information and Options

Users Browsing this Forum

There are currently 43 users browsing this forum. (6 members & 37 guests)

  1. 9411john,
  2. AliGW,
  3. angelosison00,
  4. Phuocam,
  5. RaulSerg,
  6. Sam Capricci

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