+ Post New Thread
Page 52 of 5614 FirstFirst ... 52 ...
Threads 2551 to 2600 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. IF - returning a value between a range of numbers

    Started by magpye60‎, 11-03-2010 01:18 PM
    • 5
    • 10,901
    squiggler47
    11-04-2010, 08:52 AM Go to last post

  2. Decile Reporting function or formula

    Started by zacksba‎, 09-15-2006 11:53 AM
    • 1
    • 10,900
    clayv
    09-18-2006, 01:54 AM Go to last post

  3. [SOLVED] Extract data from merged cells in adjacent rows

    Started by hoss88‎, 03-07-2014 04:57 AM
    1 Attachment(s)
    • 4
    • 10,897
    protonLeah
    11-14-2016, 03:09 PM Go to last post

  4. [SOLVED] OFFSET function to show data only if meets criteria

    Started by Trax‎, 03-15-2013 09:00 AM
    match, offset 2 Attachment(s)
    • 14
    • 10,895
    Fotis1991
    03-19-2013, 10:47 AM Go to last post

  5. Cool Difference between two Excel Date/Time Stamps

    Started by lnapier‎, 06-28-2005 06:02 PM
    • 51
    • 10,892
    JE McGimpsey
    09-06-2005, 12:05 PM Go to last post

  6. rounding up days or months to the nearest year

    Started by PaulALC‎, 11-13-2014 06:13 AM
    • 1
    • 10,886
    AlanY
    11-13-2014, 06:35 AM Go to last post

  7. [SOLVED] MIN & MAX not working ???

    Started by ukphoenix‎, 10-13-2013 08:55 PM
    2 Attachment(s)
    • 8
    • 10,885
    ukphoenix
    10-22-2013, 03:06 PM Go to last post

  8. highlight cells that contain the same first 5 characters

    Started by goldstar1‎, 04-16-2013 08:45 AM
    3 Attachment(s)
    • 13
    • 10,882
    arlu1201
    04-17-2013, 02:24 PM Go to last post

  9. How do I auto-protect a worksheet?

    Started by West‎, 03-30-2005 10:25 PM
    • 1
    • 10,875
    Rowan
    03-30-2005, 11:06 PM Go to last post

  10. [SOLVED] Auto populate dates of a month based on dropdown selection

    Started by tstruntz‎, 08-20-2012 09:32 AM
    • 2
    • 10,855
    tstruntz
    08-20-2012, 10:10 AM Go to last post

  11. Named Range Limit??

    Started by TinaK819‎, 02-17-2009 07:18 PM
    • 15
    • 10,852
    Freaky_zoid
    02-20-2009, 03:34 AM Go to last post

  12. Using VLOOKUP to return minimum value associated with an item

    Started by the_clay_bird‎, 07-28-2015 05:26 PM
    • 3
    • 10,852
    the_clay_bird
    07-30-2015, 02:15 PM Go to last post

  13. Finding missing numbers

    Started by BrettLowers‎, 01-24-2008 09:45 PM
    • 4
    • 10,847
    BrettLowers
    01-25-2008, 03:08 PM Go to last post

  14. How Does PMT function work ??

    Started by sandy3180‎, 11-22-2006 09:25 AM
    • 1
    • 10,838
    Maistrye
    11-22-2006, 11:58 AM Go to last post

  15. Question Nesting VLOOKUP & HLOOKUP

    Started by tuph‎, 02-09-2006 10:32 PM
    • 5
    • 10,837
    tuph
    03-16-2006, 08:00 PM Go to last post

  16. Create a list of items based on another list

    Started by rickyg‎, 09-10-2010 05:57 AM
    3 Attachment(s)
    • 9
    • 10,835
    rickyg
    09-10-2010, 09:57 AM Go to last post

  17. [SOLVED] VAT & NET From GROSS

    Started by MisterE‎, 02-17-2018 09:35 AM
    1 Attachment(s)
    • 5
    • 10,830
    AliGW
    02-17-2018, 10:13 AM Go to last post

  18. [SOLVED] Autosum returns an incorrect zero value on the selected cells

    Started by trying hard‎, 08-24-2005 07:05 AM
    • 4
    • 10,825
    Jerry W. Lewis
    08-25-2005, 06:05 AM Go to last post

  19. Calculating Negative Gross Margin

    Started by igendreau‎, 10-11-2012 02:26 PM
    gross margin, gross profit
    • 1
    • 10,822
    kbkumar
    10-11-2012, 02:31 PM Go to last post

  20. [SOLVED] roundup seconds to minute

    Started by obi-akpere‎, 01-07-2005 09:06 AM
    • 1
    • 10,821
    Bob Phillips
    01-07-2005, 09:06 AM Go to last post

  21. [SOLVED] Using "double equal signs" in place of an IF statement

    Started by Scott P‎, 06-20-2006 10:55 PM
    • 2
    • 10,821
    Scott P
    06-20-2006, 11:15 PM Go to last post

  22. Can you use VLOOKUP to Return a Formula Instead of a Value?

    Started by Puni‎, 09-14-2015 04:28 PM
    alternatives, formula instead of value, vlookup 4 Attachment(s)
    • 11
    • 10,819
    Puni
    10-06-2015, 09:40 PM Go to last post

  23. Help with Football Prediction spreadsheet formula

    Started by bobafett70‎, 08-07-2009 03:08 AM
    3 Attachment(s)
    • 10
    • 10,811
    DonkeyOte
    08-16-2009, 03:38 AM Go to last post

  24. [SOLVED] Excel: Allow combination of formula answer and text in one cell

    Started by wood nerd‎, 05-03-2006 06:50 PM
    • 3
    • 10,809
    Jim Cone
    05-03-2006, 08:15 PM Go to last post

  25. [SOLVED] Place a "" around ALL values in a cell

    Started by Phil‎, 10-21-2005 02:05 PM
    • 7
    • 10,806
    Dave Peterson
    11-17-2005, 09:40 PM Go to last post

  26. Question Calculating Selling Price Formula in Excel

    Started by hitari‎, 03-23-2013 05:47 PM
    commission, excel, formula, selling price 1 Attachment(s)
    • 4
    • 10,805
    hitari
    03-24-2013, 10:07 AM Go to last post

  27. [SOLVED] Cannot Find Link to External Workbook

    Started by brandonboucher‎, 07-31-2014 03:00 PM
    external link, external links, office 365 3 Attachment(s)
    • 6
    • 10,805
    2morrow
    01-04-2018, 06:33 PM Go to last post

  28. When Cell Value lies between two values?

    Started by Stirly‎, 12-09-2006 05:41 AM
    • 3
    • 10,800
    VBA Noob
    12-09-2006, 06:18 AM Go to last post

  29. Array formula to return text

    Started by RicWir‎, 03-18-2009 05:25 PM
    • 4
    • 10,799
    RicWir
    03-18-2009, 07:44 PM Go to last post

  30. split between arabic and english in one cell into two cell

    Started by basstk‎, 03-08-2013 05:56 AM
    arabic, english, splitting, text 1 Attachment(s)
    • 9
    • 10,793
    Glenn Kennedy
    06-27-2022, 08:07 AM Go to last post

  31. SUMIFS Formula with LEFT Function

    Started by Sultix‎, 01-16-2009 10:04 PM
    • 6
    • 10,790
    Sultix
    01-18-2009, 06:43 AM Go to last post

  32. [SOLVED] How do I enter the PV function to determine the ending balance of

    Started by Rettarie‎, 02-16-2006 10:10 AM
    • 2
    • 10,787
    bpeltzer
    02-16-2006, 10:45 AM Go to last post

  33. Smile How to remove duplicates from a column

    Started by LLocal‎, 02-02-2007 01:48 PM
    1 Attachment(s)
    • 11
    • 10,784
    tonymaz
    05-13-2009, 05:44 PM Go to last post

  34. Post Use a multiplier to change List Prices to Net prices

    Started by Dangada‎, 07-06-2005 12:59 AM
    • 12
    • 10,783
    Anne Troy
    09-06-2005, 12:05 PM Go to last post

  35. make criteria in sumif refer to another cell

    Started by keithjdowling‎, 05-30-2006 07:50 PM
    • 4
    • 10,782
    keithjdowling
    05-30-2006, 09:20 PM Go to last post

  36. How do I Superscript or Subscript values derived from formulas?

    Started by e4excel‎, 01-24-2011 06:49 PM
    1 Attachment(s)
    • 15
    • 10,772
    e4excel
    02-02-2011, 06:14 AM Go to last post

  37. cell lock does not work ?!

    Started by huntermcg‎, 02-08-2006 05:39 PM
    • 8
    • 10,768
    Patrick Betman
    02-09-2006, 12:21 PM Go to last post

  38. Divide selected cells by 1000

    Started by Lowkey‎, 04-25-2006 05:55 PM
    • 5
    • 10,768
    Niek Otten
    04-25-2006, 06:45 PM Go to last post

  39. Display Week Ranges

    Started by txsteve‎, 12-08-2008 11:00 AM
    2 Attachment(s)
    • 11
    • 10,766
    shg
    12-08-2008, 07:41 PM Go to last post

  40. If date falls between two dates using arrays

    Started by nomnomnumbers‎, 10-26-2016 10:21 AM
    • 8
    • 10,765
    Pepe Le Mokko
    02-06-2020, 04:11 AM Go to last post

  41. Sum Function Visible cells only in Excel 2003

    Started by ksp‎, 04-28-2009 05:04 AM
    • 7
    • 10,761
    martindwilson
    04-29-2009, 05:36 AM Go to last post

  42. Formula for Tiered fee rates

    Started by sbigelow26‎, 04-09-2015 05:28 PM
    • 3
    • 10,758
    Tony Valko
    04-09-2015, 06:22 PM Go to last post

  43. [SOLVED] Using number format to multiply number by 10

    Started by gavinduffy01‎, 02-14-2013 08:10 AM
    solved
    • 2
    • 10,757
    gavinduffy01
    02-14-2013, 08:37 AM Go to last post

  44. How To Keep Cell Blank When Applying Formula Until Data Entered In Excel

    Started by Fredbugatti‎, 07-24-2018 10:20 PM
    1 Attachment(s)
    • 17
    • 10,757
    FDibbins
    07-24-2018, 11:54 PM Go to last post

  45. INDIRECT worksheet with a space in the name

    Started by Bruce‎, 01-05-2005 09:06 PM
    • 5
    • 10,748
    Don Guillett
    01-06-2005, 10:06 AM Go to last post

  46. [SOLVED] Need to link excel "cell" to a pre saved PDF file?? How do I do th

    Started by Redbobber‎, 04-11-2006 11:25 AM
    • 1
    • 10,748
    SteveG
    04-11-2006, 12:20 PM Go to last post

  47. If statement with negative numbers = stumped analyst

    Started by lukep10‎, 03-20-2008 03:51 PM
    2 Attachment(s)
    • 5
    • 10,745
    lukep10
    03-21-2008, 09:30 AM Go to last post

  48. Scroll bar moves down thousands of rows with the slightest movement downward

    Started by mslake99‎, 04-06-2012 06:04 PM
    • 1
    • 10,743
    Søren Larsen
    04-06-2012, 06:11 PM Go to last post

  49. [SOLVED] Dynamic Array for Index/Match formula

    Started by Fletch74‎, 04-03-2014 06:51 PM
    2 Attachment(s)
    • 6
    • 10,739
    Gesyca
    05-23-2016, 03:51 PM Go to last post

  50. Use conditional formatting only on visible not hidden cells

    Started by JackBauer‎, 02-24-2014 03:37 AM
    2 Attachment(s)
    • 6
    • 10,738
    daddylonglegs
    02-24-2014, 08:26 AM Go to last post
+ Post New Thread
Page 52 of 5614 FirstFirst ... 52 ...

Forum Information and Options

Users Browsing this Forum

There are currently 51 users browsing this forum. (3 members & 48 guests)

  1. Czeslaw,
  2. JN831,
  3. Phuocam

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