+ Post New Thread
Page 402 of 5619 FirstFirst ... 402 ...
Threads 20051 to 20100 of 280921

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

  1. [SOLVED] If then statement

    Started by cdh1234‎, 02-12-2018 05:28 PM
    2 Attachment(s)
    • 11
    • 538
    cdh1234
    02-19-2018, 01:02 PM Go to last post

  2. [SOLVED] Dynamic Lists

    Started by squatcher‎, 01-24-2018 04:13 PM
    dynamic list, hlookup, populating, vlookup 10 Attachment(s)
    • 11
    • 858
    JeteMc
    02-01-2018, 11:16 PM Go to last post

  3. E-Shop PoD Formula

    Started by rafel7‎, 01-24-2018 01:39 PM
    5 Attachment(s)
    • 11
    • 653
    rafel7
    01-28-2018, 08:59 AM Go to last post

  4. Question [SOLVED] Too few arguments - combination of COUNTIFS and OR

    Started by ell_‎, 01-29-2018 08:36 PM
    countifs, excel, formula
    • 11
    • 1,564
    ben_hensel
    02-01-2018, 11:53 AM Go to last post

  5. Help using solver for product allocation

    Started by cg2021‎, 01-31-2018 06:53 AM
    4 Attachment(s)
    • 11
    • 726
    Alf
    02-06-2018, 07:50 AM Go to last post

  6. Question Combine Rows into One if =

    Started by plank22‎, 02-01-2018 07:48 AM
    3 Attachment(s)
    • 11
    • 703
    Sam Capricci
    02-01-2018, 11:13 AM Go to last post

  7. [SOLVED] Index........match.............max!

    Started by Minitrader‎, 02-02-2018 05:39 PM
    index, match, max 2 Attachment(s)
    • 11
    • 573
    JohnTopley
    02-03-2018, 06:35 AM Go to last post

  8. compare lists

    Started by vba_beckie‎, 02-09-2018 08:31 AM
    4 Attachment(s)
    • 11
    • 456
    vba_beckie
    02-09-2018, 02:39 PM Go to last post

  9. [SOLVED] Count for unique value with condition

    Started by rchure‎, 02-12-2018 06:17 AM
    1 Attachment(s)
    • 11
    • 474
    AliGW
    02-12-2018, 08:15 AM Go to last post

  10. [SOLVED] Not sure if countif Would work

    Started by justinwb‎, 02-09-2018 04:34 AM
    2 Attachment(s)
    • 11
    • 407
    sktneer
    02-09-2018, 10:43 PM Go to last post

  11. Red face [SOLVED] Look up, Match question

    Started by kingpeejay‎, 02-09-2018 07:44 AM
    2 Attachment(s)
    • 11
    • 441
    AliGW
    02-16-2018, 06:09 AM Go to last post

  12. [SOLVED] Indirect Formula

    Started by rizmomin‎, 02-11-2018 10:20 AM
    3 Attachment(s)
    • 11
    • 386
    Root_
    02-11-2018, 12:01 PM Go to last post

  13. [SOLVED] Rankings with Offset

    Started by roskalov‎, 11-10-2017 08:19 AM
    4 Attachment(s)
    • 11
    • 934
    JeteMc
    11-14-2017, 08:29 AM Go to last post

  14. Find cell position on table

    Started by xatzizoi‎, 02-14-2018 07:08 PM
    1 Attachment(s)
    • 11
    • 664
    shukla.ankur281190
    02-15-2018, 03:28 AM Go to last post

  15. A COMBINE Formula in Sorted Fashion

    Started by Taisir‎, 02-16-2018 10:09 AM
    5 Attachment(s)
    • 11
    • 479
    Taisir
    02-21-2018, 05:46 AM Go to last post

  16. [SOLVED] Last day of each month

    Started by leovilla‎, 02-16-2018 02:33 PM
    3 Attachment(s)
    • 11
    • 831
    Czeslaw
    02-16-2018, 03:46 PM Go to last post

  17. [SOLVED] Connecting a formula to a combo box

    Started by roxdrob01‎, 02-18-2018 03:03 PM
    2 Attachment(s)
    • 11
    • 405
    roxdrob01
    02-18-2018, 04:18 PM Go to last post

  18. Calculating (4Threads) - my Excel Sheet is not calculating correctly

    Started by cupoftee‎, 06-22-2021 04:54 PM
    2 Attachment(s)
    • 11
    • 318
    kvsrinivasamurthy
    06-23-2021, 06:55 AM Go to last post

  19. [SOLVED] automated staining of cells by means of a variable comparison value

    Started by norbidangel‎, 07-12-2021 05:42 AM
    conditional formatting 2 Attachment(s)
    • 11
    • 379
    AliGW
    07-12-2021, 10:35 AM Go to last post

  20. [SOLVED] Rank according to their average sales, if Active

    Started by TPS‎, 06-26-2021 12:26 AM
    2 Attachment(s)
    • 11
    • 289
    AliGW
    06-27-2021, 03:24 AM Go to last post

  21. [SOLVED] Determine value from multiple column conditions

    Started by cableghost‎, 06-22-2021 10:27 PM
    conditions 2 Attachment(s)
    • 11
    • 412
    cableghost
    06-23-2021, 07:17 PM Go to last post

  22. [SOLVED] Formula to copy data from one sheet to another

    Started by ChrisXcel‎, 06-26-2021 09:33 PM
    2 Attachment(s)
    • 11
    • 478
    ChrisXcel
    06-29-2021, 01:34 PM Go to last post

  23. [SOLVED] Default value of a cell determined by List in Data Validation.

    Started by Trond64‎, 07-11-2021 05:06 AM
    2 Attachment(s)
    • 11
    • 336
    Trond64
    07-11-2021, 10:22 AM Go to last post

  24. [SOLVED] Extracting the first, middle and last words in a string / sentence

    Started by smart_beta‎, 06-29-2021 05:11 AM
    1 Attachment(s)
    • 11
    • 366
    JohnTopley
    07-06-2021, 04:23 AM Go to last post

  25. Formula changes in Table

    Started by TheScott‎, 07-02-2021 07:52 AM
    2 Attachment(s)
    • 11
    • 296
    Glenn Kennedy
    07-02-2021, 04:48 PM Go to last post

  26. Formula to calculate cost based on increasing scale

    Started by shenshall‎, 10-03-2013 11:10 PM
    2 Attachment(s)
    • 11
    • 1,176
    FDibbins
    10-04-2013, 12:05 AM Go to last post

  27. Post [SOLVED] Calculate response time in working hours between two dates

    Started by ajagibson‎, 06-28-2012 11:47 AM
    1 Attachment(s)
    • 11
    • 8,970
    kvsrinivasamurthy
    06-28-2021, 08:45 AM Go to last post

  28. Looking for correct calendar formula engl. vs. german

    Started by excelianer‎, 11-09-2012 06:13 AM
    1 Attachment(s)
    • 11
    • 1,263
    excelianer
    11-13-2012, 02:38 PM Go to last post

  29. Count whole numbers

    Started by ianhal82‎, 09-19-2013 09:13 AM
    3 Attachment(s)
    • 11
    • 1,718
    ianhal82
    09-20-2013, 06:12 AM Go to last post

  30. Vlookup subtraction from a cell

    Started by damagas‎, 06-21-2013 04:31 AM
    1 Attachment(s)
    • 11
    • 6,139
    AliGW
    07-13-2021, 05:24 AM Go to last post

  31. [SOLVED] Seperate a info in a cell with formula or script

    Started by Crispy85‎, 10-01-2013 03:20 AM
    4 Attachment(s)
    • 11
    • 755
    martindwilson
    10-01-2013, 05:45 AM Go to last post

  32. [SOLVED] SumIf not working here..

    Started by mhoot20‎, 09-25-2013 07:59 PM
    3 Attachment(s)
    • 11
    • 1,194
    kvsrinivasamurthy
    09-28-2013, 12:31 AM Go to last post

  33. [SOLVED] Change a date cell to red?

    Started by lurchybold‎, 10-02-2013 06:35 AM
    2 Attachment(s)
    • 11
    • 694
    lurchybold
    10-02-2013, 09:46 AM Go to last post

  34. [SOLVED] Formula to subtract duration from fixed time

    Started by TopDog0310‎, 09-19-2013 06:30 PM
    6 Attachment(s)
    • 11
    • 1,903
    Greg M
    09-22-2013, 04:19 PM Go to last post

  35. Question about counting cell thats have two different text in two different columns

    Started by rgrocks‎, 09-19-2013 07:44 PM
    1 Attachment(s)
    • 11
    • 787
    Tony Valko
    09-20-2013, 10:13 AM Go to last post

  36. Vlookup with multiple matches

    Started by amyliz421‎, 09-20-2013 05:38 PM
    1 Attachment(s)
    • 11
    • 1,762
    Tony Valko
    09-24-2013, 06:41 PM Go to last post

  37. [SOLVED] Returning matching keywords

    Started by sathishkm‎, 09-24-2013 02:43 PM
    5 Attachment(s)
    • 11
    • 635
    hemesh
    09-24-2013, 04:51 PM Go to last post

  38. [SOLVED] SUMPRODUCT Based on two tables

    Started by NapB9‎, 09-25-2013 11:53 AM
    2 Attachment(s)
    • 11
    • 4,353
    AlKey
    09-25-2013, 04:06 PM Go to last post

  39. Nested IF formula for sliding commission scale

    Started by tmva‎, 01-02-2018 03:40 PM
    • 11
    • 844
    FlameRetired
    01-02-2018, 04:35 PM Go to last post

  40. Deleting specific rows

    Started by divalasvegas‎, 10-04-2013 12:30 AM
    • 11
    • 602
    Trebor76
    10-04-2013, 01:57 AM Go to last post

  41. Partially "transpose" rows with formula

    Started by Emma_B‎, 06-27-2014 05:30 PM
    3 Attachment(s)
    • 11
    • 1,412
    Emma_B
    07-03-2014, 09:23 PM Go to last post

  42. Stop when a value is reached

    Started by tommycasper‎, 07-06-2014 03:23 AM
    4 Attachment(s)
    • 11
    • 1,322
    oeldere
    07-06-2014, 10:05 AM Go to last post

  43. [SOLVED] VLookUp need to look at first entry and skip empty cells in Col_Index_Num

    Started by Colin Smit‎, 07-09-2014 06:31 AM
    3 Attachment(s)
    • 11
    • 1,271
    Colin Smit
    07-10-2014, 06:37 AM Go to last post

  44. Match/Index Multiple Columns

    Started by fredlo2010‎, 12-10-2014 03:30 PM
    2 Attachment(s)
    • 11
    • 856
    AliGW
    02-15-2018, 03:43 AM Go to last post

  45. Question Count textual values with 2 conditions

    Started by Mister-Vinyl‎, 12-16-2015 11:16 AM
    1 Attachment(s)
    • 11
    • 834
    Yadavgiri
    12-16-2015, 03:49 PM Go to last post

  46. [SOLVED] Create a stats page in a workbook driven by specific date criteria

    Started by mlski4751‎, 12-28-2015 10:58 AM
    4 Attachment(s)
    • 11
    • 814
    FlameRetired
    12-29-2015, 03:49 PM Go to last post

  47. Thumbs up [SOLVED] max name string in column

    Started by daboho‎, 01-02-2016 05:23 AM
    1 Attachment(s)
    • 11
    • 729
    JBeaucaire
    01-02-2016, 02:20 PM Go to last post

  48. Find Qty_On_Hand value for a certain Loc

    Started by shootland‎, 01-04-2016 03:10 PM
    3 Attachment(s)
    • 11
    • 770
    shootland
    01-07-2016, 02:21 PM Go to last post

  49. [SOLVED] Calculation results on a cell

    Started by Berna11‎, 07-03-2021 12:13 PM
    5 Attachment(s)
    • 11
    • 402
    JohnTopley
    07-04-2021, 06:32 AM Go to last post

  50. [SOLVED] Function to extract hour from non standard DateTime

    Started by webwyzard‎, 02-05-2018 05:03 PM
    • 11
    • 432
    AliGW
    02-06-2018, 08:22 AM Go to last post
+ Post New Thread
Page 402 of 5619 FirstFirst ... 402 ...

Forum Information and Options

Users Browsing this Forum

There are currently 97 users browsing this forum. (4 members & 93 guests)

  1. Cazzdevil,
  2. cpszx,
  3. Danilo Flaiban,
  4. jaredino

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