+ Post New Thread
Page 1511 of 5614 FirstFirst ... 1511 ...
Threads 75501 to 75550 of 280699

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. [SOLVED] Excel Formula based on value of numeric ranges

    Started by cnbales‎, 01-20-2017 01:19 PM
    1 Attachment(s)
    • 5
    • 477
    Tony Valko
    01-20-2017, 04:03 PM Go to last post

  2. [SOLVED] Formula to get max value from a filtered list

    Started by Xandler‎, 01-20-2017 01:35 PM
    • 3
    • 623
    Tony Valko
    01-20-2017, 04:03 PM Go to last post

  3. [SOLVED] Help with Formula (Match)

    Started by Andrew.Trevayne‎, 01-20-2017 10:20 AM
    2 Attachment(s)
    • 3
    • 341
    AliGW
    01-20-2017, 03:52 PM Go to last post

  4. generating regression slopes from raw data

    Started by Aaron J051in‎, 01-20-2017 02:18 PM
    • 1
    • 396
    MrShorty
    01-20-2017, 02:29 PM Go to last post

  5. Formula to combine All elements in 1 Row

    Started by david_cc‎, 01-20-2017 11:50 AM
    combinations, combine, row 1 Attachment(s)
    • 1
    • 656
    CAntosh
    01-20-2017, 01:19 PM Go to last post

  6. [SOLVED] Checking A Date (Greater or Less)

    Started by Andrew.Trevayne‎, 01-20-2017 12:45 PM
    • 3
    • 317
    Tony Valko
    01-20-2017, 12:52 PM Go to last post

  7. [SOLVED] To Calculate Date Different in Table with certain condition

    Started by ajimieta‎, 01-18-2017 09:23 PM
    3 Attachment(s)
    • 3
    • 401
    Moo the Dog
    01-20-2017, 12:17 PM Go to last post

  8. Formula to get the next non blank cell

    Started by dluhut‎, 01-20-2017 11:47 AM
    • 1
    • 422
    JohnTopley
    01-20-2017, 12:13 PM Go to last post

  9. OffSet Formula

    Started by rizmomin‎, 01-20-2017 11:36 AM
    1 Attachment(s)
    • 5
    • 317
    CAntosh
    01-20-2017, 12:03 PM Go to last post

  10. [SOLVED] SUMIFS with multiple criteria WITH specified dynamic range criteria

    Started by dluhut‎, 01-20-2017 11:03 AM
    1 Attachment(s)
    • 0
    • 1,310
    dluhut
    01-20-2017, 11:03 AM Go to last post

  11. Feeding Data from Master Worksheet To Another Worksheet

    Started by ool3ecc4oo‎, 01-18-2017 04:48 PM
    auto add to new worksheet, formula, master, worksheet 1 Attachment(s)
    • 5
    • 574
    ool3ecc4oo
    01-20-2017, 10:09 AM Go to last post

  12. Which data set has the best overlap with a random sample

    Started by snomis‎, 01-20-2017 07:55 AM
    • 2
    • 527
    Tony Valko
    01-20-2017, 10:05 AM Go to last post

  13. Question [SOLVED] Help With A Formula To Calculate Only Filtered Data?

    Started by artiststevens‎, 12-26-2016 03:24 AM
    8 Attachment(s)
    • 19
    • 3,989
    JohnTopley
    01-20-2017, 09:10 AM Go to last post

  14. Overlapping Time Based on Conditions

    Started by ericjspencley‎, 01-19-2017 02:17 PM
    5 Attachment(s)
    • 4
    • 372
    ericjspencley
    01-20-2017, 08:10 AM Go to last post

  15. Hyperlink only links to sheet, not to specific cell referenced

    Started by AJB611‎, 01-20-2017 06:37 AM
    cell addressing, hyperlinks, sheet reference
    • 2
    • 589
    Glenn Kennedy
    01-20-2017, 06:47 AM Go to last post

  16. IF formula and Tally for months of the year

    Started by burnsie‎, 01-20-2017 05:42 AM
    • 4
    • 426
    samba_ravi
    01-20-2017, 06:44 AM Go to last post

  17. [SOLVED] Help with IF function please

    Started by cafedolphin‎, 01-20-2017 05:00 AM
    1 Attachment(s)
    • 7
    • 435
    sandy666
    01-20-2017, 06:11 AM Go to last post

  18. [SOLVED] Find Stock Runout Date

    Started by Rajeshkumar R‎, 01-05-2017 03:02 AM
    2 Attachment(s)
    • 5
    • 589
    Rajeshkumar R
    01-20-2017, 05:34 AM Go to last post

  19. Find the earliest date in a range of data

    Started by juan.doe‎, 01-20-2017 04:25 AM
    2 Attachment(s)
    • 1
    • 372
    JohnTopley
    01-20-2017, 04:52 AM Go to last post

  20. [SOLVED] AverageIfs to average two ranges if match is met

    Started by bjnockle‎, 01-19-2017 09:37 PM
    4 Attachment(s)
    • 8
    • 762
    bjnockle
    01-20-2017, 04:25 AM Go to last post

  21. Add/remove names in project (IF-Function)

    Started by Regal383‎, 01-16-2017 10:34 AM
    4 Attachment(s)
    • 5
    • 577
    Regal383
    01-20-2017, 03:57 AM Go to last post

  22. [SOLVED] Combine 2 Columns from 2 different sheets with keeping duplicates

    Started by Sekars‎, 01-19-2017 08:43 AM
    1 Attachment(s)
    • 6
    • 521
    Sekars
    01-20-2017, 03:16 AM Go to last post

  23. TRIM does not remove all excess spaces

    Started by analystbank‎, 01-20-2017 12:48 AM
    trim
    • 5
    • 600
    analystbank
    01-20-2017, 01:26 AM Go to last post

  24. [SOLVED] Show value in one column from another worksheet based on match in another column

    Started by txcleggy‎, 01-18-2017 07:23 PM
    2 Attachment(s)
    • 5
    • 616
    Glenn Kennedy
    01-19-2017, 09:50 PM Go to last post

  25. [SOLVED] Formula to Get cell value if cell reference is known

    Started by rizmomin‎, 01-19-2017 05:58 PM
    1 Attachment(s)
    • 2
    • 402
    rizmomin
    01-19-2017, 08:32 PM Go to last post

  26. Trying to use Index Match for staff rota

    Started by kevinwcole200‎, 01-19-2017 06:53 PM
    1 Attachment(s)
    • 1
    • 454
    sandy666
    01-19-2017, 07:47 PM Go to last post

  27. Extract number from text string

    Started by dchubbock‎, 01-19-2017 06:39 PM
    • 7
    • 558
    Tony Valko
    01-19-2017, 07:44 PM Go to last post

  28. Convert Month Number (1,2,3, etc) to Quarter Number (1,2,3,4)

    Started by barnett2000‎, 01-19-2017 07:33 PM
    formula
    • 2
    • 3,020
    Phuocam
    01-19-2017, 07:41 PM Go to last post

  29. how to colour code a drop down menu

    Started by loonie‎, 01-16-2017 07:38 PM
    5 Attachment(s)
    • 25
    • 1,428
    Tony Valko
    01-19-2017, 07:05 PM Go to last post

  30. [SOLVED] Change Vlookup to lookup against 2 criterias

    Started by JDobbsy1987‎, 01-18-2017 04:11 PM
    • 5
    • 562
    JDobbsy1987
    01-19-2017, 06:18 PM Go to last post

  31. Is there a formula similar to vlookup except it matches a value with a RANGE?

    Started by h2holbro22‎, 01-19-2017 05:43 PM
    range, reference a cell, vlookup 1 Attachment(s)
    • 2
    • 687
    Richard Buttrey
    01-19-2017, 06:17 PM Go to last post

  32. [SOLVED] Formulas to check two cells in a workbook against two cells in a separate workbook

    Started by Jarviee‎, 01-18-2017 06:08 PM
    salesforce, vlook up 2 Attachment(s)
    • 7
    • 737
    Jarviee
    01-19-2017, 06:16 PM Go to last post

  33. [SOLVED] help with #DIV/0!

    Started by scudo‎, 01-19-2017 02:02 PM
    • 4
    • 327
    Richard Buttrey
    01-19-2017, 06:05 PM Go to last post

  34. Smile Dropdown - multiple conditions

    Started by Travman1986‎, 01-19-2017 05:15 PM
    1 Attachment(s)
    • 1
    • 291
    sandy666
    01-19-2017, 05:59 PM Go to last post

  35. How to get info from one sheet to another automatically in a workbook without vlookup

    Started by spryng‎, 01-16-2017 12:47 PM
    4 Attachment(s)
    • 7
    • 685
    spryng
    01-19-2017, 05:53 PM Go to last post

  36. Help with Formula to Pull Different Iterations of Different Customers

    Started by BIGDOG123‎, 01-19-2017 02:18 AM
    customer, iteration
    • 1
    • 402
    tuph
    01-19-2017, 05:25 PM Go to last post

  37. Skipping the first word in a text string

    Started by JFNORDEN‎, 01-19-2017 04:59 PM
    • 6
    • 634
    sandy666
    01-19-2017, 05:14 PM Go to last post

  38. [SOLVED] Cell Value to be blank

    Started by yuenk‎, 01-19-2017 04:13 PM
    • 3
    • 518
    yuenk
    01-19-2017, 04:28 PM Go to last post

  39. Return top three headers with the highest values (some with the same value)

    Started by Warp8nt‎, 01-19-2017 02:19 PM
    1 Attachment(s)
    • 4
    • 470
    JohnTopley
    01-19-2017, 03:48 PM Go to last post

  40. Pulling Specific Data from copies of main template sheets

    Started by BBekim‎, 01-19-2017 03:22 PM
    • 3
    • 357
    AliGW
    01-19-2017, 03:40 PM Go to last post

  41. Linking and opening jpeg files using hyperlinks/formulas

    Started by IGJ‎, 01-18-2017 08:19 PM
    1 Attachment(s)
    • 3
    • 477
    Logit
    01-19-2017, 03:28 PM Go to last post

  42. Summarize data on multiple criteria

    Started by sabha‎, 01-19-2017 09:57 AM
    2 Attachment(s)
    • 14
    • 1,277
    JohnTopley
    01-19-2017, 02:56 PM Go to last post

  43. [SOLVED] Additions to an Array Formula (HELP)

    Started by boren0023‎, 01-19-2017 01:23 PM
    excel, formula assistance, worksheet 1 Attachment(s)
    • 6
    • 650
    José Augusto
    01-19-2017, 02:51 PM Go to last post

  44. Question conditional formatting for blank cells dependent on due dates

    Started by Brandi_____‎, 01-19-2017 11:43 AM
    blank, conditional formatting, excel, formulas
    • 3
    • 7,044
    Brandi_____
    01-19-2017, 02:17 PM Go to last post

  45. [SOLVED] Formula to reformat Date

    Started by rizmomin‎, 01-19-2017 01:41 PM
    • 3
    • 474
    AliGW
    01-19-2017, 01:55 PM Go to last post

  46. IF's for multiple criteria and Summing

    Started by sis92y‎, 01-19-2017 01:35 PM
    sum and if's
    • 2
    • 434
    ImranBhatti
    01-19-2017, 01:46 PM Go to last post

  47. Automatically Sorting Data

    Started by Beh162‎, 01-18-2017 12:43 PM
    1 Attachment(s)
    • 3
    • 572
    avk
    01-19-2017, 01:24 PM Go to last post

  48. [SOLVED] Conditional Format Based on Matching or Not of First 3 Letters of another Column

    Started by excel2425‎, 01-19-2017 11:42 AM
    2 Attachment(s)
    • 4
    • 3,149
    etaf
    01-19-2017, 01:13 PM Go to last post

  49. [SOLVED] Count

    Started by Tyso‎, 01-19-2017 12:35 PM
    1 Attachment(s)
    • 4
    • 378
    Tyso
    01-19-2017, 01:07 PM Go to last post

  50. Nested Search Formula - Need Help

    Started by tomm8810‎, 01-18-2017 11:11 PM
    2 Attachment(s)
    • 4
    • 520
    tomm8810
    01-19-2017, 01:00 PM Go to last post
+ Post New Thread
Page 1511 of 5614 FirstFirst ... 1511 ...

Forum Information and Options

Users Browsing this Forum

There are currently 83 users browsing this forum. (2 members & 81 guests)

  1. quick-analytics,
  2. zmike180

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