+ Post New Thread
Page 102 of 5614 FirstFirst ... 102 ...
Threads 5051 to 5100 of 280686

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. Multiple Regression - Error

    Started by Ozwilly‎, 05-22-2016 03:01 AM
    error, multiple regression, regression 1 Attachment(s)
    • 1
    • 6,488
    MrShorty
    05-22-2016, 09:48 AM Go to last post

  2. 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,488
    JBeaucaire
    04-12-2009, 05:53 PM Go to last post

  3. Convert Subnet address and mask to CIDR and vice-versa

    Started by redrockrobbo‎, 02-16-2018 02:35 AM
    2 Attachment(s)
    • 10
    • 6,485
    sandy666
    02-16-2018, 03:31 AM Go to last post

  4. [SOLVED] Closest match on Multiple Criteria

    Started by rbetts‎, 04-10-2014 11:49 AM
    2 Attachment(s)
    • 6
    • 6,485
    Jacc
    04-20-2014, 08:33 AM Go to last post

  5. Finding duplicates after using a concatenate formula

    Started by cmax979‎, 10-08-2013 03:14 PM
    concatenate, duplicates 1 Attachment(s)
    • 10
    • 6,485
    UnDeRC
    11-01-2018, 03:14 PM Go to last post

  6. Returning the first value in a column of values

    Started by archie999‎, 04-05-2007 10:37 AM
    • 5
    • 6,484
    daddylonglegs
    04-05-2007, 11:42 AM Go to last post

  7. [SOLVED] Using IFERROR formula when calculating # days between 2 dates

    Started by Glayva‎, 02-09-2017 08:37 AM
    2 Attachment(s)
    • 6
    • 6,483
    sandy666
    02-09-2017, 09:07 AM Go to last post

  8. [SOLVED] Return 2nd largest value (ignoring duplicates) with criteria

    Started by Sqwirtle‎, 07-12-2012 03:21 PM
    1 Attachment(s)
    • 12
    • 6,480
    AliGW
    10-30-2023, 03:59 AM Go to last post

  9. [SOLVED] Get A Sub-table from a excel table

    Started by subodhsapkota‎, 01-10-2019 01:25 AM
    2 Attachment(s)
    • 2
    • 6,480
    avk
    01-10-2019, 02:47 AM Go to last post

  10. New Line in a formula (Alt-Enter)

    Started by erajim‎, 07-30-2008 02:39 PM
    • 3
    • 6,480
    erajim
    07-30-2008, 02:54 PM Go to last post

  11. Cells - Top Indents

    Started by Cell Indents Query‎, 02-05-2005 12:06 AM
    • 1
    • 6,479
    Gord Dibben
    02-05-2005, 04:06 PM Go to last post

  12. help with VBA code to generate Autonumber

    Started by L!NuX‎, 06-01-2011 01:06 PM
    • 5
    • 6,478
    L!NuX
    06-02-2011, 03:54 PM Go to last post

  13. [SOLVED] If cell contains text from a list, return value..

    Started by MushroomFace‎, 03-05-2015 12:33 PM
    1 Attachment(s)
    • 9
    • 6,477
    Kaper
    03-06-2015, 09:56 AM Go to last post

  14. [SOLVED] Auto Insert Rows and copy formulas

    Started by shocks24‎, 02-27-2012 03:56 PM
    5 Attachment(s)
    • 16
    • 6,477
    arlu1201
    05-11-2012, 02:50 PM Go to last post

  15. [SOLVED] Convert "800" to "8:00" or "08:00"

    Started by Domenic‎, 09-06-2005 03:05 AM
    • 12
    • 6,476
    CPK
    09-06-2005, 12:05 PM Go to last post

  16. Macro or Formula to remove Text from Cells

    Started by smck‎, 04-24-2005 11:06 PM
    • 7
    • 6,473
    smck
    05-10-2005, 11:06 PM Go to last post

  17. [SOLVED] Compare Text in Multiple Cells and Ingore Blanks

    Started by morbdetro‎, 09-27-2013 05:52 PM
    1 Attachment(s)
    • 5
    • 6,472
    morbdetro
    10-03-2013, 03:28 PM Go to last post

  18. [SOLVED] Timesheet Rounding - 6 Minute Increment

    Started by JRose0303‎, 01-12-2013 10:33 AM
    • 2
    • 6,471
    JRose0303
    01-12-2013, 11:04 AM Go to last post

  19. Arrow Truncating text before a hyphen

    Started by tcjay‎, 09-06-2005 07:17 AM
    • 1
    • 6,471
    tcjay
    09-06-2005, 07:43 AM Go to last post

  20. [SOLVED] highlight/unhighlight (or color/uncolor) cells containing a specific character

    Started by markx‎, 10-13-2005 09:05 AM
    • 2
    • 6,468
    markx
    10-13-2005, 11:05 AM Go to last post

  21. [SOLVED] Reference a cell within a HyperLink

    Started by altwood‎, 03-08-2018 01:31 AM
    • 9
    • 6,467
    kev_
    03-08-2018, 12:06 PM Go to last post

  22. Using Nested RANK functions

    Started by tuph‎, 08-07-2006 10:34 PM
    • 11
    • 6,464
    Leo Heuser
    08-11-2006, 12:20 AM Go to last post

  23. [SOLVED] Zero or negative rates and XNPV?

    Started by LAHM‎, 03-20-2006 11:45 AM
    • 4
    • 6,464
    LAHM
    03-20-2006, 12:50 PM Go to last post

  24. Create Formula for calculating Little League Age...

    Started by Brent‎, 09-20-2005 06:05 PM
    • 1
    • 6,464
    Ron Rosenfeld
    09-20-2005, 09:05 PM Go to last post

  25. Using IFERROR SUM VLOOKUP Functions together

    Started by DJAMESRUSHLOW‎, 07-22-2018 08:29 PM
    help a student in need, iferror, sum, vlook up 1 Attachment(s)
    • 2
    • 6,464
    FlameRetired
    07-22-2018, 09:41 PM Go to last post

  26. Cool [SOLVED] Separating top-level domain from email list for sorting / filtering etc... Sharing

    Started by austere‎, 01-08-2013 08:22 AM
    filter, email, optimize, reverse
    • 5
    • 6,463
    hamjam
    01-09-2013, 06:52 AM Go to last post

  27. [SOLVED] How to prevent duplicate entries in two columns with formulas?

    Started by cody4334‎, 05-16-2013 12:34 AM
    3 Attachment(s)
    • 11
    • 6,462
    rajusoundhar
    07-02-2014, 07:48 AM Go to last post

  28. Question Combining HLOOKUP and SUMIF into one formula

    Started by iantix‎, 08-21-2014 12:21 PM
    3 Attachment(s)
    • 4
    • 6,460
    iantix
    08-26-2015, 10:44 AM Go to last post

  29. Count the occurrences of a text string?

    Started by New2MSExcel‎, 11-04-2009 06:25 AM
    1 Attachment(s)
    • 8
    • 6,459
    robbyvegas
    10-24-2010, 08:47 PM Go to last post

  30. sumif odd/even

    Started by superspurs‎, 10-28-2009 07:25 AM
    • 1
    • 6,458
    DonkeyOte
    10-28-2009, 07:40 AM Go to last post

  31. Using Vlookup in filtered data

    Started by gimmemo‎, 09-21-2006 01:33 PM
    • 2
    • 6,457
    Krishnakumar
    09-26-2006, 04:04 AM Go to last post

  32. Maturity Date Calculation

    Started by NeedForExcel‎, 01-19-2015 06:19 AM
    4 Attachment(s)
    • 15
    • 6,456
    daddylonglegs
    01-22-2015, 08:17 AM Go to last post

  33. Hide Rows if a task is complete

    Started by ShakaDula14‎, 04-09-2013 12:07 PM
    1 Attachment(s)
    • 9
    • 6,455
    ChemistB
    04-26-2013, 01:07 PM Go to last post

  34. [SOLVED] DGET with a hardcoded array for "criteria"

    Started by jglassmanba‎, 03-30-2012 01:28 PM
    array constant, database, dget 3 Attachment(s)
    • 5
    • 6,454
    walterzj
    05-07-2013, 12:42 PM Go to last post

  35. Unhappy Hyperlinking problems

    Started by msteel‎, 07-12-2006 08:30 PM
    • 3
    • 6,453
    Max
    07-12-2006, 11:25 PM Go to last post

  36. [SOLVED] Slicer problem sorting by month

    Started by sportfan‎, 09-30-2015 04:07 AM
    • 3
    • 6,452
    NeedForExcel
    09-30-2015, 10:58 PM Go to last post

  37. Question formula problem - UK national curriculum levels

    Started by London‎, 07-19-2005 02:46 PM
    • 85
    • 6,449
    Sandy Mann
    09-06-2005, 03:05 PM Go to last post

  38. How to get case sensitive validation from list in a table?

    Started by dk9000‎, 08-11-2015 11:51 AM
    case sensitive formulas, data validation, exact match, exact value, vlookup 1 Attachment(s)
    • 9
    • 6,449
    dk9000
    08-20-2015, 07:40 PM Go to last post

  39. Escalation Formula

    Started by ExcelNewbeee‎, 07-10-2013 12:56 PM
    1 Attachment(s)
    • 1
    • 6,447
    ExcelNewbeee
    07-11-2013, 07:16 PM Go to last post

  40. Mail shot from list of email addresses

    Started by Mark Anderson‎, 08-27-2008 11:39 AM
    • 1
    • 6,447
    Colin Legg
    08-27-2008, 01:05 PM Go to last post

  41. Need help calculating hours and minutes in a rolling 24 hour period with "If/Then" also

    Started by Agent007‎, 06-08-2013 04:50 PM
    1 Attachment(s)
    • 17
    • 6,445
    FDibbins
    06-09-2013, 01:06 AM Go to last post

  42. Question Calculating percentage occurrence of numbers

    Started by jordi55‎, 11-20-2012 10:02 PM
    calculating, large data sets, numbers, percentages
    • 3
    • 6,445
    djapigo
    11-20-2012, 10:43 PM Go to last post

  43. Static time and date stamp

    Started by eric11‎, 03-02-2007 05:16 PM
    • 10
    • 6,443
    saadarslan
    10-01-2015, 01:27 PM Go to last post

  44. [SOLVED] Validation of Postal Code

    Started by Veronika‎, 12-16-2005 04:50 PM
    • 1
    • 6,442
    Debra Dalgleish
    12-16-2005, 05:45 PM Go to last post

  45. Vlookup not Resolving

    Started by PatK‎, 08-15-2006 01:30 PM
    • 4
    • 6,441
    PatK
    08-15-2006, 02:15 PM Go to last post

  46. How to automatically increment periods by one month with different start dates

    Started by ohlalayeah‎, 04-01-2013 11:32 AM
    2 Attachment(s)
    • 5
    • 6,441
    Fotis1991
    04-03-2013, 03:02 AM Go to last post

  47. [SOLVED] Alphanumeric sorting (letter prefix issue)

    Started by hokkaido19‎, 04-03-2015 07:27 PM
    • 8
    • 6,440
    hokkaido19
    04-10-2015, 09:30 PM Go to last post

  48. VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY

    Started by Scott Lolmaugh‎, 03-09-2006 06:35 PM
    • 3
    • 6,439
    Biff
    03-09-2006, 07:10 PM Go to last post

  49. [SOLVED] Count number of occurrences in month (google sheet)

    Started by Juliansmity‎, 07-13-2015 05:50 AM
    1 Attachment(s)
    • 7
    • 6,438
    Jonmo1
    07-13-2015, 12:17 PM Go to last post

  50. [SOLVED] COUNT back 12 months function??

    Started by Pixie1988‎, 10-30-2013 05:15 AM
    2 Attachment(s)
    • 8
    • 6,438
    FDibbins
    10-31-2013, 11:55 AM Go to last post
+ Post New Thread
Page 102 of 5614 FirstFirst ... 102 ...

Forum Information and Options

Users Browsing this Forum

There are currently 38 users browsing this forum. (1 members & 37 guests)

  1. tungten9x

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