+ Post New Thread
Page 1013 of 5614 FirstFirst ... 1013 ...
Threads 50601 to 50650 of 280698

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. Question add values from multiple columns in one worksheet to another worksheet based on a match

    Started by MDewane‎, 02-04-2019 01:14 PM
    excel, excel & vba 1 Attachment(s)
    • 4
    • 371
    MDewane
    02-04-2019, 06:22 PM Go to last post

  2. [SOLVED] Counting values based on a criteria with duplicates

    Started by rslush91‎, 02-04-2019 05:25 PM
    2 Attachment(s)
    • 1
    • 279
    dflak
    02-04-2019, 06:15 PM Go to last post

  3. [SOLVED] Correct date from time

    Started by Frigide‎, 02-01-2019 11:28 AM
    3 Attachment(s)
    • 13
    • 270
    Roel Jongman
    02-04-2019, 06:13 PM Go to last post

  4. formula to get oldest date rows

    Started by philliphalljr‎, 02-04-2019 05:21 PM
    1 Attachment(s)
    • 2
    • 337
    FDibbins
    02-04-2019, 05:51 PM Go to last post

  5. Simple formula but data in different locations

    Started by Bendoherty‎, 01-30-2019 08:09 AM
    1 Attachment(s)
    • 4
    • 342
    JeteMc
    02-04-2019, 05:31 PM Go to last post

  6. Formula Conditions i.e. IF Column A = ____ Then tally _____

    Started by SWOPP‎, 02-04-2019 04:30 PM
    1 Attachment(s)
    • 9
    • 422
    SWOPP
    02-04-2019, 05:05 PM Go to last post

  7. [SOLVED] Validation of Hours Work <= 8 hours

    Started by Darreno‎, 02-04-2019 02:48 PM
    1 Attachment(s)
    • 4
    • 221
    Fluff13
    02-04-2019, 04:55 PM Go to last post

  8. Adding a formula into a number format cell

    Started by RwilliamsREI‎, 02-04-2019 04:09 PM
    duration, format cells, shortcuts, time based formula
    • 2
    • 445
    TMS
    02-04-2019, 04:47 PM Go to last post

  9. Date manipulation

    Started by bvwalker1‎, 02-04-2019 03:56 PM
    • 6
    • 327
    bvwalker1
    02-04-2019, 04:22 PM Go to last post

  10. [SOLVED] Draw border when date in column A changes

    Started by lofgren‎, 02-04-2019 03:39 PM
    1 Attachment(s)
    • 3
    • 341
    KOKOSEK
    02-04-2019, 03:56 PM Go to last post

  11. [SOLVED] If(And formula returning wrong value

    Started by AccountingJ‎, 02-04-2019 03:20 PM
    • 2
    • 262
    AccountingJ
    02-04-2019, 03:51 PM Go to last post

  12. [SOLVED] Cannot get the Number and Currency formatting to work.

    Started by Na-Dude‎, 02-04-2019 07:52 AM
    6 Attachment(s)
    • 18
    • 707
    Na-Dude
    02-04-2019, 01:51 PM Go to last post

  13. Mexcel-2010, How to find if there is space between digits and first character/s

    Started by pansee517‎, 02-04-2019 12:15 PM
    2 Attachment(s)
    • 10
    • 529
    pansee517
    02-04-2019, 01:37 PM Go to last post

  14. [SOLVED] Textjoin + condition

    Started by veeejay‎, 02-04-2019 10:15 AM
    3 Attachment(s)
    • 10
    • 1,835
    veeejay
    02-04-2019, 01:23 PM Go to last post

  15. [SOLVED] Displaying Time and Calculating %

    Started by daviesr85‎, 02-04-2019 10:12 AM
    excel, time average, time formatting, time percentages 2 Attachment(s)
    • 7
    • 344
    KOKOSEK
    02-04-2019, 01:05 PM Go to last post

  16. Vlookup

    Started by Redlittle‎, 02-04-2019 12:05 PM
    • 2
    • 214
    63falcondude
    02-04-2019, 12:18 PM Go to last post

  17. [SOLVED] Randomly assign an application to 3 reviewers?

    Started by mleong‎, 02-01-2019 05:31 PM
    assign, randomly 4 Attachment(s)
    • 6
    • 2,877
    GeoffW283
    02-04-2019, 12:13 PM Go to last post

  18. Custom filter a column

    Started by Thistledown‎, 02-04-2019 05:51 AM
    • 1
    • 236
    Special-K
    02-04-2019, 11:15 AM Go to last post

  19. [SOLVED] Count Monthly filtered data

    Started by The.Dude‎, 02-04-2019 10:24 AM
    1 Attachment(s)
    • 4
    • 266
    63falcondude
    02-04-2019, 10:50 AM Go to last post

  20. Form Control formatting

    Started by Dink37797‎, 01-30-2019 09:11 AM
    2 Attachment(s)
    • 7
    • 308
    Dink37797
    02-04-2019, 10:13 AM Go to last post

  21. Question [SOLVED] Occurrence of Numbers

    Started by tta.akmal‎, 02-04-2019 09:27 AM
    2 Attachment(s)
    • 5
    • 235
    KOKOSEK
    02-04-2019, 10:11 AM Go to last post

  22. how to take monthly average of each month separately for larger set of data.

    Started by fahimafzal‎, 02-02-2019 03:33 AM
    data arrangement, excel. formula
    • 2
    • 473
    Pepe Le Mokko
    02-04-2019, 09:46 AM Go to last post

  23. [SOLVED] Partial match in an array

    Started by Supersadie‎, 02-04-2019 06:09 AM
    array, match, partial 1 Attachment(s)
    • 6
    • 998
    Supersadie
    02-04-2019, 09:33 AM Go to last post

  24. [SOLVED] 1) Sum based on time. 2) average per day formula

    Started by pmw19800‎, 02-04-2019 06:45 AM
    1 Attachment(s)
    • 4
    • 265
    Bo_Ry
    02-04-2019, 09:26 AM Go to last post

  25. Adjust one cell in a set of percents that add to 100% and other cells adjust automatically

    Started by Katie620‎, 02-04-2019 07:48 AM
    1 Attachment(s)
    • 1
    • 469
    Olly
    02-04-2019, 09:17 AM Go to last post

  26. Could you tell me why the second half on this formula is not working?

    Started by JChandler8314‎, 02-04-2019 06:26 AM
    • 7
    • 270
    Bo_Ry
    02-04-2019, 09:05 AM Go to last post

  27. [SOLVED] Extract of data based on specific criteria

    Started by Mansfieldexcel‎, 01-30-2019 06:16 AM
    4 Attachment(s)
    • 11
    • 436
    Mansfieldexcel
    02-04-2019, 08:50 AM Go to last post

  28. Automatic Update for duplicate workbook

    Started by Eduards‎, 02-04-2019 07:25 AM
    • 2
    • 472
    Eduards
    02-04-2019, 07:53 AM Go to last post

  29. Question Calculate Which Items Needed to Maximize Returns

    Started by SBoothe‎, 02-04-2019 03:20 AM
    calculate, formula, help challenging problem, vba & macro 2 Attachment(s)
    • 3
    • 424
    Bo_Ry
    02-04-2019, 07:41 AM Go to last post

  30. Keep values from source cell even if source cell is deleted

    Started by rjcarlantonio‎, 01-31-2019 11:48 AM
    3 Attachment(s)
    • 9
    • 1,174
    rjcarlantonio
    02-04-2019, 07:30 AM Go to last post

  31. [SOLVED] Lookup then sum

    Started by justj2‎, 02-03-2019 01:13 PM
    3 Attachment(s)
    • 7
    • 435
    Bo_Ry
    02-04-2019, 06:26 AM Go to last post

  32. [SOLVED] Dragged IF formula but only show TRUE VALUE once

    Started by trolle‎, 02-04-2019 06:03 AM
    1 Attachment(s)
    • 2
    • 257
    Bo_Ry
    02-04-2019, 06:21 AM Go to last post

  33. [SOLVED] Range selection List with no blank cells

    Started by VisionSmart‎, 02-03-2019 04:04 AM
    8 Attachment(s)
    • 13
    • 501
    AliGW
    02-04-2019, 04:28 AM Go to last post

  34. multiple if conditions

    Started by Naciovica‎, 02-04-2019 04:02 AM
    if conditions
    • 1
    • 359
    Pepe Le Mokko
    02-04-2019, 04:12 AM Go to last post

  35. Want to use Conditional Formatting to highlight cells with an inconsistent formula error

    Started by pkm‎, 02-03-2019 08:18 PM
    conditional formatting 1 Attachment(s)
    • 1
    • 1,201
    Pepe Le Mokko
    02-04-2019, 03:47 AM Go to last post

  36. [SOLVED] Why does my Lookup function not work?

    Started by Punxatawny‎, 02-04-2019 03:08 AM
    1 Attachment(s)
    • 2
    • 254
    Punxatawny
    02-04-2019, 03:25 AM Go to last post

  37. [SOLVED] Excel IF AND in array formula

    Started by gideone‎, 02-04-2019 01:34 AM
    excel
    • 3
    • 340
    FDibbins
    02-04-2019, 02:50 AM Go to last post

  38. Ctrl+Enter for Round2 formula

    Started by jp16‎, 02-03-2019 09:31 PM
    1 Attachment(s)
    • 1
    • 285
    GeoffW283
    02-04-2019, 01:54 AM Go to last post

  39. taking every value for lookup value from a table

    Started by Nidocaldo1984‎, 02-04-2019 01:42 AM
    • 1
    • 293
    kersplash
    02-04-2019, 01:51 AM Go to last post

  40. Sequential numbers

    Started by yatindatta‎, 02-02-2019 05:20 PM
    2 Attachment(s)
    • 4
    • 381
    yatindatta
    02-04-2019, 01:36 AM Go to last post

  41. Find the oldest and newest value for each item and calculate the ratio

    Started by henr‎, 02-03-2019 07:50 PM
    2 Attachment(s)
    • 2
    • 312
    henr
    02-04-2019, 12:37 AM Go to last post

  42. Requesting Formula for Re-Formatting Text

    Started by H3br3wHamm3r81‎, 02-03-2019 02:20 AM
    • 5
    • 440
    GeoffW283
    02-03-2019, 10:20 PM Go to last post

  43. Count how many that only relate to a month date range in a column of dates

    Started by leemcguigan‎, 01-19-2019 12:04 PM
    2 Attachment(s)
    • 4
    • 367
    JeteMc
    02-03-2019, 10:13 PM Go to last post

  44. [SOLVED] Multible if statements with different cells and different criteria and different sums

    Started by Wolfieee‎, 02-03-2019 08:30 PM
    • 3
    • 383
    Wolfieee
    02-03-2019, 09:36 PM Go to last post

  45. How to calculate the intersection non linear aggregated curves

    Started by DimtchevD‎, 02-03-2019 02:20 PM
    2 Attachment(s)
    • 2
    • 545
    MrShorty
    02-03-2019, 08:39 PM Go to last post

  46. [SOLVED] Inventory management how to deduct stock from sheet 1 and amend stock value on sheet two

    Started by daire1‎, 02-02-2019 11:23 AM
    • 8
    • 2,296
    alansidman
    02-03-2019, 04:24 PM Go to last post

  47. [SOLVED] Return value when two conditions are met

    Started by Blaon‎, 02-03-2019 11:55 AM
    1 Attachment(s)
    • 2
    • 445
    Blaon
    02-03-2019, 03:31 PM Go to last post

  48. [SOLVED] Match two criteria and return multiple records - INDEX & AGGREGATE, TEXTJOIN function

    Started by remyte‎, 02-03-2019 12:26 PM
    index & aggregate, textjoin function 2 Attachment(s)
    • 3
    • 1,302
    Bo_Ry
    02-03-2019, 01:53 PM Go to last post

  49. [SOLVED] How to Hide and Protect Worksheets

    Started by jrtaylor‎, 02-02-2019 11:32 AM
    hide worksheets, protect worksheet
    • 4
    • 457
    TMS
    02-03-2019, 11:44 AM Go to last post

  50. [SOLVED] Does VLOOKUP always look at first column in a range?

    Started by jrtaylor‎, 02-03-2019 10:58 AM
    today, vlookup 1 Attachment(s)
    • 3
    • 403
    Pepe Le Mokko
    02-03-2019, 11:22 AM Go to last post
+ Post New Thread
Page 1013 of 5614 FirstFirst ... 1013 ...

Forum Information and Options

Users Browsing this Forum

There are currently 62 users browsing this forum. (2 members & 60 guests)

  1. HansDouwe,
  2. MrShorty

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