+ Post New Thread
Page 1104 of 5621 FirstFirst ... 1104 ...
Threads 55151 to 55200 of 281022

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

  1. Drop-down-list based on what cell contains

    Started by Ibo‎, 09-21-2018 05:20 PM
    2 Attachment(s)
    • 3
    • 480
    FDibbins
    09-22-2018, 01:56 AM Go to last post

  2. In a list of different names let me know if Drew ever says "yes"

    Started by blens1‎, 09-21-2018 11:57 PM
    • 4
    • 211
    BadlySpelledBuoy
    09-22-2018, 12:39 AM Go to last post

  3. Project Percentage Tracking Formulas - HELP PLEASE!!

    Started by loz1206‎, 09-16-2018 06:13 PM
    1 Attachment(s)
    • 5
    • 981
    JeteMc
    09-21-2018, 09:50 PM Go to last post

  4. [SOLVED] first and last text match from list

    Started by forilohud‎, 09-20-2018 03:29 PM
    1 Attachment(s)
    • 6
    • 822
    jtakw
    09-21-2018, 06:54 PM Go to last post

  5. Why won't my 'OR' formula work for all of my rows?

    Started by stell64‎, 09-21-2018 05:18 PM
    • 3
    • 248
    ¯\_(ツ)_/¯
    09-21-2018, 05:53 PM Go to last post

  6. If condition more or less than

    Started by Ibo‎, 09-21-2018 04:17 PM
    • 7
    • 262
    FDibbins
    09-21-2018, 05:50 PM Go to last post

  7. Question [SOLVED] order form problem?

    Started by savage16‎, 09-21-2018 04:20 PM
    4 Attachment(s)
    • 5
    • 265
    ¯\_(ツ)_/¯
    09-21-2018, 05:15 PM Go to last post

  8. Question Easier way to write a COUNTIFS function

    Started by Brosenberger‎, 09-21-2018 03:01 PM
    • 2
    • 256
    tim201110
    09-21-2018, 04:20 PM Go to last post

  9. Ranking data in dependent arrays

    Started by charlieg83‎, 09-21-2018 02:37 PM
    1 Attachment(s)
    • 6
    • 221
    charlieg83
    09-21-2018, 03:36 PM Go to last post

  10. If then help for report sheet

    Started by muhammadc21‎, 09-21-2018 02:49 PM
    1 Attachment(s)
    • 3
    • 228
    63falcondude
    09-21-2018, 03:08 PM Go to last post

  11. How to extract number data based off multiple text criteria

    Started by Mac204‎, 09-19-2018 09:42 AM
    1 Attachment(s)
    • 1
    • 317
    Tsjallie
    09-21-2018, 02:38 PM Go to last post

  12. Question [SOLVED] Need to remove everything before a numberic digit in string

    Started by KrysBTrying‎, 09-21-2018 01:42 PM
    • 3
    • 212
    63falcondude
    09-21-2018, 02:07 PM Go to last post

  13. [SOLVED] VLOOKUP Alternative

    Started by pskwaak‎, 09-21-2018 01:26 PM
    • 5
    • 445
    63falcondude
    09-21-2018, 02:07 PM Go to last post

  14. [SOLVED] Sum multiple values based on a certain text

    Started by pmw19800‎, 09-21-2018 07:53 AM
    1 Attachment(s)
    • 6
    • 365
    pmw19800
    09-21-2018, 01:57 PM Go to last post

  15. Subtotals for Individual Accounts

    Started by DanWand‎, 09-20-2018 08:38 PM
    1 Attachment(s)
    • 6
    • 335
    DanWand
    09-21-2018, 01:41 PM Go to last post

  16. Will Conditional Formatting Do This?

    Started by wayneski1oo‎, 09-20-2018 03:30 PM
    • 4
    • 249
    FlameRetired
    09-21-2018, 01:33 PM Go to last post

  17. [SOLVED] Export/Split data from DataModel to sheets

    Started by Speshul‎, 09-21-2018 12:59 PM
    • 1
    • 362
    Speshul
    09-21-2018, 01:15 PM Go to last post

  18. [SOLVED] COUNTIF Formulas to correlate with conditional formatting rules

    Started by VadaliaOnions‎, 09-19-2018 02:09 PM
    1 Attachment(s)
    • 8
    • 342
    Aardigspook
    09-21-2018, 12:49 PM Go to last post

  19. Regarding a formula of 2 arguments

    Started by PRADIPHH‎, 09-21-2018 12:03 PM
    1 Attachment(s)
    • 1
    • 197
    63falcondude
    09-21-2018, 12:13 PM Go to last post

  20. Smaller of Two Values but Zero if Negative

    Started by kwbarnes‎, 09-21-2018 10:42 AM
    1 Attachment(s)
    • 4
    • 249
    Glenn Kennedy
    09-21-2018, 11:54 AM Go to last post

  21. Hi all. Need to generate a search engine that can extract data from multiple columns

    Started by waqasnoor‎, 09-21-2018 11:20 AM
    • 1
    • 290
    tim201110
    09-21-2018, 11:50 AM Go to last post

  22. [SOLVED] Formula to calculate Age

    Started by rizmomin‎, 09-21-2018 11:14 AM
    1 Attachment(s)
    • 4
    • 341
    63falcondude
    09-21-2018, 11:35 AM Go to last post

  23. Prevent DAX measure from calculating subtotals

    Started by stefanthapper‎, 09-21-2018 08:10 AM
    dax, hasonevalue, measure, pivot, subtotal 1 Attachment(s)
    • 1
    • 1,308
    rorya
    09-21-2018, 10:38 AM Go to last post

  24. [SOLVED] HLookup w/ Source Formatting Preserved

    Started by excelgod123‎, 09-21-2018 08:52 AM
    1 Attachment(s)
    • 2
    • 537
    excelgod123
    09-21-2018, 09:31 AM Go to last post

  25. Formula to meet a goal

    Started by Sasquatch2014‎, 09-21-2018 07:03 AM
    • 3
    • 363
    Kaper
    09-21-2018, 09:17 AM Go to last post

  26. Formula that gives me a specific value after removing top and bottom 10%

    Started by vani2004‎, 09-21-2018 08:59 AM
    • 2
    • 1,289
    vani2004
    09-21-2018, 09:16 AM Go to last post

  27. Conditional Formatting where formula is included

    Started by colin5392‎, 09-21-2018 04:33 AM
    1 Attachment(s)
    • 5
    • 347
    davsth
    09-21-2018, 08:45 AM Go to last post

  28. [SOLVED] How to store data in the columns if the data is not organized..?

    Started by abdul khader‎, 09-20-2018 01:21 PM
    2 Attachment(s)
    • 6
    • 558
    63falcondude
    09-21-2018, 08:27 AM Go to last post

  29. Conditional Formatting utilizing 1 StDev Above Formula

    Started by jkinnick‎, 09-20-2018 02:25 PM
    conditional formatting, standard deviation 2 Attachment(s)
    • 5
    • 702
    63falcondude
    09-21-2018, 08:05 AM Go to last post

  30. [SOLVED] Formula searching non-blank values in chart

    Started by pezalmendra‎, 09-08-2018 11:12 AM
    2 Attachment(s)
    • 2
    • 362
    pezalmendra
    09-21-2018, 07:01 AM Go to last post

  31. View Table based on drop down list selection

    Started by wiseguy00‎, 09-20-2018 05:26 AM
    drop dowm list, table 1 Attachment(s)
    • 4
    • 450
    wiseguy00
    09-21-2018, 06:58 AM Go to last post

  32. [SOLVED] Whats the use of Match with Match Type=1

    Started by jp16‎, 09-21-2018 12:24 AM
    • 4
    • 306
    XLent
    09-21-2018, 06:56 AM Go to last post

  33. [SOLVED] Conditional data types

    Started by excelhumblelearner‎, 09-20-2018 01:10 PM
    data types, drop down lists 1 Attachment(s)
    • 6
    • 432
    excelhumblelearner
    09-21-2018, 06:46 AM Go to last post

  34. [SOLVED] Calculation of billing sheet

    Started by akshay6s‎, 09-21-2018 02:48 AM
    1 Attachment(s)
    • 12
    • 437
    samba_ravi
    09-21-2018, 06:09 AM Go to last post

  35. Multiple VLOOKUPs in one cell

    Started by MatthewWallis‎, 09-21-2018 05:30 AM
    • 3
    • 470
    shukla.ankur281190
    09-21-2018, 06:00 AM Go to last post

  36. formula always returns #VALUE! when reference cell is blank

    Started by delboy007‎, 09-21-2018 03:45 AM
    • 2
    • 352
    Kaper
    09-21-2018, 03:54 AM Go to last post

  37. [SOLVED] how to add part to formula for blank response

    Started by bdouglas1011‎, 09-21-2018 01:30 AM
    1 Attachment(s)
    • 6
    • 357
    bdouglas1011
    09-21-2018, 03:48 AM Go to last post

  38. Identifying of weeks that cross into the following month and ignore the days that do

    Started by lewiesth‎, 09-21-2018 02:00 AM
    3 Attachment(s)
    • 1
    • 259
    tim201110
    09-21-2018, 02:46 AM Go to last post

  39. Gradient Fill for Rows

    Started by jp16‎, 09-20-2018 11:41 PM
    1 Attachment(s)
    • 1
    • 276
    tim201110
    09-21-2018, 02:24 AM Go to last post

  40. [SOLVED] How to link multiple Dependant dropdown and "lock the cells"

    Started by ec4excel‎, 09-19-2018 02:42 AM
    4 Attachment(s)
    • 7
    • 391
    shukla.ankur281190
    09-21-2018, 01:44 AM Go to last post

  41. [SOLVED] To create Table 2 with reference to Table 1 ... Which formula should I enter?

    Started by chief_abound‎, 09-20-2018 10:55 PM
    2 Attachment(s)
    • 8
    • 370
    chief_abound
    09-21-2018, 01:18 AM Go to last post

  42. Formula – Use of Match formula without helpers for replacement of assets

    Started by Wolfslair‎, 09-19-2018 11:58 PM
    2 Attachment(s)
    • 8
    • 821
    Bo_Ry
    09-21-2018, 12:40 AM Go to last post

  43. Is there a way to get data depending on the SUM VALUE of another data?

    Started by EXCELBENCH‎, 09-13-2018 01:56 PM
    8 Attachment(s)
    • 18
    • 536
    JeteMc
    09-20-2018, 11:45 PM Go to last post

  44. Question [SOLVED] New to the Forum-Keep getting: you've entered too many arguments for this function

    Started by earabit‎, 09-20-2018 08:30 PM
    • 2
    • 298
    earabit
    09-20-2018, 11:28 PM Go to last post

  45. [SOLVED] Wildcard in frequency formula

    Started by werko‎, 09-20-2018 08:56 PM
    • 2
    • 656
    werko
    09-20-2018, 10:32 PM Go to last post

  46. Unhappy Need help on using Left & Replace function together

    Started by Summer0830‎, 09-20-2018 06:17 AM
    • 8
    • 504
    Summer0830
    09-20-2018, 10:05 PM Go to last post

  47. Cool Unique count with multiple criteria-Solved

    Started by LMG57‎, 09-18-2018 04:28 PM
    formula, unique count 2 Attachment(s)
    • 7
    • 513
    LMG57
    09-20-2018, 09:00 PM Go to last post

  48. [SOLVED] if statement with countifs statement with two variables

    Started by quentin5000‎, 09-11-2018 12:59 AM
    2 Attachment(s)
    • 6
    • 370
    quentin5000
    09-20-2018, 08:42 PM Go to last post

  49. [SOLVED] Formula for Returning an Array

    Started by Zavala‎, 09-20-2018 06:45 PM
    array formula, vlookup
    • 6
    • 344
    FlameRetired
    09-20-2018, 07:29 PM Go to last post

  50. Question SUMPRODUCT that is going wrong for some reason

    Started by cohlar‎, 09-14-2018 06:21 AM
    1 Attachment(s)
    • 10
    • 435
    cohlar
    09-20-2018, 06:06 PM Go to last post
+ Post New Thread
Page 1104 of 5621 FirstFirst ... 1104 ...

Forum Information and Options

Users Browsing this Forum

There are currently 87 users browsing this forum. (4 members & 83 guests)

  1. BE_receiving,
  2. cturner62,
  3. tacnola,
  4. Tricks420

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