+ Post New Thread
Page 492 of 5614 FirstFirst ... 492 ...
Threads 24551 to 24600 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. INDEX / MATCH with duplicate cells

    Started by andrugrasu‎, 05-18-2021 09:30 AM
    1 Attachment(s)
    • 1
    • 217
    Bernie Deitrick
    05-18-2021, 10:45 AM Go to last post

  2. Lightbulb IF Value is Entered, Text is Input

    Started by therealsouthern‎, 05-18-2021 10:06 AM
    if value
    • 1
    • 224
    JohnTopley
    05-18-2021, 10:44 AM Go to last post

  3. [SOLVED] Excel Lookup from different sheet

    Started by mailtoashok13‎, 05-18-2021 06:12 AM
    1 Attachment(s)
    • 1
    • 218
    josephteh
    05-18-2021, 10:23 AM Go to last post

  4. INDEX/MATCH with moving data and 2 column headers

    Started by Nyx*‎, 05-18-2021 08:43 AM
    1 Attachment(s)
    • 5
    • 645
    JohnTopley
    05-18-2021, 10:20 AM Go to last post

  5. Comparing to Columns if Less Than a Percentage Yes

    Started by ryanb4614‎, 05-17-2021 09:28 AM
    • 8
    • 211
    josephteh
    05-18-2021, 10:09 AM Go to last post

  6. Find Months and Days between 2 dates

    Started by utkarshg‎, 05-18-2021 06:18 AM
    1 Attachment(s)
    • 2
    • 225
    Mgc26133
    05-18-2021, 10:09 AM Go to last post

  7. Question Formula for returning sum of values for three months depending on the end date of a cell

    Started by amconnel‎, 05-17-2021 04:20 PM
    date and lookup, formula building, power query 3 Attachment(s)
    • 7
    • 393
    amconnel
    05-18-2021, 10:07 AM Go to last post

  8. Sum Cells by Font or Cell Colour without VBA

    Started by chaysp81‎, 05-14-2021 08:37 AM
    sum colour, sumif 2 Attachment(s)
    • 9
    • 2,225
    chaysp81
    05-18-2021, 09:52 AM Go to last post

  9. [SOLVED] Macro to add column based on a range & adding formula from right

    Started by maxi0009in‎, 05-05-2021 05:29 AM
    macro 2 Attachment(s)
    • 2
    • 445
    maxi0009in
    05-18-2021, 08:06 AM Go to last post

  10. [SOLVED] Conditional Formatting not working

    Started by Hanleymomma‎, 05-18-2021 05:54 AM
    1 Attachment(s)
    • 1
    • 377
    Pete_UK
    05-18-2021, 06:17 AM Go to last post

  11. need function to find the SLA between days and hours excluding non business hours

    Started by Giri.hb‎, 05-17-2021 05:12 AM
    1 Attachment(s)
    • 9
    • 369
    Giri.hb
    05-18-2021, 05:45 AM Go to last post

  12. [SOLVED] Number of Different Values in a Range Based on Criteria

    Started by Mgc26133‎, 05-11-2021 08:58 PM
    8 Attachment(s)
    • 11
    • 670
    Mgc26133
    05-18-2021, 05:39 AM Go to last post

  13. Question [SOLVED] Conditional formatting with formula and several criteria

    Started by Orif‎, 05-18-2021 04:20 AM
    conditional formatting, excel formula 1 Attachment(s)
    • 2
    • 421
    Orif
    05-18-2021, 05:28 AM Go to last post

  14. excel formula to show last modified date for a specific cell

    Started by tshepolt‎, 05-18-2021 04:01 AM
    1 Attachment(s)
    • 4
    • 1,932
    davsth
    05-18-2021, 04:59 AM Go to last post

  15. [SOLVED] If multiple criteria are met, then .. for all values based on 1 criteria

    Started by Amadan90‎, 05-17-2021 11:23 AM
    multiple criteria
    • 2
    • 308
    Amadan90
    05-18-2021, 03:18 AM Go to last post

  16. Help! Formula(s) to distribute stock among stores

    Started by timma000‎, 05-18-2021 02:14 AM
    1 Attachment(s)
    • 3
    • 656
    Pepe Le Mokko
    05-18-2021, 03:11 AM Go to last post

  17. File Path Formula for the sub Folder

    Started by jasond1992‎, 05-18-2021 01:25 AM
    2 Attachment(s)
    • 0
    • 283
    jasond1992
    05-18-2021, 01:25 AM Go to last post

  18. Understanding how a formula works

    Started by mrawst‎, 05-17-2021 01:11 PM
    2 Attachment(s)
    • 4
    • 268
    bebo021999
    05-18-2021, 12:57 AM Go to last post

  19. Cool [SOLVED] Vlookup refuses to cooperate for 48+ hours

    Started by kamil666‎, 05-17-2021 11:16 PM
    vlookup 1 Attachment(s)
    • 2
    • 299
    kamil666
    05-18-2021, 12:02 AM Go to last post

  20. Regular OT, Double OT and Over 40 hours OT

    Started by RoniBStew‎, 05-17-2021 12:01 PM
    3 Attachment(s)
    • 8
    • 330
    bebo021999
    05-17-2021, 09:54 PM Go to last post

  21. Count holiday days between dates

    Started by janger‎, 05-17-2021 08:21 PM
    • 3
    • 211
    hrlngrv
    05-17-2021, 09:35 PM Go to last post

  22. [SOLVED] iferror with array formula

    Started by pickslides‎, 05-17-2021 08:44 PM
    • 1
    • 239
    Pete_UK
    05-17-2021, 08:58 PM Go to last post

  23. Present Value Function Question

    Started by JimMorrison1971‎, 05-17-2021 02:42 PM
    1 Attachment(s)
    • 3
    • 284
    joeu2004
    05-17-2021, 06:26 PM Go to last post

  24. [SOLVED] Merge multi row data into 1 row

    Started by HelpHelpHelp‎, 05-17-2021 03:36 PM
    1 Attachment(s)
    • 3
    • 213
    Limor_OP
    05-17-2021, 05:01 PM Go to last post

  25. Help with Excel lookup formula please

    Started by chytechp‎, 05-17-2021 09:29 AM
    lookup and match, match & indirect, vlookup, vlookup & match 1 Attachment(s)
    • 9
    • 532
    cubangt
    05-17-2021, 04:19 PM Go to last post

  26. [SOLVED] Help writing formula - If cell = % vs text

    Started by Rick-O-Shay‎, 05-17-2021 03:36 PM
    • 4
    • 240
    Rick-O-Shay
    05-17-2021, 04:18 PM Go to last post

  27. Index Match To Return Transposed Array Values

    Started by larryg003‎, 05-17-2021 09:57 AM
    arrays, index, match, small 5 Attachment(s)
    • 6
    • 519
    Bo_Ry
    05-17-2021, 03:07 PM Go to last post

  28. [SOLVED] Text Join Substitute - Formula Assistance

    Started by NotSwank‎, 05-14-2021 09:25 AM
    5 Attachment(s)
    • 8
    • 352
    NotSwank
    05-17-2021, 02:39 PM Go to last post

  29. Timesheet - What time to clock out not to exceed 37.50 hours?

    Started by mrvazque‎, 05-17-2021 09:12 AM
    excel, overtime, timesheet 5 Attachment(s)
    • 4
    • 446
    mrvazque
    05-17-2021, 11:37 AM Go to last post

  30. remove a /000 as a per thousand divider

    Started by ciderhead‎, 05-17-2021 09:37 AM
    • 2
    • 254
    ciderhead
    05-17-2021, 10:34 AM Go to last post

  31. Date and Time function

    Started by ANDRE LE ROUX‎, 05-17-2021 05:33 AM
    1 Attachment(s)
    • 3
    • 186
    JohnTopley
    05-17-2021, 08:52 AM Go to last post

  32. Choosing the best option base on division

    Started by dzbeda1‎, 05-16-2021 07:27 PM
    5 Attachment(s)
    • 7
    • 343
    kvsrinivasamurthy
    05-17-2021, 08:24 AM Go to last post

  33. [SOLVED] SUMPRODUCTonly once

    Started by andrugrasu‎, 05-17-2021 07:22 AM
    2 Attachment(s)
    • 2
    • 235
    andrugrasu
    05-17-2021, 07:54 AM Go to last post

  34. INDEX and MATCH

    Started by redsoremac‎, 05-17-2021 05:45 AM
    4 Attachment(s)
    • 9
    • 310
    redsoremac
    05-17-2021, 07:27 AM Go to last post

  35. Question [SOLVED] Expand Formula Across Multiple Cells

    Started by Taylah‎, 05-15-2021 09:13 AM
    excel & formula, expand formula, formula array, formula assistance, formula auto adjust 3 Attachment(s)
    • 14
    • 1,334
    Bo_Ry
    05-17-2021, 05:17 AM Go to last post

  36. Question [SOLVED] how to create Pivot Table using multiple sheet

    Started by emmr‎, 05-17-2021 02:51 AM
    1 Attachment(s)
    • 5
    • 254
    rorya
    05-17-2021, 04:40 AM Go to last post

  37. Formula to build net to gross calculation

    Started by dsvid‎, 05-17-2021 04:25 AM
    1 Attachment(s)
    • 1
    • 266
    JohnTopley
    05-17-2021, 04:38 AM Go to last post

  38. [SOLVED] Expected output based on 3 dropdowns

    Started by Neilesh Kumar‎, 05-16-2021 10:22 AM
    5 Attachment(s)
    • 17
    • 573
    Neilesh Kumar
    05-17-2021, 04:22 AM Go to last post

  39. [SOLVED] How to apply IF on LINEST argument

    Started by SimonMRN‎, 05-17-2021 03:40 AM
    linest function 1 Attachment(s)
    • 2
    • 269
    SimonMRN
    05-17-2021, 04:16 AM Go to last post

  40. [SOLVED] Convert Formula from Columns to Row

    Started by kenyon76‎, 05-16-2021 11:38 PM
    1 Attachment(s)
    • 3
    • 274
    hrlngrv
    05-17-2021, 03:40 AM Go to last post

  41. Min IF Function results

    Started by hellodt‎, 05-17-2021 02:39 AM
    • 2
    • 176
    bebo021999
    05-17-2021, 02:42 AM Go to last post

  42. If function with AND imbedded

    Started by Claude2‎, 05-16-2021 12:50 PM
    1 Attachment(s)
    • 2
    • 257
    FDibbins
    05-17-2021, 12:13 AM Go to last post

  43. [SOLVED] Linear interpolation with unevenly spaced data

    Started by WE5T‎, 06-14-2013 03:53 AM
    4 Attachment(s)
    • 9
    • 8,268
    FDibbins
    05-17-2021, 12:09 AM Go to last post

  44. [SOLVED] One incorrect formula in one column used for sorting

    Started by John Henworth‎, 05-16-2021 03:01 PM
    2 Attachment(s)
    • 12
    • 255
    Fluff13
    05-16-2021, 04:05 PM Go to last post

  45. Need to get the expected total from the columns in Excel 2007

    Started by sathyguy‎, 05-16-2021 10:49 AM
    2 Attachment(s)
    • 4
    • 187
    JohnTopley
    05-16-2021, 03:27 PM Go to last post

  46. How to create a Lookup values from 1 combobox AND 1 TEXTBOX on a userform

    Started by Ciupanezul21‎, 05-16-2021 12:26 PM
    4 Attachment(s)
    • 2
    • 236
    Ciupanezul21
    05-16-2021, 03:02 PM Go to last post

  47. [SOLVED] Look-up and return data in a certain cell according to multiple criteria

    Started by Orif‎, 05-16-2021 10:38 AM
    excel formula how to, formula and functions, lookup 2 Attachment(s)
    • 5
    • 463
    Limor_OP
    05-16-2021, 01:20 PM Go to last post

  48. If(And(Index(Match...

    Started by Even‎, 05-16-2021 09:11 AM
    • 10
    • 400
    AliGW
    05-16-2021, 01:06 PM Go to last post

  49. [SOLVED] lookup + multiple results , approximate match , need solution please

    Started by mostafaghazy‎, 05-14-2021 05:19 PM
    2 Attachment(s)
    • 3
    • 343
    thenewkidd
    05-16-2021, 12:48 PM Go to last post

  50. If(Index(Match with multiple criterias

    Started by Even‎, 05-16-2021 12:25 PM
    1 Attachment(s)
    • 1
    • 195
    AliGW
    05-16-2021, 12:39 PM Go to last post
+ Post New Thread
Page 492 of 5614 FirstFirst ... 492 ...

Forum Information and Options

Users Browsing this Forum

There are currently 79 users browsing this forum. (2 members & 77 guests)

  1. DeeWuu,
  2. JeteMc

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