+ Post New Thread
Page 601 of 5614 FirstFirst ... 601 ...
Threads 30001 to 30050 of 280687

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

  1. Index match and (Compare)/Conditional formatting !!!!

    Started by pmw19800‎, 04-18-2017 10:34 AM
    4 Attachment(s)
    • 9
    • 411
    shukla.ankur281190
    04-20-2017, 03:32 AM Go to last post

  2. Exclamation I think it's a solution for an Index Function, but I'm not sure how...

    Started by superhud2015‎, 07-22-2015 03:40 PM
    2 Attachment(s)
    • 9
    • 568
    FDibbins
    07-22-2015, 05:55 PM Go to last post

  3. [SOLVED] need totals from 4 weekly workbooks to auto populate onto monthly workbook

    Started by Philm1971‎, 07-23-2015 04:19 AM
    4 Attachment(s)
    • 9
    • 525
    oeldere
    07-23-2015, 05:56 AM Go to last post

  4. [SOLVED] + symbol directly following = in formula

    Started by KG869‎, 07-23-2015 03:43 PM
    • 9
    • 640
    Kyle123
    07-23-2015, 04:06 PM Go to last post

  5. [SOLVED] Return not found instead of 0

    Started by Patcheen‎, 07-24-2015 06:54 PM
    • 9
    • 484
    Tony Valko
    07-24-2015, 09:55 PM Go to last post

  6. [SOLVED] Recreating a new table removing all the 0's

    Started by mikehu‎, 07-25-2015 09:17 AM
    • 9
    • 492
    mikehu
    07-25-2015, 12:12 PM Go to last post

  7. [SOLVED] Average array formula to conitinue calculating even if one of cells or many are empty

    Started by wellous‎, 07-28-2015 08:14 AM
    • 9
    • 434
    Tony Valko
    07-28-2015, 12:17 PM Go to last post

  8. [SOLVED] Extract Data /Look up Data / To get data automatically by refering invoice number

    Started by PMH2384‎, 04-07-2017 05:36 AM
    5 Attachment(s)
    • 9
    • 538
    Glenn Kennedy
    04-17-2017, 04:03 AM Go to last post

  9. [SOLVED] How to split the Total Outstanding of Loan Applicants in various Days Buckets

    Started by purav82‎, 04-06-2017 01:10 PM
    3 Attachment(s)
    • 9
    • 543
    JeteMc
    04-11-2017, 09:00 AM Go to last post

  10. Formula Help for Annual Leave Tracker

    Started by Roquet_Man‎, 04-11-2017 04:57 AM
    2 Attachment(s)
    • 9
    • 842
    canapone
    04-11-2017, 01:47 PM Go to last post

  11. [SOLVED] Add rows in Alternate columns, divide by fixed rate per column.

    Started by jomili‎, 04-12-2017 11:03 AM
    1 Attachment(s)
    • 9
    • 672
    Pete_UK
    04-12-2017, 06:46 PM Go to last post

  12. In a nutshell, I’m trying to store/save a daily increasing value by date...

    Started by 4bits‎, 04-14-2017 05:27 PM
    3 Attachment(s)
    • 9
    • 442
    Jamesera27
    04-15-2017, 05:42 PM Go to last post

  13. HELP! depreciation of asset

    Started by dzz‎, 04-17-2017 11:41 AM
    3 Attachment(s)
    • 9
    • 838
    tim201110
    04-17-2017, 03:02 PM Go to last post

  14. [SOLVED] Make conditional format ignore blank cells.

    Started by Graham Pall‎, 07-22-2015 07:44 AM
    • 9
    • 826
    Graham Pall
    07-22-2015, 09:15 AM Go to last post

  15. Average calculation with condition

    Started by nagesh.tvsr‎, 04-19-2017 08:34 AM
    3 Attachment(s)
    • 9
    • 407
    Glenn Kennedy
    04-21-2017, 02:50 AM Go to last post

  16. [SOLVED] Help with a date formula, please!

    Started by majornoms‎, 05-15-2020 08:48 PM
    date, formula, solved 2 Attachment(s)
    • 9
    • 524
    Vraag en antwoord
    05-16-2020, 01:02 PM Go to last post

  17. Help with Formula for feet and money

    Started by ft13‎, 05-08-2020 03:35 PM
    • 9
    • 297
    FDibbins
    05-11-2020, 12:02 PM Go to last post

  18. [SOLVED] Simple IF Forumla?

    Started by Smasen91‎, 05-12-2020 03:21 PM
    1 Attachment(s)
    • 9
    • 315
    AliGW
    05-12-2020, 04:30 PM Go to last post

  19. AVERAGEIFS (exclude 0 and greater than)

    Started by olga6542‎, 05-13-2020 06:35 PM
    2 Attachment(s)
    • 9
    • 6,366
    MrShorty
    05-15-2020, 01:31 AM Go to last post

  20. Value Error Excel SUMIF and SUMProduct formulas horizontal & vertical criteria

    Started by Bijou85‎, 05-15-2020 11:12 AM
    1 Attachment(s)
    • 9
    • 419
    AliGW
    06-01-2020, 01:13 PM Go to last post

  21. if cell empty or not

    Started by jonwish‎, 05-17-2020 01:15 PM
    1 Attachment(s)
    • 9
    • 257
    jonwish
    05-17-2020, 01:46 PM Go to last post

  22. [SOLVED] Top Selling Products - ranking product name error

    Started by josephteh‎, 05-23-2020 01:40 AM
    2 Attachment(s)
    • 9
    • 318
    AliGW
    05-23-2020, 06:17 AM Go to last post

  23. [SOLVED] 5 levels deep dependent dropdown lists with output at the end.

    Started by 9x9‎, 05-25-2020 10:55 AM
    2 Attachment(s)
    • 9
    • 374
    9x9
    05-26-2020, 02:10 AM Go to last post

  24. [SOLVED] Combine Text with Numbers with no spacing

    Started by chaiyya345‎, 05-29-2020 04:28 AM
    • 9
    • 269
    AliGW
    05-29-2020, 04:54 AM Go to last post

  25. [SOLVED] Conditional formating 3 time frames

    Started by Havreliuc‎, 05-31-2020 03:40 PM
    1 Attachment(s)
    • 9
    • 344
    Havreliuc
    06-01-2020, 03:50 AM Go to last post

  26. [SOLVED] vlookup from 4 drop down lists?

    Started by Oldsquid‎, 12-01-2013 11:28 AM
    vlookup 2 Attachment(s)
    • 9
    • 989
    Oldsquid
    01-05-2014, 10:02 AM Go to last post

  27. filter 400 names from list 1 from list 2 with 4000 names

    Started by [email protected]‎, 09-06-2005 03:05 AM
    • 9
    • 516
    Ed
    09-06-2005, 10:05 PM Go to last post

  28. Formula to duplicate data to second sheet

    Started by Sandy Mann‎, 09-06-2005 02:05 PM
    • 9
    • 430
    Donald Macleod
    09-06-2005, 08:05 PM Go to last post

  29. [SOLVED] Average of numbers within a range meeting certain criteria

    Started by Domenic‎, 09-06-2005 12:05 PM
    • 9
    • 601
    opal23k
    09-06-2005, 09:05 PM Go to last post

  30. text to columns (vertically stacked)

    Started by JamesGale‎, 07-22-2009 11:59 AM
    1 Attachment(s)
    • 9
    • 13,499
    rajuj
    01-03-2014, 12:53 AM Go to last post

  31. Question How to Check if exists value and return cell

    Started by virtualdark‎, 12-15-2011 06:18 AM
    • 9
    • 1,763
    arthurbr
    12-15-2011, 08:24 AM Go to last post

  32. Sum through dissimilar sheets

    Started by BRISBANEBOB‎, 01-06-2012 02:21 AM
    2 Attachment(s)
    • 9
    • 1,040
    e4excel
    01-07-2012, 08:39 AM Go to last post

  33. self calculating time sheet

    Started by gerard_gonzales33‎, 01-17-2012 05:04 AM
    4 Attachment(s)
    • 9
    • 6,031
    gerard_gonzales33
    01-19-2012, 04:41 AM Go to last post

  34. Calculating what is needed to meet a certain percentage

    Started by cg380‎, 04-10-2013 04:46 PM
    2 Attachment(s)
    • 9
    • 1,399
    rylo
    04-15-2013, 06:46 PM Go to last post

  35. Conditional formating

    Started by joelrjt‎, 04-12-2013 03:16 PM
    2 Attachment(s)
    • 9
    • 543
    joelrjt
    04-16-2013, 04:32 AM Go to last post

  36. Calculating Costs of Different Pieces and Prices with a Minimum

    Started by vinnypiazza‎, 04-15-2013 09:18 PM
    calculating, differece, minimum 1 Attachment(s)
    • 9
    • 774
    Tony Valko
    04-17-2013, 09:56 PM Go to last post

  37. [SOLVED] ArrayFormula with condition which values to choose by string

    Started by dania‎, 04-16-2013 05:04 AM
    array formula, choose by string 2 Attachment(s)
    • 9
    • 678
    dania
    04-16-2013, 07:56 AM Go to last post

  38. Move whole row of data to different worksheet if first cell in row = s

    Started by GwenShaw‎, 08-02-2013 05:43 PM
    • 9
    • 2,100
    pknaqviw
    01-02-2014, 03:20 AM Go to last post

  39. Referencing multiple sheets

    Started by jcburkinabe‎, 07-22-2015 08:02 AM
    3 Attachment(s)
    • 9
    • 736
    jcburkinabe
    07-23-2015, 05:45 AM Go to last post

  40. Help with automatic populate the table based on Year

    Started by Stanislav‎, 12-12-2013 11:40 AM
    2 Attachment(s)
    • 9
    • 766
    Stanislav
    01-06-2014, 09:20 AM Go to last post

  41. Find the difference between two days and minus a day.

    Started by JacksonB‎, 01-03-2014 05:30 PM
    • 9
    • 845
    AlKey
    01-04-2014, 02:24 PM Go to last post

  42. Calculating a new sum if a diffrent hourly rate is entered

    Started by guilf87‎, 01-06-2014 10:22 AM
    3 Attachment(s)
    • 9
    • 674
    guilf87
    01-06-2014, 12:15 PM Go to last post

  43. Question List of horizontal numbers in different columns

    Started by juanjr1945‎, 06-28-2015 07:04 PM
    2 Attachment(s)
    • 9
    • 587
    FlameRetired
    04-18-2017, 12:09 AM Go to last post

  44. Drop down menu

    Started by Patcheen‎, 06-10-2015 02:09 PM
    5 Attachment(s)
    • 9
    • 1,524
    Patcheen
    07-21-2015, 06:09 PM Go to last post

  45. [SOLVED] Index Match and Sum using Dynamic Area Number

    Started by rjnc‎, 07-24-2015 05:54 AM
    dynamic cell reference, index & match, sum index match 3 Attachment(s)
    • 9
    • 1,004
    Tony Valko
    07-24-2015, 09:53 AM Go to last post

  46. I have a formula thats works but I need it to include other sheets in my workbook

    Started by MM1414‎, 07-21-2015 12:43 PM
    1 Attachment(s)
    • 9
    • 618
    MM1414
    07-24-2015, 11:13 AM Go to last post

  47. How can i remove remove the last "?" from a cell/url string?

    Started by mikey42979‎, 07-21-2015 01:43 PM
    • 9
    • 634
    bhenlee
    07-21-2015, 02:13 PM Go to last post

  48. Duplicate showing due to year conflict - help

    Started by mw2‎, 07-21-2015 02:25 PM
    5 Attachment(s)
    • 9
    • 661
    FlameRetired
    07-23-2015, 03:10 AM Go to last post

  49. [SOLVED] Average formula that must search for the information

    Started by Linsie‎, 07-21-2015 04:09 PM
    1 Attachment(s)
    • 9
    • 413
    Linsie
    07-21-2015, 04:41 PM Go to last post

  50. [SOLVED] How can I use the NOW function and keep it from auto updating?

    Started by bj‎, 09-06-2005 03:05 AM
    • 9
    • 491
    Bear
    09-06-2005, 08:05 PM Go to last post
+ Post New Thread
Page 601 of 5614 FirstFirst ... 601 ...

Forum Information and Options

Users Browsing this Forum

There are currently 61 users browsing this forum. (0 members & 61 guests)

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