+ Post New Thread
Page 51 of 5614 FirstFirst ... 51 ...
Threads 2501 to 2550 of 280657

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

  1. Question Vlookup returning mutiple values into multiple rows

    Started by mhuddles1981‎, 05-27-2010 08:43 PM
    macro, udf, vlookup
    • 7
    • 11,084
    kjhylant
    06-27-2010, 11:31 AM Go to last post

  2. WEEKNUM Function returning 1/9/1900

    Started by jacksilvert‎, 03-07-2017 03:54 PM
    • 1
    • 11,080
    daddylonglegs
    03-07-2017, 03:58 PM Go to last post

  3. [SOLVED] how to link general journal to ledgers

    Started by aneska129‎, 09-16-2013 06:43 AM
    accounts, general journal, journal, ledger, link 1 Attachment(s)
    • 5
    • 11,079
    arlu1201
    09-18-2013, 02:26 AM Go to last post

  4. Capturing the last "Saturday"

    Started by John Bates‎, 07-28-2008 01:38 PM
    • 2
    • 11,075
    John Bates
    07-28-2008, 04:11 PM Go to last post

  5. Calculating end date based on 8-hour workday

    Started by nojamindonut‎, 07-13-2010 10:14 AM
    1 Attachment(s)
    • 5
    • 11,064
    MelMel
    01-27-2013, 07:40 PM Go to last post

  6. formular for radius from three points

    Started by uswaldronz‎, 07-08-2013 02:20 PM
    • 1
    • 11,061
    shg
    07-08-2013, 03:18 PM Go to last post

  7. Question [SOLVED] Three dimensional lookup???

    Started by rajncajn‎, 05-30-2012 05:55 PM
    2 Attachment(s)
    • 22
    • 11,061
    rajncajn
    05-31-2012, 12:53 PM Go to last post

  8. Composite Ranking

    Started by donmat‎, 04-09-2013 09:55 AM
    • 11
    • 11,059
    donmat
    04-09-2013, 01:47 PM Go to last post

  9. Angry Substitute and Array Function

    Started by moniquejvr‎, 02-24-2011 09:29 AM
    • 2
    • 11,055
    moniquejvr
    02-24-2011, 09:55 AM Go to last post

  10. [SOLVED] Trying to Round Down in same cell as division solution

    Started by The Football Ref‎, 11-08-2012 07:17 PM
    • 5
    • 11,055
    djapigo
    11-08-2012, 08:13 PM Go to last post

  11. Indirect function combined with Array

    Started by NYRealEstateAnalyst‎, 11-11-2010 12:23 PM
    array formula, indirect reference, row formula
    • 5
    • 11,052
    arlu1201
    05-10-2013, 02:46 AM Go to last post

  12. Post [SOLVED] INDEX/MATCH across several worksheets

    Started by hennakao‎, 04-25-2012 08:09 AM
    3 Attachment(s)
    • 9
    • 11,051
    Twingo
    11-25-2016, 08:07 AM Go to last post

  13. [SOLVED] WORKDAY.INTL function for excel 2007

    Started by turist‎, 12-05-2013 01:53 PM
    • 4
    • 11,046
    arlu1201
    12-12-2013, 02:20 AM Go to last post

  14. Combining 3 Nested If Statements Into One Cell?

    Started by UBSmokie‎, 11-17-2009 03:22 PM
    nested if
    • 2
    • 11,041
    JBeaucaire
    11-17-2009, 05:34 PM Go to last post

  15. Convert Milliseconds into Hours Formula

    Started by Klmo‎, 03-14-2016 04:17 PM
    • 4
    • 11,036
    Klmo
    03-14-2016, 04:34 PM Go to last post

  16. Set solver constraints so variables are either 1 OR 0.

    Started by Gwyndalf‎, 07-12-2006 07:45 PM
    • 2
    • 11,034
    Gwyndalf
    07-13-2006, 08:20 PM Go to last post

  17. Quartile Averaging

    Started by MCII‎, 06-14-2017 01:07 PM
    • 5
    • 11,033
    MCII
    06-15-2017, 11:04 AM Go to last post

  18. ZigZag Indicator Calculation

    Started by h.noor‎, 10-14-2015 04:36 PM
    zigzag 1 Attachment(s)
    • 4
    • 11,031
    poweru
    07-05-2020, 04:02 PM Go to last post

  19. Cross sectional regression in excel?

    Started by Ystar‎, 07-24-2013 12:24 PM
    • 3
    • 11,031
    MrShorty
    07-25-2013, 10:50 AM Go to last post

  20. [SOLVED] XLOOKUP for dates avoid 1/0/1900 for blank cells

    Started by Webbers‎, 11-18-2020 10:16 AM
    • 10
    • 11,029
    AliGW
    03-24-2022, 02:56 AM Go to last post

  21. [SOLVED] Convert XX to 20XX to change date format - can I do this with a formula?

    Started by Motox‎, 09-23-2015 09:34 PM
    • 3
    • 11,025
    FDibbins
    09-24-2015, 01:16 AM Go to last post

  22. Question [SOLVED] vba not updating values

    Started by cgrubb‎, 10-05-2015 07:42 AM
    • 16
    • 11,024
    TMS
    02-16-2017, 05:22 PM Go to last post

  23. How to generate sets of random numbers without having duplicates

    Started by William‎, 06-05-2006 04:20 PM
    • 1
    • 11,001
    Tushar Mehta
    06-06-2006, 12:35 AM Go to last post

  24. [SOLVED] Expired Date Formula

    Started by Donna in Elkin, NC‎, 01-04-2005 12:06 PM
    • 3
    • 11,000
    Donna in Elkin, NC
    01-04-2005, 01:06 PM Go to last post

  25. [SOLVED] Data validation using dynamic range ignoring blank formulas

    Started by gerainta‎, 04-18-2013 06:08 AM
    blank, blanks, data validation, dynamic range, vba 1 Attachment(s)
    • 8
    • 10,999
    Tony Valko
    04-22-2013, 09:24 AM Go to last post

  26. Formula to auto update cells below when inserting a new row

    Started by onpoint‎, 04-13-2013 08:17 AM
    2 Attachment(s)
    • 12
    • 10,998
    onpoint
    04-13-2013, 04:20 PM Go to last post

  27. VLookup Data not pulling unless I physically retype the name?

    Started by mlbdc2012‎, 11-23-2013 05:13 AM
    • 5
    • 10,989
    newdoverman
    11-23-2013, 05:55 PM Go to last post

  28. Countif and non adjacent cells range

    Started by isouaga‎, 05-17-2007 08:27 AM
    • 8
    • 10,986
    isouaga
    05-18-2007, 08:48 AM Go to last post

  29. Automate Posting Jounal entries to Ledger Accounts

    Started by Rich in Naples‎, 06-28-2013 05:50 AM
    1 Attachment(s)
    • 4
    • 10,982
    protonLeah
    07-17-2015, 05:09 PM Go to last post

  30. [SOLVED] Ctrl+Y not working

    Started by vishal‎, 06-24-2005 06:05 AM
    • 7
    • 10,980
    Leo Heuser
    06-27-2005, 02:05 PM Go to last post

  31. All pictures disappear from my whole excel file when I use 'hidden

    Started by greencecil‎, 12-12-2005 05:55 AM
    • 2
    • 10,970
    greencecil
    12-13-2005, 05:30 AM Go to last post

  32. Return blank if Cell is blank or contains formula)

    Started by oo0tommyk0oo‎, 12-28-2010 06:12 PM
    1 Attachment(s)
    • 8
    • 10,969
    shg
    03-22-2011, 05:31 PM Go to last post

  33. Recalculating PPM

    Started by suzy‎, 07-01-2008 10:51 AM
    3 Attachment(s)
    • 3
    • 10,959
    reggie1000
    07-07-2008, 09:25 AM Go to last post

  34. Sales Realization Calculation

    Started by Chandrashekhar‎, 01-24-2009 05:39 AM
    2 Attachment(s)
    • 11
    • 10,958
    Chandrashekhar
    05-25-2009, 03:20 AM Go to last post

  35. [SOLVED] How do I filter names using only the first letter?

    Started by Mr_Sparkly‎, 07-16-2005 08:05 PM
    • 7
    • 10,957
    Mangus Pyke
    07-17-2005, 12:05 AM Go to last post

  36. [SOLVED] Alternative to sumproduct

    Started by Questionz‎, 05-21-2017 02:02 AM
    7 Attachment(s)
    • 14
    • 10,952
    Questionz
    06-05-2017, 11:34 PM Go to last post

  37. [SOLVED] ASSIGNING A NEW NUMBER TO A WORKSHEET EVERY TIME IT IS OPEN

    Started by steppie70‎, 03-08-2006 04:50 PM
    • 6
    • 10,944
    kevindmorgan
    03-13-2006, 05:52 PM Go to last post

  38. Question [SOLVED] IF Function With Structured References Help

    Started by maddtownnn‎, 04-29-2017 01:19 PM
    1 Attachment(s)
    • 7
    • 10,940
    maddtownnn
    04-29-2017, 03:29 PM Go to last post

  39. Unhappy [SOLVED] Calculate time remaining based on end date & time and current date

    Started by Kaz09‎, 10-25-2012 06:22 AM
    7 Attachment(s)
    • 33
    • 10,936
    rand_32
    08-19-2014, 07:11 AM Go to last post

  40. Red face IRR calculations Annual vs Quarterly

    Started by SimpleSmile‎, 10-22-2008 08:25 PM
    • 1
    • 10,936
    Paul
    10-22-2008, 08:59 PM Go to last post

  41. Average multiple rows based on 2 columns

    Started by beaner‎, 11-28-2008 09:47 PM
    3 Attachment(s)
    • 5
    • 10,934
    Simon M
    04-19-2011, 09:18 PM Go to last post

  42. [SOLVED] Hide #N/A as result with VLOOKUP formula

    Started by akalien‎, 07-06-2012 04:17 AM
    3 Attachment(s)
    • 11
    • 10,927
    arlu1201
    02-14-2014, 01:49 AM Go to last post

  43. Sum of one column based upon values in another

    Started by Creto‎, 04-07-2008 03:37 PM
    • 2
    • 10,927
    Creto
    04-07-2008, 03:55 PM Go to last post

  44. Top 5 values using LARGE and INDEX avoiding duplicates

    Started by carl916‎, 10-24-2007 06:09 PM
    1 Attachment(s)
    • 4
    • 10,927
    TheSageBR
    07-25-2012, 10:41 AM Go to last post

  45. Determining a Winner from list and ranking 1st, 2nd, and 3rd

    Started by Jhernand‎, 04-11-2013 02:26 PM
    2 Attachment(s)
    • 13
    • 10,919
    Trevasaurus
    04-16-2013, 05:46 PM Go to last post

  46. Unable to Paste into Formula Bar

    Started by Motox‎, 10-04-2013 12:38 AM
    • 5
    • 10,914
    AlKey
    10-05-2013, 09:39 PM Go to last post

  47. [SOLVED] FQDN to short name if applicable

    Started by TommyGun‎, 02-10-2015 08:30 AM
    1 Attachment(s)
    • 9
    • 10,911
    Glenn Kennedy
    02-10-2015, 09:54 AM Go to last post

  48. Fix conditional formatting to never change

    Started by whatever61‎, 07-24-2013 06:51 AM
    2 Attachment(s)
    • 7
    • 10,908
    TMS
    07-25-2013, 06:16 AM Go to last post

  49. Question Edit multiple formulas at once (not find/replace)

    Started by Alyena‎, 01-08-2013 08:04 AM
    1 Attachment(s)
    • 11
    • 10,901
    Alyena
    01-11-2013, 06:56 AM Go to last post

  50. 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
+ Post New Thread
Page 51 of 5614 FirstFirst ... 51 ...

Forum Information and Options

Users Browsing this Forum

There are currently 72 users browsing this forum. (3 members & 69 guests)

  1. btparkhe1920,
  2. finallymint,
  3. td3201

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