+ Post New Thread
Page 61 of 5614 FirstFirst ... 61 ...
Threads 3001 to 3050 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. How do I split long paragraphs by character count without separating words?

    Started by PuckVII‎, 07-17-2020 06:16 PM
    3 Attachment(s)
    • 23
    • 691
    BMV
    07-20-2020, 04:46 PM Go to last post

  2. [SOLVED] How can I remove Salutation

    Started by pop2datop‎, 07-16-2017 04:42 AM
    • 23
    • 3,324
    AliGW
    07-16-2017, 09:47 AM Go to last post

  3. [SOLVED] How to sum values based on a specific criteria

    Started by Vitalite‎, 08-01-2017 02:44 AM
    countif, sum 2 Attachment(s)
    • 23
    • 1,146
    AliGW
    08-02-2017, 04:24 AM Go to last post

  4. [SOLVED] How to recreate the formula to input only one outcome

    Started by justynawork‎, 08-04-2017 12:13 PM
    • 23
    • 1,234
    justynawork
    08-10-2017, 07:01 AM Go to last post

  5. [SOLVED] SUMIF exclude some rows

    Started by LIL2606‎, 09-01-2017 01:01 PM
    exclude, sumif 2 Attachment(s)
    • 23
    • 7,782
    FlameRetired
    09-05-2017, 02:10 PM Go to last post

  6. Sum variable range

    Started by jjmmoo‎, 09-19-2017 01:46 AM
    5 Attachment(s)
    • 23
    • 835
    protonLeah
    09-21-2017, 04:15 PM Go to last post

  7. [SOLVED] Compare Different Currencies (including showing lowest value across the currencies)

    Started by KC78‎, 11-20-2019 05:38 AM
    10 Attachment(s)
    • 23
    • 1,693
    Glenn Kennedy
    12-13-2019, 07:57 AM Go to last post

  8. Obtain the latest date using criteria from another column

    Started by johnlee60‎, 12-29-2019 08:21 AM
    5 Attachment(s)
    • 23
    • 535
    Bob Phillips
    12-29-2019, 06:47 PM Go to last post

  9. [SOLVED] How to use Wingdings in formulae

    Started by VisionSmart‎, 02-11-2020 02:56 AM
    12 Attachment(s)
    • 23
    • 2,143
    AliGW
    04-25-2020, 08:32 AM Go to last post

  10. [SOLVED] Re: "Running Count by Hour of the Day" thread

    Started by waimea‎, 04-09-2020 12:50 PM
    1 Attachment(s)
    • 23
    • 754
    Olly
    04-15-2020, 02:46 AM Go to last post

  11. [SOLVED] Match Play Golf Comp having difficulty with winner and allocation of points in table.

    Started by PhilBar‎, 05-23-2020 03:31 AM
    5 Attachment(s)
    • 23
    • 654
    AliGW
    05-24-2020, 07:29 AM Go to last post

  12. Calculation time between start and end time

    Started by obionenairobi‎, 05-29-2020 02:20 AM
    2 Attachment(s)
    • 23
    • 455
    sifubear
    05-30-2020, 01:31 AM Go to last post

  13. [SOLVED] Look up formula from table with uneven format

    Started by kadayadi‎, 07-01-2020 04:53 AM
    3 Attachment(s)
    • 23
    • 914
    JeteMc
    07-09-2020, 09:39 AM Go to last post

  14. [SOLVED] Conditional Formatting and Cell Formula Not Cooperating

    Started by pahickham‎, 06-05-2017 01:20 PM
    2 Attachment(s)
    • 23
    • 783
    sandy666
    06-05-2017, 04:43 PM Go to last post

  15. Angry How do I add data to a sheet without messing up the formatting for the whole workbook?

    Started by CSW Supervisor‎, 08-29-2020 12:42 PM
    6 Attachment(s)
    • 23
    • 841
    Richard Buttrey
    08-30-2020, 01:52 PM Go to last post

  16. [SOLVED] Count of data in a text string

    Started by tiger99‎, 05-04-2022 03:24 AM
    9 Attachment(s)
    • 23
    • 549
    tiger99
    05-04-2022, 08:38 PM Go to last post

  17. consolidate sheets into one master

    Started by Tony0731‎, 06-25-2022 02:24 PM
    5 Attachment(s)
    • 23
    • 337
    alansidman
    06-27-2022, 08:48 AM Go to last post

  18. Exclamation Extract values with the help of two criteria

    Started by chintamani.avinash‎, 06-22-2022 02:30 AM
    2 Attachment(s)
    • 23
    • 342
    chintamani.avinash
    06-25-2022, 08:38 AM Go to last post

  19. [SOLVED] Vlookup: partial string match

    Started by Asdf99‎, 06-22-2022 08:40 AM
    8 Attachment(s)
    • 23
    • 350
    AliGW
    06-23-2022, 03:28 AM Go to last post

  20. Using lookup to find the 1st, 2nd, 3rd and 4th value

    Started by Excel_apprentice‎, 08-05-2022 08:54 AM
    lookup, nth value 8 Attachment(s)
    • 23
    • 716
    nick.williams
    08-06-2022, 04:45 AM Go to last post

  21. Return row value with reference to separate worksheet's column value

    Started by Bishnu Adhikari‎, 08-08-2022 02:28 PM
    8 Attachment(s)
    • 23
    • 368
    Bishnu Adhikari
    08-26-2022, 10:45 AM Go to last post

  22. [SOLVED] Calculate Highest since/Lowest Since

    Started by igors16‎, 08-27-2022 06:07 PM
    7 Attachment(s)
    • 23
    • 473
    Glenn Kennedy
    08-28-2022, 05:00 AM Go to last post

  23. Question [SOLVED] SUMIFS and LOOKUP function resulted to NULL value

    Started by hesamson‎, 08-17-2022 04:33 PM
    lookup, sumifs and formula 7 Attachment(s)
    • 23
    • 706
    HansDouwe
    08-19-2022, 10:58 AM Go to last post

  24. [SOLVED] Date formula to show ON TIME and LATE with Exceptions

    Started by Guttenbomber57‎, 10-10-2022 01:27 PM
    11 Attachment(s)
    • 23
    • 714
    etaf
    10-14-2022, 07:55 AM Go to last post

  25. [SOLVED] Formula to count if one or more criteria are met

    Started by cjmccarthy‎, 10-11-2022 05:01 PM
    4 Attachment(s)
    • 23
    • 461
    HansDouwe
    10-12-2022, 11:18 AM Go to last post

  26. Last 12 weeks total from rows not columns

    Started by flapface‎, 10-13-2014 06:09 AM
    11 Attachment(s)
    • 23
    • 1,204
    boopathiraja
    10-14-2014, 09:29 AM Go to last post

  27. SUMPRODUCT help

    Started by svvm‎, 06-20-2005 04:03 AM
    • 23
    • 1,264
    bj
    09-06-2005, 10:05 AM Go to last post

  28. Summing with multiple criteria

    Started by qflyer‎, 06-20-2005 11:33 PM
    • 23
    • 1,340
    Biff
    09-06-2005, 10:05 AM Go to last post

  29. If Then, not using values, or not counting blanks

    Started by Ken Hudson‎, 09-06-2005 01:05 AM
    • 23
    • 825
    Max
    09-06-2005, 11:05 AM Go to last post

  30. Best match for two values to return a third

    Started by chix‎, 08-15-2008 07:40 AM
    2 Attachment(s)
    • 23
    • 3,135
    NBVC
    08-20-2008, 10:35 AM Go to last post

  31. How to separate out a dynamic number range

    Started by Enigmafish14‎, 01-30-2009 01:17 PM
    4 Attachment(s)
    • 23
    • 2,296
    Enigmafish14
    02-05-2009, 06:41 PM Go to last post

  32. [SOLVED] Pre 1800 Dates in Excel 2010

    Started by JO505‎, 01-11-2013 02:06 PM
    7 Attachment(s)
    • 23
    • 7,669
    MarvinP
    01-13-2013, 11:19 AM Go to last post

  33. How to create a function of 2 mathematical formulas?

    Started by killwin98‎, 05-09-2013 03:47 AM
    3 Attachment(s)
    • 23
    • 1,384
    killwin98
    05-09-2013, 04:54 PM Go to last post

  34. Creating unique id's for repeat occurances

    Started by Nickyh1984‎, 06-02-2014 08:30 AM
    6 Attachment(s)
    • 23
    • 1,378
    oeldere
    06-05-2014, 06:03 PM Go to last post

  35. [SOLVED] SumProduct with different sized arrays

    Started by KBreeze15‎, 06-26-2014 02:47 PM
    7 Attachment(s)
    • 23
    • 1,892
    XOR LX
    06-27-2014, 01:36 PM Go to last post

  36. [SOLVED] counting unique dates

    Started by guy13‎, 09-22-2014 06:13 AM
    11 Attachment(s)
    • 23
    • 1,149
    guy13
    09-22-2014, 10:50 AM Go to last post

  37. Lightbulb Exclude Specific Colored Rows in a SUMIF Function

    Started by tshives26‎, 07-16-2014 02:38 PM
    • 23
    • 13,374
    tshives26
    07-18-2014, 11:27 AM Go to last post

  38. Return Yes/No if Multiple numbers per one unique number

    Started by chicity26‎, 07-16-2014 04:02 PM
    2 Attachment(s)
    • 23
    • 1,474
    Jack7774
    07-22-2014, 08:05 AM Go to last post

  39. Monthly summary party wise from a range and duplicate do want to make one qty

    Started by dackson‎, 06-17-2017 03:42 AM
    4 Attachment(s)
    • 23
    • 1,715
    dackson
    06-20-2017, 04:17 AM Go to last post

  40. Need a macro to increase by 1 if text is found

    Started by airhoodz‎, 11-19-2014 03:29 AM
    • 23
    • 961
    abousetta
    11-19-2014, 01:03 PM Go to last post

  41. [SOLVED] Need to find different values against same name

    Started by samorita‎, 09-28-2015 07:20 AM
    5 Attachment(s)
    • 23
    • 1,129
    samorita
    10-01-2015, 10:35 AM Go to last post

  42. [SOLVED] Index & match help

    Started by BMBme‎, 10-20-2015 04:35 PM
    2 Attachment(s)
    • 23
    • 1,160
    bebo021999
    10-21-2015, 10:55 AM Go to last post

  43. Finding largest value on mutiple criteria

    Started by Richtheman87‎, 10-17-2015 04:37 AM
    12 Attachment(s)
    • 23
    • 1,529
    bebo021999
    10-19-2015, 11:59 AM Go to last post

  44. [SOLVED] ISSNUMBER is okey, ISTEXT is okey, ISDATE is not okey?

    Started by HerryMarkowitz‎, 10-29-2015 09:13 AM
    2 Attachment(s)
    • 23
    • 3,641
    Jonmo1
    10-29-2015, 02:20 PM Go to last post

  45. Help recognising bank holidays for colleague shifts

    Started by qetjack‎, 11-13-2015 04:10 PM
    5 Attachment(s)
    • 23
    • 1,498
    JohnTopley
    11-16-2015, 01:46 PM Go to last post

  46. Index, Match function is not return as expected.

    Started by Anbuselvam‎, 05-09-2017 02:51 AM
    7 Attachment(s)
    • 23
    • 1,680
    Anbuselvam
    05-10-2017, 10:54 AM Go to last post

  47. Counting Data in the Current Month

    Started by bdav1216‎, 05-20-2017 11:13 PM
    4 Attachment(s)
    • 23
    • 1,080
    JohnTopley
    05-23-2017, 12:16 PM Go to last post

  48. How to clean raw dataset

    Started by DanielMorningstar‎, 07-01-2017 12:54 PM
    9 Attachment(s)
    • 23
    • 826
    FlameRetired
    07-14-2017, 10:56 AM Go to last post

  49. [SOLVED] Formula needed for a matrix

    Started by KatOpti‎, 08-02-2017 06:32 AM
    2 Attachment(s)
    • 23
    • 780
    JeteMc
    08-04-2017, 10:03 AM Go to last post

  50. minutes between

    Started by pogo827‎, 06-07-2005 01:27 PM
    • 23
    • 1,319
    JE McGimpsey
    09-06-2005, 12:05 PM Go to last post
+ Post New Thread
Page 61 of 5614 FirstFirst ... 61 ...

Forum Information and Options

Users Browsing this Forum

There are currently 56 users browsing this forum. (2 members & 54 guests)

  1. CARCHER05,
  2. tungten9x

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