+ Post New Thread
Page 101 of 5613 FirstFirst ... 101 ...
Threads 5001 to 5050 of 280637

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

  1. Disable Scientific Notation conversion

    Started by Clark G.‎, 04-18-2005 10:06 AM
    • 2
    • 6,546
    Gary Brown
    04-18-2005, 01:06 PM Go to last post

  2. Date Formula and leaving cell blank when no date is entered

    Started by Texguy02‎, 01-31-2015 12:47 PM
    • 7
    • 6,546
    FDibbins
    01-31-2015, 02:57 PM Go to last post

  3. [SOLVED] Generate exact SUM

    Started by demona‎, 03-21-2013 05:39 AM
    3 Attachment(s)
    • 18
    • 6,546
    demona
    03-21-2013, 07:34 AM Go to last post

  4. Calculating equal distribution

    Started by newbie4‎, 09-10-2012 12:27 PM
    • 2
    • 6,545
    newbie4
    09-10-2012, 02:00 PM Go to last post

  5. Question Sort numbers with commas and separated by commas within one cell, can it be done?

    Started by tocuilleain‎, 01-28-2013 10:51 PM
    commas, single cell, sort 1 Attachment(s)
    • 5
    • 6,544
    eeijas
    01-17-2014, 05:56 PM Go to last post

  6. Cool [SOLVED] How to copy a formula to a new cell and jump the cell reference more than one cell

    Started by sarkman22‎, 05-21-2013 01:17 PM
    1 Attachment(s)
    • 2
    • 6,544
    sarkman22
    05-22-2013, 08:00 AM Go to last post

  7. Smile Number of Working Days in a month

    Started by Talbot‎, 07-18-2008 05:16 AM
    1 Attachment(s)
    • 2
    • 6,543
    Simon Lloyd
    07-18-2008, 05:36 AM Go to last post

  8. ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)

    Started by Creator‎, 02-17-2006 07:55 AM
    • 5
    • 6,541
    Creator
    02-17-2006, 10:20 AM Go to last post

  9. [SOLVED] formula/function to change text to strikethrough if condition met in adj cell

    Started by spreadsheetdummy‎, 09-04-2012 09:21 PM
    strkethrough text 1 Attachment(s)
    • 3
    • 6,541
    vlady
    09-04-2012, 10:35 PM Go to last post

  10. [SOLVED] concatenate number format issue

    Started by Tim Elhatton‎, 03-19-2005 03:06 PM
    • 4
    • 6,541
    John Mansfield
    03-19-2005, 04:06 PM Go to last post

  11. [SOLVED] Copying index/ match formula

    Started by LJoe‎, 06-27-2006 10:10 AM
    • 3
    • 6,538
    LJoe
    06-27-2006, 10:25 AM Go to last post

  12. Sumproduct formula returns #ref when linked data file is closed.

    Started by shandrak‎, 06-23-2014 07:18 PM
    #ref, closed workbook, sumproduct
    • 10
    • 6,537
    Tony Valko
    06-23-2014, 08:54 PM Go to last post

  13. Cumulative Tiered Bonus Structure

    Started by dpleventhal‎, 01-11-2011 01:12 AM
    bonus, tier 1 Attachment(s)
    • 6
    • 6,535
    dpleventhal
    01-11-2011, 11:58 AM Go to last post

  14. Nested IF with INDEX

    Started by nsorden‎, 06-16-2009 10:28 AM
    • 3
    • 6,534
    nsorden
    06-17-2009, 10:06 AM Go to last post

  15. index match with indirect across multiple sheets

    Started by mamachrissy1028‎, 08-11-2015 12:04 PM
    1 Attachment(s)
    • 12
    • 6,530
    Tony Valko
    08-13-2015, 08:43 PM Go to last post

  16. Solver Range Constraint

    Started by Oriolesfan89‎, 08-07-2014 02:03 PM
    2 Attachment(s)
    • 8
    • 6,528
    MrShorty
    08-11-2014, 11:49 AM Go to last post

  17. REMOVE SORT WARNING

    Started by Sally in KC‎, 07-31-2006 10:53 AM
    • 2
    • 6,526
    Bernie Deitrick
    07-31-2006, 12:33 PM Go to last post

  18. Linear interpolation between two points found using a lookup funct

    Started by aj4444‎, 11-29-2005 04:35 PM
    • 2
    • 6,526
    Ron Rosenfeld
    11-30-2005, 01:00 AM Go to last post

  19. Custom Format Superscript

    Started by matteobsuetti‎, 03-18-2015 07:23 PM
    • 8
    • 6,525
    MrShorty
    03-19-2015, 01:40 PM Go to last post

  20. [SOLVED] Importing a LIBOR rate

    Started by JimDandy‎, 07-06-2016 02:13 PM
    • 1
    • 6,523
    JimDandy
    07-06-2016, 03:00 PM Go to last post

  21. Performing a Nested if statement with a drop down data validation list

    Started by THKUCOMEAGAIN‎, 01-04-2012 11:37 AM
    excel, microsoft office 2010
    • 1
    • 6,522
    martindwilson
    01-07-2012, 07:58 AM Go to last post

  22. Carying Forward data with specific information

    Started by sonar‎, 08-24-2005 04:06 PM
    2 Attachment(s)
    • 10
    • 6,521
    Morrigan
    09-06-2005, 10:51 AM Go to last post

  23. [SOLVED] NETWORKDAYS counting half day's as 0.5 on attendance tracker

    Started by MarkPr‎, 10-11-2017 12:49 PM
    • 2
    • 6,519
    MarkPr
    10-11-2017, 03:38 PM Go to last post

  24. Divide only with number of cells with value>0

    Started by primaxx‎, 08-27-2009 03:13 AM
    • 3
    • 6,518
    DonkeyOte
    08-27-2009, 03:39 AM Go to last post

  25. Sum a Named Range across multiple worksheets

    Started by Dickie Dunkin‎, 03-23-2016 12:03 PM
    6 Attachment(s)
    • 35
    • 6,514
    Kevin#
    03-29-2016, 01:29 PM Go to last post

  26. Excel 2007 : Using VLOOKUP with multiple spreadsheets

    Started by Edloverr‎, 07-23-2011 12:58 AM
    • 7
    • 6,514
    JBeaucaire
    01-27-2014, 03:29 AM Go to last post

  27. Indirect formula returns 0 instead of value

    Started by ahkisha‎, 05-25-2016 11:24 AM
    indirect 1 Attachment(s)
    • 5
    • 6,512
    Pete_UK
    05-25-2016, 11:55 AM Go to last post

  28. Column stay in place when I scroll sideways?

    Started by nbdskater‎, 09-11-2007 02:54 PM
    • 1
    • 6,511
    oldchippy
    09-11-2007, 03:31 PM Go to last post

  29. [SOLVED] Yield vs XIRR formula

    Started by jetablack4‎, 10-14-2012 03:52 PM
    2 Attachment(s)
    • 4
    • 6,509
    sskini76
    03-31-2016, 08:13 AM Go to last post

  30. Consolidating multiple rankings

    Started by harrike‎, 10-18-2013 11:31 AM
    formula, ranking
    • 1
    • 6,506
    madsci64
    10-19-2013, 07:42 PM Go to last post

  31. count non blank cells which meet criteria in another column

    Started by cmarsh5035‎, 02-16-2005 12:45 PM
    • 2
    • 6,505
    JulieD
    02-16-2005, 12:45 PM Go to last post

  32. Show values in formula instead of cell reference

    Started by pnorgate‎, 08-19-2006 05:52 AM
    • 6
    • 6,505
    pnorgate
    08-20-2006, 04:31 AM Go to last post

  33. if one cell has "X" textin contents, then pull cell "Y"...

    Started by azazel‎, 10-20-2005 06:19 PM
    • 6
    • 6,503
    Rhyse1977
    07-30-2012, 10:03 AM Go to last post

  34. Angry [SOLVED] LINEST function is not producing same coefficients as polyfit formula on Excel chart

    Started by Nwash‎, 11-26-2012 04:22 PM
    linest, polynomial, trendline, trendline error 1 Attachment(s)
    • 12
    • 6,502
    ChemistB
    11-27-2012, 03:15 PM Go to last post

  35. Unhappy Problem linking PDF to Excel 2013 cell...

    Started by clm1251‎, 07-09-2013 01:03 AM
    • 12
    • 6,502
    Nabil Tajouri
    04-10-2016, 05:44 AM Go to last post

  36. Formula to return last but one cell in row!

    Started by Spellbound‎, 03-21-2009 07:15 AM
    • 8
    • 6,502
    Spellbound
    03-23-2009, 06:11 PM Go to last post

  37. Hyperlinks - email - subject line - etc

    Started by Youtalk‎, 09-14-2012 04:35 PM
    email subject, hyperlink cell
    • 3
    • 6,498
    Paul
    09-17-2012, 03:41 PM Go to last post

  38. Formula to calculate majority value

    Started by melanemac‎, 11-20-2006 12:35 PM
    • 2
    • 6,498
    melanemac
    11-20-2006, 01:07 PM Go to last post

  39. Can you add a vertical scroll bar to an inserted comment?

    Started by riznob‎, 02-09-2005 10:06 AM
    • 3
    • 6,497
    Gord Dibben
    02-09-2005, 07:06 PM Go to last post

  40. How can I use CEILING with a VLOOKUP formula?

    Started by superfast48‎, 07-23-2008 03:57 PM
    • 5
    • 6,496
    superfast48
    07-23-2008, 05:06 PM Go to last post

  41. wrapping text

    Started by Jerry‎, 07-01-2006 12:55 PM
    • 10
    • 6,495
    Jerry
    07-03-2006, 10:15 AM Go to last post

  42. [SOLVED] count unique values per month

    Started by tosteven‎, 08-08-2016 10:01 AM
    5 Attachment(s)
    • 10
    • 6,493
    AliGW
    08-26-2022, 11:28 AM Go to last post

  43. #REF errors

    Started by StephanieD‎, 03-15-2007 07:22 AM
    2 Attachment(s)
    • 9
    • 6,493
    Wannabe Guru
    04-27-2012, 03:27 PM Go to last post

  44. EXACT check ignore blanks

    Started by shdwfx‎, 02-11-2016 07:02 PM
    • 11
    • 6,491
    Pepe Le Mokko
    10-08-2019, 10:29 AM Go to last post

  45. Converting UTC to EST or EDT According To HH:MM:SS

    Started by prefnet‎, 01-26-2020 01:39 PM
    1 Attachment(s)
    • 28
    • 6,490
    hrlngrv
    01-27-2020, 05:12 PM Go to last post

  46. Countif odd

    Started by nesthead98‎, 07-22-2009 10:13 AM
    countif, odd
    • 3
    • 6,490
    nesthead98
    07-22-2009, 11:01 AM Go to last post

  47. Formula that will divide # of days left in month by my revenue goal

    Started by eth1129‎, 04-12-2009 05:45 PM
    1 Attachment(s)
    • 2
    • 6,487
    JBeaucaire
    04-12-2009, 05:53 PM Go to last post

  48. [SOLVED] Array formula to ignore blank cells

    Started by trickeyja‎, 09-22-2012 06:01 PM
    • 2
    • 6,484
    trickeyja
    09-22-2012, 07:35 PM Go to last post

  49. COUNTIF formula: count all positive numbers until..

    Started by camilla.searle‎, 08-16-2012 03:47 AM
    countif, countif countifs if and, countif problem, countifs with or clause
    • 3
    • 6,483
    camilla.searle
    08-16-2012, 09:44 AM Go to last post

  50. Multiple Regression - Error

    Started by Ozwilly‎, 05-22-2016 03:01 AM
    error, multiple regression, regression 1 Attachment(s)
    • 1
    • 6,482
    MrShorty
    05-22-2016, 09:48 AM Go to last post
+ Post New Thread
Page 101 of 5613 FirstFirst ... 101 ...

Forum Information and Options

Users Browsing this Forum

There are currently 60 users browsing this forum. (3 members & 57 guests)

  1. Jordon R

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