+ Post New Thread
Page 12 of 5614 FirstFirst ... 12 ...
Threads 551 to 600 of 280685

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

  1. Automatic insert of forward slash (/)

    Started by Shivas Regal‎, 09-08-2010 03:57 PM
    • 8
    • 30,801
    DonkeyOte
    09-08-2010, 04:27 PM Go to last post

  2. What is the maximum number of characters you can concatenate together...

    Started by xibalba‎, 07-04-2012 05:03 PM
    2 Attachment(s)
    • 9
    • 30,790
    xibalba
    05-27-2017, 03:35 AM Go to last post

  3. vlookup question, if N/A then = 0???

    Started by txbullets‎, 11-29-2007 11:39 AM
    • 3
    • 30,772
    txbullets
    11-29-2007, 12:30 PM Go to last post

  4. [SOLVED] Sumproduct not working

    Started by yuenk‎, 12-22-2016 11:47 AM
    4 Attachment(s)
    • 11
    • 30,753
    dflak
    12-23-2016, 09:28 AM Go to last post

  5. How to create a summary sheet that will auto-populate as new tabs are added?

    Started by mjewett‎, 04-24-2013 07:36 PM
    auto-fill, auto-populate, code, macro, summary 1 Attachment(s)
    • 4
    • 30,740
    newdoverman
    05-02-2013, 04:39 PM Go to last post

  6. [SOLVED] PERCENTILE.INC and PERCENTILE.EXC - difference

    Started by Saturn‎, 08-19-2012 04:44 AM
    • 3
    • 30,668
    Ace_XL
    08-19-2012, 11:34 AM Go to last post

  7. [SOLVED] VLOOKUP returning 0!

    Started by rayted‎, 03-15-2018 05:03 AM
    vlookup 2 Attachment(s)
    • 13
    • 30,657
    Pete_UK
    03-15-2018, 11:03 AM Go to last post

  8. how do i unhide column after saving file

    Started by moodysmb‎, 08-11-2005 08:05 PM
    • 10
    • 30,654
    moodysmb
    08-11-2005, 11:05 PM Go to last post

  9. Calculating Alpha & Beta For Investment

    Started by Vlad111‎, 01-28-2008 06:02 PM
    • 1
    • 30,610
    janschepens
    04-12-2012, 06:25 PM Go to last post

  10. How do you avoid duplicates when using the randbetween function?

    Started by Monica‎, 02-15-2006 06:25 PM
    • 3
    • 30,609
    mukeshyadav
    09-28-2014, 02:07 AM Go to last post

  11. [SOLVED] Formula to count values in single cell separated by commas

    Started by aimeecrystalaid‎, 09-08-2013 11:06 PM
    cells, count, single cell, sum, values
    • 8
    • 30,502
    protonLeah
    06-25-2017, 01:01 AM Go to last post

  12. [SOLVED] "END mode?"

    Started by Brian Synowiec‎, 09-06-2005 12:05 AM
    • 6
    • 30,472
    arthurbr
    10-11-2011, 02:06 AM Go to last post

  13. Smile If a cell equals any cell within range, 1

    Started by beboppin‎, 01-05-2011 04:59 PM
    • 3
    • 30,438
    gwmills
    04-05-2016, 10:54 AM Go to last post

  14. [SOLVED] sumproduct between two dates

    Started by chased‎, 07-07-2005 04:05 PM
    • 4
    • 30,334
    chased
    07-08-2005, 01:05 PM Go to last post

  15. Formula to solve for "X"

    Started by maacmaac‎, 11-09-2007 05:02 PM
    • 2
    • 30,309
    ChemistB
    11-09-2007, 05:44 PM Go to last post

  16. [SOLVED] SUMIF over Multiple Columns

    Started by Musiclover119‎, 05-09-2017 01:48 AM
    sumif 2 Attachment(s)
    • 14
    • 30,288
    Pepe Le Mokko
    04-07-2020, 02:35 AM Go to last post

  17. Unhappy Percentile...IF

    Started by brook1‎, 11-16-2006 05:10 AM
    • 3
    • 30,268
    Dav
    11-16-2006, 06:52 AM Go to last post

  18. rule of 78?

    Started by aceee‎, 04-02-2008 02:17 AM
    • 5
    • 30,156
    ratcat
    04-03-2008, 08:25 AM Go to last post

  19. SUMIF Excluding hidden rows

    Started by TREMA‎, 08-21-2008 10:47 PM
    • 4
    • 30,128
    TREMA
    08-27-2008, 08:54 PM Go to last post

  20. RANK, duplicate ranking but no gaps in rank

    Started by arron laing‎, 06-13-2006 03:03 AM
    • 7
    • 30,122
    arlu1201
    06-06-2012, 07:15 AM Go to last post

  21. find two (2) lowest values in a range (Excel)

    Started by Bob in Carson‎, 08-14-2006 09:30 PM
    • 3
    • 30,074
    Biff
    08-14-2006, 11:30 PM Go to last post

  22. [SOLVED] strike out feature in excel

    Started by chits‎, 03-12-2005 05:06 AM
    • 2
    • 30,071
    David McRitchie
    03-12-2005, 12:07 PM Go to last post

  23. Countif with Merged Cells

    Started by Alexander_Read‎, 09-05-2008 06:28 AM
    3 Attachment(s)
    • 7
    • 30,071
    Alexander_Read
    09-08-2008, 07:29 AM Go to last post

  24. How do I have Excel calculate units per hour?

    Started by chamber12‎, 12-13-2012 08:49 PM
    1 Attachment(s)
    • 9
    • 30,045
    TMS
    12-13-2012, 10:42 PM Go to last post

  25. [SOLVED] Excel formula to move certain fields

    Started by kimtruss‎, 04-20-2006 10:00 PM
    • 4
    • 30,037
    Gord Dibben
    04-21-2006, 02:55 PM Go to last post

  26. Answer:How do I calculate # of weeks between 2 dates in excel?

    Started by Anne Troy‎, 09-06-2005 01:05 AM
    • 6
    • 29,970
    Linda
    09-06-2005, 07:05 AM Go to last post

  27. Count if ('true) does not work

    Started by JMod‎, 01-17-2006 07:15 PM
    • 5
    • 29,958
    olasa
    06-14-2013, 07:58 PM Go to last post

  28. Problem with GEOMEAN - returns #NUM error

    Started by Dan Knight‎, 02-18-2005 10:06 AM
    • 6
    • 29,955
    Harlan Grove
    02-18-2005, 10:06 AM Go to last post

  29. How do I protect formulas from being deleted?

    Started by Connie‎, 05-09-2006 06:20 PM
    • 2
    • 29,933
    Connie
    05-09-2006, 08:10 PM Go to last post

  30. Birthday to age calculation/formula

    Started by sweetthing4luc‎, 03-16-2009 04:10 PM
    • 3
    • 29,920
    cheenuvasan
    12-28-2009, 09:20 AM Go to last post

  31. Finding the percentage difference of two or more numbers

    Started by slr‎, 01-25-2006 11:27 AM
    • 5
    • 29,736
    Bob Miller
    01-26-2006, 11:40 AM Go to last post

  32. Random Time Generator

    Started by optionistic‎, 11-16-2008 09:38 PM
    • 3
    • 29,732
    matt905
    01-10-2011, 05:27 PM Go to last post

  33. [SOLVED] Formula to change full state name to abbreviation

    Started by 47magic‎, 02-16-2009 01:59 PM
    1 Attachment(s)
    • 2
    • 29,715
    jlynch401
    01-25-2020, 05:55 PM Go to last post

  34. Average formula with positive and negative numbers

    Started by lovebeingtan‎, 07-29-2012 07:39 PM
    • 4
    • 29,709
    vlady
    07-29-2012, 08:28 PM Go to last post

  35. [SOLVED] SUMIF exluding text

    Started by Father‎, 12-28-2005 06:40 PM
    • 12
    • 29,699
    FDibbins
    04-26-2016, 12:18 AM Go to last post

  36. XIRR returns zero instead of a negative when ending value is less than total contributions

    Started by kylc3‎, 10-19-2017 04:40 PM
    1 Attachment(s)
    • 3
    • 29,675
    joeu2004
    10-21-2017, 04:03 AM Go to last post

  37. [SOLVED] Sumproduct to ignore blanks

    Started by Dgp2012‎, 10-21-2013 10:41 AM
    1 Attachment(s)
    • 10
    • 29,661
    Gergosaurus
    03-16-2020, 02:07 PM Go to last post

  38. Formula for aging

    Started by arnab0711‎, 02-03-2010 01:37 AM
    1 Attachment(s)
    • 8
    • 29,643
    Glenn Kennedy
    02-11-2024, 06:59 AM Go to last post

  39. [SOLVED] Monthly Return Stream - Annualized

    Started by MCII‎, 12-07-2015 01:49 PM
    • 2
    • 29,566
    MCII
    12-08-2015, 10:41 AM Go to last post

  40. Vlookup Error "The cell currently being evaluated contains a constant"

    Started by IAntoniazi‎, 05-19-2017 05:16 PM
    formula, vlookup
    • 3
    • 29,453
    IAntoniazi
    05-23-2017, 11:12 AM Go to last post

  41. [SOLVED] Solver Constraint If statement workaround

    Started by tdanner1993‎, 07-20-2016 06:25 PM
    binary, solver, solver constraint, solver constraints 5 Attachment(s)
    • 16
    • 29,451
    FDibbins
    01-19-2023, 01:43 AM Go to last post

  42. Sort by last 2 digits

    Started by mbparks‎, 02-18-2005 10:06 AM
    • 4
    • 29,409
    mbparks
    02-18-2005, 10:06 AM Go to last post

  43. SUMIFS returns VALUE!

    Started by mogdog1981‎, 06-04-2010 08:10 AM
    sumifs, value!
    • 6
    • 29,394
    teylyn
    02-03-2011, 04:38 AM Go to last post

  44. On a excel protected worksheet, how do I change the tab order?

    Started by vikgarden‎, 04-07-2005 11:06 AM
    • 4
    • 29,382
    Deputysherrif
    03-27-2017, 08:11 AM Go to last post

  45. sum column containing both text and numbers

    Started by cbuck‎, 04-04-2006 11:25 AM
    • 4
    • 29,351
    Kevin Vaughn
    04-04-2006, 03:30 PM Go to last post

  46. [SOLVED] Zip code data that populates the city and county.

    Started by HeathHarlan‎, 11-13-2012 01:11 PM
    city/state, county, formulas, multiple sheets, zip codes
    • 6
    • 29,326
    HeathHarlan
    11-13-2012, 03:38 PM Go to last post

  47. creating an aging report

    Started by PSikes‎, 01-01-2006 06:50 PM
    • 11
    • 29,314
    JohnTopley
    12-06-2016, 12:07 PM Go to last post

  48. Remove 1st character if it is 0

    Started by spowell‎, 09-13-2008 08:14 AM
    • 8
    • 29,266
    spowell
    09-14-2008, 05:54 PM Go to last post

  49. Indirect doesn't work when sheetname have spaces

    Started by ExcelQuestion‎, 01-26-2007 02:44 PM
    • 3
    • 29,215
    ExcelQuestion
    01-26-2007, 05:33 PM Go to last post

  50. [SOLVED] How To Vlookup On Duplicate Values But Only Return The First

    Started by dcrandall‎, 07-18-2013 12:50 PM
    • 6
    • 29,180
    dcrandall
    07-18-2013, 01:26 PM Go to last post
+ Post New Thread
Page 12 of 5614 FirstFirst ... 12 ...

Forum Information and Options

Users Browsing this Forum

There are currently 56 users browsing this forum. (1 members & 55 guests)

  1. cwwazy

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