+ Post New Thread
Page 508 of 5630 FirstFirst ... 508 ...
Threads 25351 to 25400 of 281495

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

  1. Formula to return leave data between two dates.

    Started by AngelaHughes3233‎, 05-18-2021 10:25 PM
    1 Attachment(s)
    • 1
    • 236
    bebo021999
    05-19-2021, 02:43 AM Go to last post

  2. Question What are the calculations behind the excel built-in CORREL function ?

    Started by c43‎, 05-18-2021 10:39 AM
    • 2
    • 233
    c43
    05-19-2021, 01:22 AM Go to last post

  3. [SOLVED] Formula to get the max record with condition

    Started by yllew‎, 05-18-2021 11:51 PM
    3 Attachment(s)
    • 4
    • 210
    yllew
    05-19-2021, 12:54 AM Go to last post

  4. How do I return a formula using vlookup rather than a value

    Started by JSTACK‎, 05-13-2021 09:36 AM
    2 Attachment(s)
    • 11
    • 406
    AliGW
    05-19-2021, 12:43 AM Go to last post

  5. [SOLVED] Column G will not SUM up using formula =SUM(G:G542)

    Started by nsmjc‎, 05-18-2021 07:48 PM
    1 Attachment(s)
    • 2
    • 169
    nsmjc
    05-18-2021, 10:35 PM Go to last post

  6. Determine value based on whether a customer name is in a list

    Started by watson150‎, 05-18-2021 09:18 PM
    • 1
    • 259
    6StringJazzer
    05-18-2021, 09:31 PM Go to last post

  7. Self Referencing loop

    Started by eluzzi‎, 05-18-2021 02:16 PM
    2 Attachment(s)
    • 5
    • 1,890
    eluzzi
    05-18-2021, 08:20 PM Go to last post

  8. Get nth match for Index Match within a specified set of dates

    Started by svander21‎, 05-18-2021 11:32 AM
    1 Attachment(s)
    • 4
    • 268
    svander21
    05-18-2021, 08:03 PM Go to last post

  9. Formula that considers 2 cell values of one sheet before copying into a 2nd sheet

    Started by FIFTYFINGERS‎, 05-13-2021 06:49 PM
    2 Attachment(s)
    • 4
    • 377
    FIFTYFINGERS
    05-18-2021, 06:09 PM Go to last post

  10. Time of Day Calculation

    Started by hpatel517‎, 05-18-2021 03:44 PM
    2 Attachment(s)
    • 3
    • 178
    FlameRetired
    05-18-2021, 05:40 PM Go to last post

  11. [SOLVED] formula IFS

    Started by langeloo‎, 05-18-2021 02:32 AM
    • 5
    • 253
    JohnTopley
    05-18-2021, 03:03 PM Go to last post

  12. [SOLVED] INDEX and MATCH, failing to return value using the LEFT function in the formula

    Started by Nikox9‎, 05-18-2021 04:03 AM
    index + match, left
    • 2
    • 362
    Nikox9
    05-18-2021, 02:54 PM Go to last post

  13. [SOLVED] Help on index match formula

    Started by sunboy‎, 05-18-2021 02:06 PM
    1 Attachment(s)
    • 3
    • 220
    KOKOSEK
    05-18-2021, 02:46 PM Go to last post

  14. [SOLVED] Multiply a set of numbers but ignoring zeros when present (see attached)

    Started by Mike G.‎, 05-18-2021 12:15 PM
    1 Attachment(s)
    • 7
    • 267
    Fluff13
    05-18-2021, 02:34 PM Go to last post

  15. [SOLVED] Index Match Formula Issue

    Started by gotiono‎, 05-17-2021 05:50 PM
    1 Attachment(s)
    • 10
    • 363
    gotiono
    05-18-2021, 01:32 PM Go to last post

  16. Conditional Formatting

    Started by dcampbe1‎, 05-18-2021 12:39 PM
    2 Attachment(s)
    • 1
    • 209
    TMS
    05-18-2021, 01:01 PM Go to last post

  17. [SOLVED] Excel 2007 functions unable to accept more than 1 argument

    Started by bandit2220‎, 05-14-2021 04:12 PM
    1 Attachment(s)
    • 6
    • 304
    bandit2220
    05-18-2021, 12:10 PM Go to last post

  18. [SOLVED] Conditional if in Excel Function

    Started by mailtoashok13‎, 05-18-2021 10:13 AM
    condition formula results, excel & formula, microsoft excel 2013, validation
    • 4
    • 327
    TMS
    05-18-2021, 10:58 AM Go to last post

  19. INDEX / MATCH with duplicate cells

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

  20. Lightbulb IF Value is Entered, Text is Input

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

  21. [SOLVED] Excel Lookup from different sheet

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

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

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

  23. Comparing to Columns if Less Than a Percentage Yes

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

  24. Find Months and Days between 2 dates

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

  25. 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
    • 401
    amconnel
    05-18-2021, 10:07 AM Go to last post

  26. 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,474
    chaysp81
    05-18-2021, 09:52 AM Go to last post

  27. [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
    • 450
    maxi0009in
    05-18-2021, 08:06 AM Go to last post

  28. [SOLVED] Conditional Formatting not working

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

  29. 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
    • 376
    Giri.hb
    05-18-2021, 05:45 AM Go to last post

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

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

  31. 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
    • 425
    Orif
    05-18-2021, 05:28 AM Go to last post

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

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

  33. [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
    • 311
    Amadan90
    05-18-2021, 03:18 AM Go to last post

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

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

  35. File Path Formula for the sub Folder

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

  36. Understanding how a formula works

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

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

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

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

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

  39. Count holiday days between dates

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

  40. [SOLVED] iferror with array formula

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

  41. Present Value Function Question

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

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

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

  43. 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
    • 542
    cubangt
    05-17-2021, 04:19 PM Go to last post

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

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

  45. Index Match To Return Transposed Array Values

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

  46. [SOLVED] Text Join Substitute - Formula Assistance

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

  47. 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
    • 480
    mrvazque
    05-17-2021, 11:37 AM Go to last post

  48. remove a /000 as a per thousand divider

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

  49. Date and Time function

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

  50. Choosing the best option base on division

    Started by dzbeda1‎, 05-16-2021 07:27 PM
    5 Attachment(s)
    • 7
    • 346
    kvsrinivasamurthy
    05-17-2021, 08:24 AM Go to last post
+ Post New Thread
Page 508 of 5630 FirstFirst ... 508 ...

Forum Information and Options

Users Browsing this Forum

There are currently 66 users browsing this forum. (4 members & 62 guests)

  1. AliGW,
  2. Czeslaw,
  3. windknife

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