+ Post New Thread
Page 1061 of 5614 FirstFirst ... 1061 ...
Threads 53001 to 53050 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. [SOLVED] Long formula and #VALUE error

    Started by VisionSmart‎, 11-17-2018 08:26 AM
    4 Attachment(s)
    • 12
    • 545
    Glenn Kennedy
    11-19-2018, 04:19 AM Go to last post

  2. creating a list from cross referenced data

    Started by gassiusmax‎, 11-18-2018 01:31 PM
    4 Attachment(s)
    • 3
    • 388
    kvsrinivasamurthy
    11-19-2018, 02:22 AM Go to last post

  3. Simple ? Please help

    Started by watson150‎, 11-18-2018 09:48 PM
    • 2
    • 240
    AliGW
    11-19-2018, 01:54 AM Go to last post

  4. Formula that inputs specific text in a cell, based on what number is in the adjacent cell

    Started by agarford‎, 11-17-2018 12:57 PM
    • 5
    • 770
    AliGW
    11-19-2018, 01:52 AM Go to last post

  5. Unhappy multiple tables, cross referencing and multiple variable lookups,

    Started by jonari‎, 11-17-2018 06:54 PM
    1 Attachment(s)
    • 1
    • 397
    FlameRetired
    11-19-2018, 01:50 AM Go to last post

  6. How do I make a cell that contains a formula but is empty turn a different colour.

    Started by samtev‎, 11-18-2018 07:26 AM
    cell, colour, empty, formula, isblank
    • 4
    • 629
    FDibbins
    11-19-2018, 01:05 AM Go to last post

  7. [SOLVED] Excel Formula to calculate wages for certain months - with some tricky variables

    Started by KJG03‎, 10-31-2018 08:09 PM
    2 Attachment(s)
    • 5
    • 542
    JeteMc
    11-18-2018, 09:52 PM Go to last post

  8. v- lookup formula to pick up site ID references

    Started by geraldccole‎, 11-18-2018 07:03 PM
    1 Attachment(s)
    • 1
    • 335
    jeffreybrown
    11-18-2018, 07:41 PM Go to last post

  9. Expanding values/counts chart

    Started by Unome‎, 11-18-2018 05:02 PM
    • 3
    • 277
    Pete_UK
    11-18-2018, 06:28 PM Go to last post

  10. INDEX & MATCH Error

    Started by zanshin777‎, 11-18-2018 04:15 PM
    • 3
    • 264
    zanshin777
    11-18-2018, 05:50 PM Go to last post

  11. Cell sequence help.

    Started by parbynat‎, 11-18-2018 04:47 PM
    • 2
    • 244
    parbynat
    11-18-2018, 05:02 PM Go to last post

  12. INDEX & MATCH Error - #N/A

    Started by zanshin777‎, 11-18-2018 04:15 PM
    • 1
    • 261
    jeffreybrown
    11-18-2018, 04:17 PM Go to last post

  13. [SOLVED] Looking for a formula for working days

    Started by fabian_76‎, 11-16-2018 05:56 PM
    • 4
    • 339
    fabian_76
    11-18-2018, 02:52 PM Go to last post

  14. Question Help for novice user - Date range functions?

    Started by MokaMAcaroon‎, 11-18-2018 02:20 PM
    function, google sheets, help a student in need
    • 0
    • 444
    MokaMAcaroon
    11-18-2018, 02:20 PM Go to last post

  15. For a given range of cells B5:T5 count the number of cells containing x

    Started by bnicarlson‎, 11-18-2018 12:16 PM
    1 Attachment(s)
    • 6
    • 418
    Glenn Kennedy
    11-18-2018, 02:19 PM Go to last post

  16. [SOLVED] Calculate SUM from partial list

    Started by cutty382‎, 11-18-2018 10:22 AM
    2 Attachment(s)
    • 5
    • 446
    Glenn Kennedy
    11-18-2018, 01:40 PM Go to last post

  17. Text Categorisation - if cell contains several text in a single cell, then return a value

    Started by heeemann‎, 11-11-2018 12:18 PM
    6 Attachment(s)
    • 16
    • 582
    Glenn Kennedy
    11-18-2018, 01:36 PM Go to last post

  18. INDEX and AGGREGATE to ignore 0's and functions

    Started by Allerdrengen‎, 11-16-2018 08:13 AM
    6 Attachment(s)
    • 12
    • 1,924
    kvsrinivasamurthy
    11-18-2018, 01:07 PM Go to last post

  19. [SOLVED] If formulae with multiple conditions

    Started by anilpatni1234‎, 11-18-2018 07:51 AM
    1 Attachment(s)
    • 6
    • 404
    José Augusto
    11-18-2018, 10:50 AM Go to last post

  20. [SOLVED] Help with IF formula for Max and Min numbers

    Started by DLsteve‎, 11-18-2018 07:21 AM
    1 Attachment(s)
    • 3
    • 373
    AliGW
    11-18-2018, 09:21 AM Go to last post

  21. SUMIFS - fully customizable

    Started by ama56‎, 11-18-2018 07:37 AM
    1 Attachment(s)
    • 1
    • 278
    José Augusto
    11-18-2018, 09:01 AM Go to last post

  22. [SOLVED] Requesting help to finalize long IF/AND statement. Almost there. :)

    Started by Elijah‎, 11-17-2018 09:14 AM
    4 Attachment(s)
    • 7
    • 457
    Elijah
    11-18-2018, 07:50 AM Go to last post

  23. countifs based on criteria

    Started by swfarm‎, 11-18-2018 06:19 AM
    • 1
    • 298
    Phuocam
    11-18-2018, 06:35 AM Go to last post

  24. Question [SOLVED] If date > 90 days & balance > $100 then value yes

    Started by KH0‎, 11-16-2018 05:47 PM
    1 Attachment(s)
    • 15
    • 1,644
    LeoSkywalker
    11-18-2018, 01:07 AM Go to last post

  25. Item Count, Sum Amount and Sum Fee Amount

    Started by ps3623‎, 11-16-2018 10:27 PM
    5 Attachment(s)
    • 11
    • 439
    ps3623
    11-17-2018, 09:18 PM Go to last post

  26. [SOLVED] Count the number of times appears the operator "+"

    Started by coolx72‎, 11-17-2018 12:09 PM
    • 14
    • 468
    LeoSkywalker
    11-17-2018, 08:45 PM Go to last post

  27. [SOLVED] Need help with splitting up day/moth/year hour:minute into separate columns

    Started by EOHstudent‎, 11-17-2018 03:49 PM
    4 Attachment(s)
    • 9
    • 428
    AliGW
    11-17-2018, 04:49 PM Go to last post

  28. [SOLVED] How to use MATCH to get results within varying timestamp periods

    Started by jrtaylor‎, 11-10-2018 07:04 PM
    match, timestamps 2 Attachment(s)
    • 9
    • 2,832
    jrtaylor
    11-17-2018, 01:36 PM Go to last post

  29. change automatically the cell reference

    Started by anetanaro‎, 11-17-2018 09:24 AM
    3 Attachment(s)
    • 1
    • 266
    Aardigspook
    11-17-2018, 12:43 PM Go to last post

  30. [SOLVED] Creating Scoring Ranges for multiple exercises

    Started by aabbey‎, 11-16-2018 07:34 AM
    1 Attachment(s)
    • 2
    • 408
    aabbey
    11-17-2018, 10:43 AM Go to last post

  31. Requesting help to finalize long IF/AND statement. Almost there. :)

    Started by Elijah‎, 11-17-2018 09:13 AM
    • 1
    • 218
    AliGW
    11-17-2018, 10:42 AM Go to last post

  32. [SOLVED] Matching value on 2 sheets

    Started by anilpatni1234‎, 10-06-2018 12:08 PM
    4 Attachment(s)
    • 12
    • 413
    anilpatni1234
    11-17-2018, 10:21 AM Go to last post

  33. Step up SIP value

    Started by sahashumon‎, 11-17-2018 01:10 AM
    • 2
    • 861
    MrShorty
    11-17-2018, 09:56 AM Go to last post

  34. [SOLVED] Move Calendar Formulas

    Started by xjohnson‎, 11-17-2018 08:39 AM
    • 1
    • 256
    xjohnson
    11-17-2018, 09:54 AM Go to last post

  35. [SOLVED] Find the order of appearance

    Started by kent97‎, 11-17-2018 08:18 AM
    3 Attachment(s)
    • 2
    • 1,854
    kent97
    11-17-2018, 08:55 AM Go to last post

  36. [SOLVED] Consequent sums/substractions

    Started by Peter91‎, 11-16-2018 01:18 PM
    4 Attachment(s)
    • 7
    • 284
    Glenn Kennedy
    11-17-2018, 08:39 AM Go to last post

  37. [SOLVED] Include Next Year New Year in Holiday List

    Started by xjohnson‎, 11-17-2018 07:32 AM
    • 2
    • 349
    xjohnson
    11-17-2018, 08:14 AM Go to last post

  38. Question [SOLVED] Formula for calculating difference & % Achievement between Fixed value and running values

    Started by arnabnestle‎, 11-17-2018 03:37 AM
    2 Attachment(s)
    • 7
    • 435
    arnabnestle
    11-17-2018, 04:52 AM Go to last post

  39. Optimization of two pieces to make 1 large piece question

    Started by Zstoppa‎, 11-15-2018 11:20 AM
    cut list, excel, work 1 Attachment(s)
    • 3
    • 479
    Alf
    11-17-2018, 04:51 AM Go to last post

  40. Indirect Function and Worksheets

    Started by toaks32‎, 11-16-2018 03:35 PM
    • 2
    • 331
    FDibbins
    11-17-2018, 03:17 AM Go to last post

  41. Cool I want to select a drop down list item and have it display a unit price in a diff cell

    Started by PergolaPaul‎, 11-16-2018 05:23 PM
    drop down, multiple cells, pricing
    • 2
    • 1,312
    FDibbins
    11-17-2018, 03:15 AM Go to last post

  42. Formula to sum every 6 row

    Started by Luqs‎, 11-16-2018 02:22 AM
    1 Attachment(s)
    • 18
    • 584
    FDibbins
    11-17-2018, 03:08 AM Go to last post

  43. [SOLVED] how to replace last comma in string with "and"

    Started by dschmitt‎, 11-16-2018 02:52 AM
    • 3
    • 516
    FDibbins
    11-17-2018, 02:59 AM Go to last post

  44. multiple index and match using multiple workbooks and sheets.

    Started by TinoBradica‎, 11-12-2018 01:05 PM
    3 Attachment(s)
    • 8
    • 611
    JeteMc
    11-16-2018, 10:40 PM Go to last post

  45. Post Need Help with &Today() function

    Started by Tempus.alexander‎, 11-15-2018 09:09 PM
    1 Attachment(s)
    • 3
    • 343
    GeoffW283
    11-16-2018, 09:41 PM Go to last post

  46. 4 rates, if week reaches over 50 then Flat rate value ,Range date

    Started by dude6571‎, 11-16-2018 02:56 AM
    1 Attachment(s)
    • 1
    • 290
    mehmetcik
    11-16-2018, 09:12 PM Go to last post

  47. Return A cumulative Percentage value based on Today's date referencing a start and end dat

    Started by AbdulkareemAlhassni‎, 11-16-2018 07:50 AM
    • 3
    • 341
    FlameRetired
    11-16-2018, 05:49 PM Go to last post

  48. [SOLVED] Need formula to count total from two criteria where match is variable

    Started by Ochimus‎, 11-16-2018 01:34 PM
    1 Attachment(s)
    • 2
    • 230
    Ochimus
    11-16-2018, 04:54 PM Go to last post

  49. Change recorded macro to remove all the selects... trying to learn how.

    Started by barman‎, 11-16-2018 03:20 PM
    • 3
    • 240
    Fluff13
    11-16-2018, 04:11 PM Go to last post

  50. [SOLVED] Changing Year Not Filling in Holidays

    Started by xjohnson‎, 11-16-2018 03:12 PM
    • 5
    • 273
    xjohnson
    11-16-2018, 04:05 PM Go to last post
+ Post New Thread
Page 1061 of 5614 FirstFirst ... 1061 ...

Forum Information and Options

Users Browsing this Forum

There are currently 63 users browsing this forum. (3 members & 60 guests)

  1. alansidman,
  2. mgs73,
  3. ShihTzu

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