+ Post New Thread
Page 491 of 5614 FirstFirst ... 491 ...
Threads 24501 to 24550 of 280686

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. Red face Conditional Formatting by Date and Applying a Frequency to provide a Traffic Light

    Started by Jiffy11‎, 07-28-2017 07:21 AM
    7 Attachment(s)
    • 10
    • 1,772
    CAntosh
    10-10-2017, 10:26 AM Go to last post

  2. Post [SOLVED] Time summation base on IF conditions

    Started by Khaldon‎, 03-24-2021 10:38 AM
    1 Attachment(s)
    • 10
    • 486
    Khaldon
    03-24-2021, 01:23 PM Go to last post

  3. [SOLVED] VLOOKUP with 2 matching criteria + calculation.

    Started by powerzasty‎, 09-06-2017 10:21 AM
    2 Attachment(s)
    • 10
    • 937
    Glenn Kennedy
    09-19-2017, 06:18 AM Go to last post

  4. STILL NEED HELP! How can I subtract percentages from 1 sheet to another?

    Started by cellphones232‎, 10-03-2017 12:30 AM
    • 10
    • 488
    alansidman
    10-05-2017, 03:25 AM Go to last post

  5. [SOLVED] INDEX - MATCH (SUM from multiple Sheets)

    Started by chrismil‎, 02-20-2021 04:14 PM
    3 Attachment(s)
    • 10
    • 804
    JohnTopley
    02-22-2021, 12:43 PM Go to last post

  6. Seconds into Hours:Minutes:Seconds

    Started by oneblondebrow‎, 10-08-2017 01:59 PM
    2 Attachment(s)
    • 10
    • 517
    mjr veverka
    10-09-2017, 10:10 AM Go to last post

  7. [SOLVED] Alternative to Offset

    Started by SimonCampbell‎, 10-09-2017 08:19 AM
    offset 3 Attachment(s)
    • 10
    • 7,966
    SimonCampbell
    10-09-2017, 10:08 AM Go to last post

  8. [SOLVED] Parce Date from Text and Match it to a list (easy if your good)

    Started by lougs7‎, 10-10-2017 03:02 PM
    #datematch, #help, #index, #match, #parcing 3 Attachment(s)
    • 10
    • 1,029
    63falcondude
    10-12-2017, 11:40 AM Go to last post

  9. [SOLVED] Array Formulae to Alphabetise on Two Columns

    Started by AliGW‎, 10-10-2017 09:28 AM
    3 Attachment(s)
    • 10
    • 471
    AliGW
    10-12-2017, 08:04 AM Go to last post

  10. Employee Attendance Average

    Started by shivya‎, 10-12-2017 10:41 AM
    2 Attachment(s)
    • 10
    • 695
    shivya
    10-12-2017, 12:48 PM Go to last post

  11. [SOLVED] Formula to get 15th and 20th of the month if weekdays

    Started by rizmomin‎, 10-13-2017 10:08 AM
    3 Attachment(s)
    • 10
    • 1,781
    JohnTopley
    10-13-2017, 02:53 PM Go to last post

  12. [SOLVED] Conditional Formatting according to Criteria

    Started by AaruJaan‎, 03-14-2021 05:03 AM
    conditional change, excel, formatting 3 Attachment(s)
    • 10
    • 515
    AaruJaan
    03-14-2021, 02:31 PM Go to last post

  13. [SOLVED] individual retirement account for 25 month calculators

    Started by lex.luthor‎, 02-16-2020 06:58 PM
    • 10
    • 500
    lex.luthor
    03-09-2021, 10:13 AM Go to last post

  14. Trying to use INDIRECT to build cell ref

    Started by robertpstubbs‎, 03-05-2021 02:48 AM
    1 Attachment(s)
    • 10
    • 302
    JohnTopley
    03-05-2021, 09:08 AM Go to last post

  15. [SOLVED] SUMIFS is retaining Zero

    Started by girishankar09‎, 03-11-2021 01:55 AM
    excel & formula, excel & macro, macros, vba & excel 1 Attachment(s)
    • 10
    • 604
    JohnTopley
    03-11-2021, 10:24 AM Go to last post

  16. Return number of out of date training in a month

    Started by donkey_uk‎, 02-16-2021 02:27 PM
    3 Attachment(s)
    • 10
    • 283
    Glenn Kennedy
    02-17-2021, 07:33 AM Go to last post

  17. [SOLVED] search multiple text in cell and return found text via formula in another

    Started by lilsnoop‎, 03-28-2021 02:21 AM
    5 Attachment(s)
    • 10
    • 470
    lilsnoop
    03-28-2021, 01:26 PM Go to last post

  18. [SOLVED] How to use Vlookup(TRUE) to extract values?

    Started by q988988‎, 02-21-2021 09:20 PM
    6 Attachment(s)
    • 10
    • 475
    q988988
    02-23-2021, 07:26 PM Go to last post

  19. Exclamation [SOLVED] How to sort the types of materials from one column according to position from other column

    Started by El3cTr0‎, 02-24-2021 05:27 AM
    5 Attachment(s)
    • 10
    • 530
    El3cTr0
    02-25-2021, 03:28 AM Go to last post

  20. [SOLVED] Search last value in several worksheets

    Started by Rafaelpresa123‎, 03-08-2021 05:54 PM
    5 Attachment(s)
    • 10
    • 253
    Rafaelpresa123
    03-09-2021, 04:17 AM Go to last post

  21. [SOLVED] Consolidate, but Calculate the Difference (Subtract During Consolidate)

    Started by davidinark‎, 03-09-2021 11:57 AM
    consolidate, difference, sales 5 Attachment(s)
    • 10
    • 840
    Glenn Kennedy
    03-10-2021, 04:10 PM Go to last post

  22. [SOLVED] Color code groups of 4 rows if data in a certain column is in a specific order

    Started by Dino711‎, 03-16-2021 09:04 PM
    color coded, conditional, formatting 4 Attachment(s)
    • 10
    • 747
    Dino711
    03-19-2021, 12:30 PM Go to last post

  23. [SOLVED] How can I clone a drop down list?

    Started by willem1234122‎, 03-22-2021 11:13 AM
    clone, drop down list, sheet 1 Attachment(s)
    • 10
    • 630
    willem1234122
    03-23-2021, 11:35 AM Go to last post

  24. Question use DATEDIF() to count the total between days in a range

    Started by bannowindjammer‎, 03-22-2021 01:49 PM
    datediff 4 Attachment(s)
    • 10
    • 354
    FlameRetired
    03-22-2021, 05:34 PM Go to last post

  25. [SOLVED] row values to a column list!

    Started by stewart08‎, 07-02-2008 03:00 PM
    • 10
    • 745
    NBVC
    07-02-2008, 04:13 PM Go to last post

  26. Exclamation [SOLVED] Counting Red Text Colour, When Applied by Conditional Formatting

    Started by Antligen‎, 06-26-2014 08:04 AM
    colourandtext, count and if, formula 2 Attachment(s)
    • 10
    • 655
    Richard Buttrey
    06-27-2014, 08:25 AM Go to last post

  27. Creating a formula with a variable

    Started by sk51‎, 07-14-2008 09:22 AM
    1 Attachment(s)
    • 10
    • 892
    sk51
    07-14-2008, 10:10 AM Go to last post

  28. Calculate overtime outside core hours

    Started by Val C‎, 05-23-2010 08:54 PM
    4 Attachment(s)
    • 10
    • 3,201
    Lili Robinson
    05-26-2013, 05:33 AM Go to last post

  29. [SOLVED] How do I add conditional color to my rows based on two columns?

    Started by LarryDH‎, 11-01-2012 02:44 PM
    2 Attachment(s)
    • 10
    • 852
    ChemistB
    11-02-2012, 01:14 PM Go to last post

  30. How to make a function recognize a text in the function?

    Started by Ericng‎, 05-29-2013 12:40 AM
    2 Attachment(s)
    • 10
    • 1,101
    Ericng
    05-30-2013, 05:25 AM Go to last post

  31. Counting occurances of last two digits

    Started by sudsymack‎, 05-31-2013 03:22 PM
    right formula, sum and if 2 Attachment(s)
    • 10
    • 1,976
    TMS
    05-31-2013, 04:36 PM Go to last post

  32. [SOLVED] remove specific text from certain cells, then multiply the numerical value left by 0.001

    Started by jeffnoone‎, 06-21-2014 01:04 PM
    • 10
    • 4,775
    Glenn Kennedy
    06-21-2014, 02:25 PM Go to last post

  33. [SOLVED] max value in a range

    Started by LACKT‎, 06-20-2014 01:56 AM
    4 Attachment(s)
    • 10
    • 776
    LACKT
    06-22-2014, 12:46 AM Go to last post

  34. [SOLVED] date and time needs to be auto populate when i insert data in another column.

    Started by Giri.hb‎, 06-29-2014 12:48 AM
    • 10
    • 923
    Tony Valko
    06-29-2014, 09:46 AM Go to last post

  35. gathering values based off critieria and in turn forming a list

    Started by exclusiveicon‎, 05-05-2014 06:12 PM
    array, cell address, count blank cells, index & match, look up 3 Attachment(s)
    • 10
    • 805
    azumi
    06-27-2014, 10:44 AM Go to last post

  36. How to get the filter rows to always get the first and last row in a daterange

    Started by drinu‎, 06-19-2014 09:11 AM
    2 Attachment(s)
    • 10
    • 712
    Tony Valko
    06-25-2014, 09:03 AM Go to last post

  37. [SOLVED] Working days in month without using networkdays ?

    Started by makinmomb‎, 05-26-2014 01:20 PM
    1 Attachment(s)
    • 10
    • 703
    makinmomb
    05-26-2014, 02:35 PM Go to last post

  38. Adding up time in one cell

    Started by ItsShuriken‎, 06-13-2014 03:30 PM
    3 Attachment(s)
    • 10
    • 619
    Jonmo1
    06-17-2014, 10:38 AM Go to last post

  39. [SOLVED] COUNTIFS with blank cells

    Started by NiallC92‎, 03-20-2021 05:13 PM
    blank cell, countifs, range 2 Attachment(s)
    • 10
    • 658
    Gregb11
    03-21-2021, 07:30 AM Go to last post

  40. [SOLVED] Count Duplicates by date

    Started by Trending‎, 06-30-2014 05:49 AM
    3 Attachment(s)
    • 10
    • 830
    Trending
    06-30-2014, 07:53 AM Go to last post

  41. [SOLVED] #NA from SUMPRODUCT

    Started by Deutz‎, 06-30-2014 09:00 PM
    • 10
    • 1,254
    Tony Valko
    07-01-2014, 09:58 PM Go to last post

  42. Red face Bands for incentive payments

    Started by timbo55‎, 07-02-2014 01:23 AM
    excel, formula, if and statements 3 Attachment(s)
    • 10
    • 835
    Punnam
    07-02-2014, 08:08 AM Go to last post

  43. [SOLVED] If formula to detect 2 criteria match

    Started by geliedee‎, 10-01-2015 09:35 AM
    6 Attachment(s)
    • 10
    • 600
    geliedee
    10-07-2015, 12:22 AM Go to last post

  44. [SOLVED] Small function, No Zeros

    Started by windme‎, 10-04-2015 03:31 PM
    1 Attachment(s)
    • 10
    • 1,190
    TMS
    10-04-2015, 08:46 PM Go to last post

  45. Adding date range to SumIf/CountIfs combination

    Started by lans4rd‎, 10-07-2015 05:38 PM
    3 Attachment(s)
    • 10
    • 845
    Richard Buttrey
    10-12-2015, 05:21 PM Go to last post

  46. CountIFS Function

    Started by colegerald38‎, 10-13-2015 06:49 AM
    1 Attachment(s)
    • 10
    • 520
    TMS
    10-13-2015, 09:31 AM Go to last post

  47. YYYYMMDD format change

    Started by dan789‎, 10-14-2015 05:16 AM
    6 Attachment(s)
    • 10
    • 808
    Glenn Kennedy
    10-14-2015, 06:50 AM Go to last post

  48. [SOLVED] Create 2 formulas to calculate remaining annual leaves

    Started by leprince2007‎, 01-08-2017 02:17 PM
    2 Attachment(s)
    • 10
    • 4,434
    Pete_UK
    03-09-2021, 07:41 AM Go to last post

  49. [SOLVED] Counting text that appear less/more than another, using VLOOKUP

    Started by Jones90‎, 10-01-2017 08:29 AM
    data, pupils, school, teacher 1 Attachment(s)
    • 10
    • 618
    Jones90
    10-11-2017, 12:33 PM Go to last post

  50. auto-populate a date based on date began and other variable

    Started by rcm4486‎, 10-13-2017 08:15 AM
    1 Attachment(s)
    • 10
    • 624
    rcm4486
    10-17-2017, 10:05 AM Go to last post
+ Post New Thread
Page 491 of 5614 FirstFirst ... 491 ...

Forum Information and Options

Users Browsing this Forum

There are currently 52 users browsing this forum. (0 members & 52 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