+ Post New Thread
Page 1011 of 5612 FirstFirst ... 1011 ...
Threads 50501 to 50550 of 280553

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

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

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

  2. [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,296
    Bo_Ry
    02-03-2019, 01:53 PM Go to last post

  3. [SOLVED] How to Hide and Protect Worksheets

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

  4. [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
    • 399
    Pepe Le Mokko
    02-03-2019, 11:22 AM Go to last post

  5. [SOLVED] if cell is higher then, but if not

    Started by swfarm‎, 02-03-2019 08:43 AM
    • 4
    • 249
    TMS
    02-03-2019, 09:30 AM Go to last post

  6. [SOLVED] How to count rows based on cell value.

    Started by AccountingJ‎, 02-02-2019 04:53 PM
    1 Attachment(s)
    • 3
    • 353
    Fluff13
    02-03-2019, 09:09 AM Go to last post

  7. Export to Cloud

    Started by Animals1977‎, 02-02-2019 06:28 AM
    4 Attachment(s)
    • 6
    • 589
    Animals1977
    02-03-2019, 08:40 AM Go to last post

  8. [SOLVED] IF error malfunction in excel 2016

    Started by pejoi78‎, 02-03-2019 08:26 AM
    identification, identify range 1 Attachment(s)
    • 2
    • 360
    pejoi78
    02-03-2019, 08:35 AM Go to last post

  9. Mexcel-2010, 16 digit number's last digit changes to zero, format cell doesn't help

    Started by pansee517‎, 02-03-2019 03:40 AM
    • 6
    • 517
    BadlySpelledBuoy
    02-03-2019, 06:05 AM Go to last post

  10. Formula to Change Output Depending on Value of Another Cell

    Started by basketcase01‎, 01-27-2019 12:55 PM
    1 Attachment(s)
    • 9
    • 612
    AliGW
    02-03-2019, 03:46 AM Go to last post

  11. [SOLVED] Copying results in strange values

    Started by Annelie‎, 02-02-2019 12:21 PM
    copy & paste 1 Attachment(s)
    • 8
    • 644
    FDibbins
    02-03-2019, 03:25 AM Go to last post

  12. Array Formula Not Working

    Started by WarrenSmith‎, 02-02-2019 07:28 AM
    • 7
    • 1,377
    FDibbins
    02-03-2019, 03:16 AM Go to last post

  13. Question Dependent Drop Down using Data Validation not working after save and re-opening file

    Started by Laxb14‎, 04-15-2015 05:43 PM
    • 3
    • 1,136
    FDibbins
    02-03-2019, 02:55 AM Go to last post

  14. Thumbs up How to ue offset function with average function

    Started by latte‎, 02-01-2019 06:41 PM
    3 Attachment(s)
    • 4
    • 304
    GeoffW283
    02-02-2019, 09:24 PM Go to last post

  15. V look up using match criteria

    Started by Jacks18928‎, 02-01-2019 08:13 PM
    1 Attachment(s)
    • 3
    • 349
    GeoffW283
    02-02-2019, 06:57 PM Go to last post

  16. [SOLVED] Lookup ID & add together all times of the correct ID

    Started by LeeBillington‎, 02-02-2019 02:50 PM
    1 Attachment(s)
    • 2
    • 260
    LeeBillington
    02-02-2019, 05:47 PM Go to last post

  17. [SOLVED] Formula help I don't even know how to word my problem

    Started by mariep460‎, 02-02-2019 02:10 PM
    1 Attachment(s)
    • 5
    • 285
    AliGW
    02-02-2019, 04:49 PM Go to last post

  18. How to generate random numbers in Beta distribution

    Started by shengjun‎, 01-28-2019 10:20 PM
    • 3
    • 4,283
    shg
    02-02-2019, 04:29 PM Go to last post

  19. [SOLVED] Possible sum/match/index formula problem

    Started by skyep2058‎, 02-01-2019 07:40 PM
    1 Attachment(s)
    • 3
    • 331
    TMS
    02-02-2019, 02:10 PM Go to last post

  20. Days Calculation formula required !!!

    Started by Arunkumaramk‎, 02-02-2019 12:06 PM
    • 11
    • 404
    Pepe Le Mokko
    02-02-2019, 01:11 PM Go to last post

  21. sum the total quantity of sale on every 15 days

    Started by akshay6s‎, 01-28-2019 08:37 AM
    2 Attachment(s)
    • 1
    • 319
    JeteMc
    02-02-2019, 01:05 PM Go to last post

  22. Returning Multiple Column Headers based on cell values

    Started by sitush‎, 01-28-2019 08:10 AM
    excel, match & index 1 Attachment(s)
    • 3
    • 1,604
    JeteMc
    02-02-2019, 12:47 PM Go to last post

  23. How to add multiple column cells based on date

    Started by garethdjohn‎, 01-25-2019 08:32 AM
    8 Attachment(s)
    • 14
    • 823
    JeteMc
    02-02-2019, 12:26 PM Go to last post

  24. [SOLVED] Calculate value from one row based on the text value of another row

    Started by Na-Dude‎, 01-31-2019 09:52 PM
    15 Attachment(s)
    • 23
    • 658
    Na-Dude
    02-02-2019, 12:05 PM Go to last post

  25. How to use multi nested - If with a and or condition

    Started by NewLearner01‎, 02-02-2019 09:31 AM
    nested if and or multiple
    • 4
    • 365
    Pepe Le Mokko
    02-02-2019, 11:37 AM Go to last post

  26. Question Need help with a formula that removes text.

    Started by Casaray‎, 01-28-2019 12:21 AM
    • 9
    • 339
    AlKey
    02-02-2019, 11:35 AM Go to last post

  27. Profit/Expenses

    Started by PrinceTaz‎, 02-02-2019 11:05 AM
    1 Attachment(s)
    • 2
    • 294
    PrinceTaz
    02-02-2019, 11:15 AM Go to last post

  28. How to filter source data and use only that filtered data in results/formula's

    Started by SoccerGirll‎, 01-25-2019 05:39 PM
    • 5
    • 492
    JeteMc
    02-02-2019, 09:47 AM Go to last post

  29. Difference Between Time based off of a 10 Hour Workday

    Started by jclaborn‎, 01-11-2019 12:01 PM
    3 Attachment(s)
    • 7
    • 446
    6StringJazzer
    02-02-2019, 09:40 AM Go to last post

  30. Stop total from continuing numbers in total column

    Started by Puddy‎, 01-07-2019 11:59 AM
    1 Attachment(s)
    • 5
    • 446
    Fluff13
    02-02-2019, 09:15 AM Go to last post

  31. [SOLVED] Conditional formatting based on bi-monthly payday criteria

    Started by slaforce‎, 06-22-2016 03:14 PM
    condidional formatting, payday 1 Attachment(s)
    • 13
    • 3,362
    FDibbins
    02-02-2019, 03:08 AM Go to last post

  32. vlookup with multiple if

    Started by araza123‎, 01-31-2019 05:55 PM
    2 Attachment(s)
    • 5
    • 462
    FDibbins
    02-02-2019, 02:58 AM Go to last post

  33. Count/Sum a value in a row that has multiple match's with another row

    Started by casson35‎, 02-02-2019 01:17 AM
    • 1
    • 287
    AliGW
    02-02-2019, 02:30 AM Go to last post

  34. [SOLVED] I need to add and AND statement to an IF Array

    Started by Hannah122392‎, 02-01-2019 11:40 PM
    2 Attachment(s)
    • 2
    • 284
    Hannah122392
    02-02-2019, 12:15 AM Go to last post

  35. Copying cell contents based on checking another cell against an array of cells

    Started by Mogheh‎, 01-25-2019 04:18 PM
    2 Attachment(s)
    • 2
    • 272
    JeteMc
    02-01-2019, 09:53 PM Go to last post

  36. Formula Help please between two workbooks

    Started by sclarence‎, 02-01-2019 06:33 PM
    • 1
    • 270
    TMS
    02-01-2019, 08:47 PM Go to last post

  37. Fill individual forms with each line on spreadsheet

    Started by jacestar11‎, 01-25-2019 10:40 AM
    2 Attachment(s)
    • 3
    • 313
    JeteMc
    02-01-2019, 08:44 PM Go to last post

  38. Question Conditional Formatting no longer letting me choose font color

    Started by houde‎, 01-24-2019 01:28 PM
    • 8
    • 381
    FlameRetired
    02-01-2019, 07:40 PM Go to last post

  39. Calculate next Scheduled Service date based off a regular schedule

    Started by kgagnon1990‎, 02-01-2019 01:08 PM
    dates, schedule 2 Attachment(s)
    • 2
    • 1,250
    kgagnon1990
    02-01-2019, 07:24 PM Go to last post

  40. Summary data by date from other tabs

    Started by garethdjohn‎, 01-24-2019 11:24 AM
    3 Attachment(s)
    • 9
    • 454
    JeteMc
    02-01-2019, 07:01 PM Go to last post

  41. [SOLVED] Formula for Alpha-Numerical IDs

    Started by jrbattle26‎, 02-01-2019 05:42 PM
    1 Attachment(s)
    • 2
    • 339
    jrbattle26
    02-01-2019, 06:45 PM Go to last post

  42. [SOLVED] Macro to copy selected column to a reference column number

    Started by coolx72‎, 01-31-2019 07:21 PM
    2 Attachment(s)
    • 2
    • 260
    coolx72
    02-01-2019, 05:48 PM Go to last post

  43. [SOLVED] Conditional formatting based on the color of another cell.

    Started by jeremy.wood‎, 01-31-2019 01:37 PM
    colors, conditional formatting
    • 6
    • 4,019
    6StringJazzer
    02-01-2019, 04:30 PM Go to last post

  44. #REFERENCE! error

    Started by unknown4444‎, 02-01-2019 03:03 PM
    • 3
    • 349
    TMS
    02-01-2019, 04:04 PM Go to last post

  45. Compare columns A to B then create a new column of ones that are missing from column A

    Started by terence17‎, 01-31-2019 03:28 PM
    4 Attachment(s)
    • 8
    • 363
    terence17
    02-01-2019, 03:59 PM Go to last post

  46. [SOLVED] Duplicate names to an array, then make random selection

    Started by EchoPassenger‎, 01-31-2019 03:55 PM
    array, random 1 Attachment(s)
    • 3
    • 544
    EchoPassenger
    02-01-2019, 03:42 PM Go to last post

  47. Help using SUMPRODUCT to "COUNTIF" multiple criterion are met.

    Started by miah2bzy‎, 02-01-2019 01:08 PM
    • 4
    • 284
    GeoffW283
    02-01-2019, 02:58 PM Go to last post

  48. [SOLVED] How to Extract Daily data to Weekly

    Started by Ravindran Raman‎, 01-31-2019 11:11 AM
    6 Attachment(s)
    • 5
    • 3,370
    Ravindran Raman
    02-01-2019, 02:52 PM Go to last post

  49. Batch solve complex excel formula

    Started by levatus‎, 01-31-2019 08:22 PM
    2 Attachment(s)
    • 9
    • 651
    shg
    02-01-2019, 02:27 PM Go to last post

  50. Error #value! in a date array formula

    Started by Jiggers‎, 01-31-2019 01:58 PM
    • 3
    • 586
    Jiggers
    02-01-2019, 02:12 PM Go to last post
+ Post New Thread
Page 1011 of 5612 FirstFirst ... 1011 ...

Forum Information and Options

Users Browsing this Forum

There are currently 53 users browsing this forum. (2 members & 51 guests)

  1. CARACALLA,
  2. JN831

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