+ Post New Thread
Page 1501 of 5614 FirstFirst ... 1501 ...
Threads 75001 to 75050 of 280690

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. [SOLVED] Sum score by criteria

    Started by thursday140‎, 09-09-2019 08:08 AM
    1 Attachment(s)
    • 5
    • 376
    davsth
    09-23-2019, 06:22 AM Go to last post

  2. How to Keep Formula in Cells when you delete a value

    Started by pmbixler‎, 07-17-2016 02:49 AM
    • 5
    • 1,077
    FDibbins
    07-18-2016, 12:15 AM Go to last post

  3. [SOLVED] Breakeven Point

    Started by mrcois‎, 07-21-2016 08:38 AM
    1 Attachment(s)
    • 5
    • 546
    CAntosh
    07-21-2016, 01:05 PM Go to last post

  4. Find a match and return a value

    Started by htown‎, 07-19-2016 12:23 PM
    • 5
    • 547
    FDibbins
    07-21-2016, 12:09 AM Go to last post

  5. Remove or extract the first 4 spaces in a cell see example

    Started by gamurphy64‎, 07-21-2016 05:01 PM
    formula, text
    • 5
    • 696
    AlKey
    07-21-2016, 05:23 PM Go to last post

  6. [SOLVED] Select and Extract a line of Data in a Table to Populate a Template Worksheet

    Started by DGAlamo‎, 07-20-2016 01:14 AM
    3 Attachment(s)
    • 5
    • 454
    MarvinP
    07-20-2016, 11:30 AM Go to last post

  7. [SOLVED] how to collect data from different cells in sheet 1 to one cell in sheet2

    Started by mazan2010‎, 07-18-2016 03:07 PM
    2 Attachment(s)
    • 5
    • 631
    CAntosh
    07-21-2016, 10:22 AM Go to last post

  8. [SOLVED] Productivity-Inventory tracking - How much per month used if this?

    Started by clevername1‎, 07-19-2016 11:43 AM
    2 Attachment(s)
    • 5
    • 428
    JohnTopley
    07-19-2016, 02:20 PM Go to last post

  9. [SOLVED] Array formula syntax

    Started by 180drft‎, 07-19-2016 06:48 PM
    1 Attachment(s)
    • 5
    • 386
    Phuocam
    07-19-2016, 09:18 PM Go to last post

  10. Using an asterisk

    Started by NDmad‎, 07-20-2016 03:17 PM
    asterisk, equation, sumifs, wildcard, wildcard characters
    • 5
    • 1,056
    Tony Valko
    07-20-2016, 05:14 PM Go to last post

  11. [SOLVED] IF statement using OR?

    Started by Exequiel3k‎, 07-26-2016 10:38 AM
    • 5
    • 377
    Exequiel3k
    07-26-2016, 11:11 AM Go to last post

  12. Excel Formula using dates

    Started by dz081699‎, 07-26-2016 08:11 PM
    • 5
    • 509
    Phuocam
    07-27-2016, 12:04 AM Go to last post

  13. Question [SOLVED] Complex IF function

    Started by roskalov‎, 07-28-2016 07:23 AM
    formula, if function, issue, problem, question 2 Attachment(s)
    • 5
    • 789
    JohnTopley
    07-28-2016, 08:20 AM Go to last post

  14. [SOLVED] What formulas can I use to find matches based on multiple criteria

    Started by Jonathan68‎, 07-21-2014 01:00 PM
    excel2010, formula, match, match and index, multiple matches 1 Attachment(s)
    • 5
    • 974
    Jonmo1
    07-21-2014, 02:22 PM Go to last post

  15. [SOLVED] Having problem while filling data from a sheet into another.

    Started by Mark00963‎, 09-25-2019 04:30 AM
    2 Attachment(s)
    • 5
    • 193
    Richard Buttrey
    09-25-2019, 11:56 AM Go to last post

  16. Lookup latest date based on criteria (no arrays)

    Started by dbl_dbl‎, 09-18-2019 03:44 PM
    1 Attachment(s)
    • 5
    • 281
    FlameRetired
    09-20-2019, 01:15 PM Go to last post

  17. Post IF Formula based on Drop Down Value

    Started by mayankhdawar‎, 09-19-2019 04:06 AM
    1 Attachment(s)
    • 5
    • 329
    JeteMc
    09-25-2019, 10:02 AM Go to last post

  18. [SOLVED] IF AND Formula for Criteria and End Result

    Started by rz6657‎, 09-22-2019 09:58 AM
    1 Attachment(s)
    • 5
    • 318
    BanginMyHeadOnMyDesk
    09-22-2019, 10:25 AM Go to last post

  19. [SOLVED] Blank cell condition in formula

    Started by UltimateNeo‎, 09-22-2019 11:11 AM
    blanks, formula
    • 5
    • 395
    Fluff13
    09-22-2019, 12:03 PM Go to last post

  20. Deduct sales from a stock inventory

    Started by Atish304‎, 09-23-2019 02:27 AM
    3 Attachment(s)
    • 5
    • 570
    Atish304
    09-23-2019, 06:11 AM Go to last post

  21. [SOLVED] Problem getting date-value to combined text-cell

    Started by perssa88‎, 09-23-2019 04:48 AM
    1 Attachment(s)
    • 5
    • 268
    PaulM100
    09-23-2019, 05:12 AM Go to last post

  22. [SOLVED] Countifs > Today()

    Started by KErasmus‎, 09-23-2019 06:53 AM
    1 Attachment(s)
    • 5
    • 274
    KOKOSEK
    09-23-2019, 07:49 AM Go to last post

  23. [SOLVED] Format not staying in files .xlsm ?

    Started by NickNunes‎, 09-23-2019 07:54 AM
    • 5
    • 327
    FDibbins
    09-25-2019, 12:55 AM Go to last post

  24. [SOLVED] SUM(SUMIFS(Multiple Crireria

    Started by KErasmus‎, 09-25-2019 07:31 AM
    1 Attachment(s)
    • 5
    • 238
    CARACALLA
    09-25-2019, 09:28 AM Go to last post

  25. Extracting Specific data from a table

    Started by Narghile‎, 09-25-2019 10:41 PM
    data dump, index, vlookup 2 Attachment(s)
    • 5
    • 379
    FlameRetired
    09-26-2019, 12:29 PM Go to last post

  26. Extract Alphabets and Numbers from a Cell

    Started by tahir4awan‎, 10-20-2012 11:14 PM
    • 5
    • 817
    Jakobshavn
    10-21-2012, 10:35 PM Go to last post

  27. Worksheet Selections in Macros

    Started by Duke Carey‎, 09-06-2005 03:05 AM
    • 5
    • 488
    Duke Carey
    09-06-2005, 07:05 PM Go to last post

  28. Alternating sequences for the whole year? (not sure how to best describe what I need)

    Started by CJ08‎, 09-23-2012 07:02 PM
    2 Attachment(s)
    • 5
    • 756
    CJ08
    10-20-2012, 12:13 PM Go to last post

  29. how to increase a number by 1 each day?

    Started by stevoplaystation‎, 09-27-2012 10:15 AM
    • 5
    • 2,455
    Jakobshavn
    10-21-2012, 10:26 PM Go to last post

  30. Identify in a column when the same number appears more than 10 times in a row

    Started by bing77025‎, 10-20-2012 07:03 PM
    1 Attachment(s)
    • 5
    • 1,001
    bing77025
    10-22-2012, 10:26 PM Go to last post

  31. [SOLVED] type data in one cell, it also appears in another

    Started by OCcat‎, 10-20-2012 09:10 AM
    1 Attachment(s)
    • 5
    • 5,635
    Cutter
    10-21-2012, 11:49 AM Go to last post

  32. [SOLVED] Formula help : Sort by number range and then allocate different coloured cells

    Started by gandk‎, 10-17-2012 07:38 PM
    1 Attachment(s)
    • 5
    • 959
    prasadavasare
    10-22-2012, 01:38 AM Go to last post

  33. Combine data.....please help

    Started by PaulMc2012‎, 10-19-2012 10:10 AM
    1 Attachment(s)
    • 5
    • 452
    FDibbins
    10-19-2012, 01:58 PM Go to last post

  34. Post [SOLVED] Creation of 2 different validationlists from 1 dropdownlist

    Started by Sophus‎, 10-22-2012 04:53 AM
    1 Attachment(s)
    • 5
    • 507
    Nels
    10-23-2012, 01:05 PM Go to last post

  35. [SOLVED] Display cells 12 months prior and 12 months post from a given date

    Started by hog77‎, 10-18-2012 07:12 AM
    2 Attachment(s)
    • 5
    • 701
    hog77
    10-20-2012, 06:25 AM Go to last post

  36. [SOLVED] formula needed to sum between three criteria

    Started by Brianwil‎, 10-20-2012 07:27 AM
    2 Attachment(s)
    • 5
    • 899
    Brianwil
    10-21-2012, 05:52 AM Go to last post

  37. [SOLVED] Nested AND function within IF function is only addressing logical1 but not logical2

    Started by betic‎, 10-18-2012 01:08 PM
    1 Attachment(s)
    • 5
    • 932
    betic
    10-20-2012, 09:17 AM Go to last post

  38. [SOLVED] If Cell Equals A, [Do this calculation], if Cell Equals B, [Do this Calculation]

    Started by brat42‎, 10-19-2012 04:42 PM
    • 5
    • 2,553
    Cutter
    10-20-2012, 05:01 PM Go to last post

  39. [SOLVED] Match criteria and SUMIF Help

    Started by Quinny5114‎, 07-20-2014 06:29 PM
    2 Attachment(s)
    • 5
    • 508
    FDibbins
    07-20-2014, 07:31 PM Go to last post

  40. [SOLVED] Help with a formula to extract text

    Started by SEMMatt‎, 10-23-2012 09:42 AM
    • 5
    • 449
    eisayew
    10-23-2012, 11:10 AM Go to last post

  41. [SOLVED] Define a range of fixed number of columns, but unlimited number of rows

    Started by ccopac‎, 10-22-2012 01:29 PM
    fixed rows, range, unlimited columns
    • 5
    • 2,196
    tigeravatar
    10-22-2012, 02:23 PM Go to last post

  42. [SOLVED] Sum adds rather than subtracts negative numbers?

    Started by innatedoc‎, 10-22-2012 07:37 PM
    2 Attachment(s)
    • 5
    • 483
    innatedoc
    10-23-2012, 01:31 AM Go to last post

  43. [SOLVED] Data validation list disappears after save if referencing another tab

    Started by vikefan82‎, 10-26-2012 06:03 PM
    • 5
    • 41,462
    TMS
    10-26-2012, 06:59 PM Go to last post

  44. [SOLVED] Multiple if function with date range

    Started by oscarbunny‎, 10-27-2012 11:02 AM
    • 5
    • 1,290
    jeffreybrown
    10-27-2012, 01:42 PM Go to last post

  45. [SOLVED] Formula for Buckling Load

    Started by thatshowifeel‎, 10-28-2012 09:43 AM
    buckling load, cross sectional area, length of column 1 Attachment(s)
    • 5
    • 6,760
    Cutter
    10-28-2012, 02:02 PM Go to last post

  46. Condensing data in new sheet by removing blank rows

    Started by Ghost Of Casper‎, 06-24-2013 04:47 PM
    1 Attachment(s)
    • 5
    • 949
    alansidman
    06-27-2013, 05:54 PM Go to last post

  47. Formula to recognise one word from multiple words in the same cell

    Started by JLucy‎, 06-27-2013 05:30 AM
    1 Attachment(s)
    • 5
    • 922
    Richard Buttrey
    06-27-2013, 11:48 AM Go to last post

  48. [SOLVED] Multiple criteria lookup??

    Started by jjm90sc‎, 06-27-2013 02:07 PM
    4 Attachment(s)
    • 5
    • 462
    jjm90sc
    06-27-2013, 08:56 PM Go to last post

  49. [SOLVED] Trouble with ranking and ties

    Started by cmardal‎, 07-18-2014 01:44 PM
    2 Attachment(s)
    • 5
    • 548
    Tony Valko
    07-18-2014, 07:19 PM Go to last post

  50. Can I auto fill a cell in one worksheet by typing a code number

    Started by Dave Peterson‎, 09-06-2005 11:05 AM
    • 5
    • 456
    Dave Peterson
    09-06-2005, 07:05 PM Go to last post
+ Post New Thread
Page 1501 of 5614 FirstFirst ... 1501 ...

Forum Information and Options

Users Browsing this Forum

There are currently 56 users browsing this forum. (3 members & 53 guests)

  1. etaf,
  2. Phuocam,
  3. Rick Rothstein

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