+ Post New Thread
Page 62 of 5619 FirstFirst ... 62 ...
Threads 3051 to 3100 of 280911

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

  1. [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
    • 662
    AliGW
    05-24-2020, 07:29 AM Go to last post

  2. How to clean raw dataset

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

  3. Vlookup formula code entry

    Started by sherryp5165‎, 12-12-2017 09:40 PM
    2 Attachment(s)
    • 23
    • 1,054
    sherryp5165
    12-19-2017, 05:15 PM Go to last post

  4. [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

  5. 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,721
    dackson
    06-20-2017, 04:17 AM Go to last post

  6. [SOLVED] How can I remove Salutation

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

  7. [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,149
    AliGW
    08-02-2017, 04:24 AM Go to last post

  8. Lookup in Multiple Columns and return a string

    Started by Beh162‎, 08-30-2017 05:31 PM
    3 Attachment(s)
    • 23
    • 832
    AliGW
    08-31-2017, 04:23 PM Go to last post

  9. Sum variable range

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

  10. Probability issue

    Started by limpfisch‎, 10-08-2017 05:23 AM
    4 Attachment(s)
    • 23
    • 815
    Richard Buttrey
    10-10-2017, 04:14 AM Go to last post

  11. [SOLVED] rectangular array lookup

    Started by toolmanjz‎, 10-04-2017 12:04 PM
    2 Attachment(s)
    • 23
    • 1,167
    toolmanjz
    10-05-2017, 10:38 AM Go to last post

  12. [SOLVED] Tracking school pupil data and making comparisons

    Started by 90paulwilson‎, 11-04-2020 01:10 PM
    7 Attachment(s)
    • 23
    • 367
    Limor_OP
    11-05-2020, 06:56 AM Go to last post

  13. [SOLVED] Date formula fail

    Started by sipa‎, 01-01-2018 09:09 AM
    2 Attachment(s)
    • 23
    • 795
    AliGW
    01-02-2018, 12:18 PM Go to last post

  14. Calculating a group of cells based on start and end date.

    Started by Johnr0626‎, 11-25-2015 02:55 PM
    5 Attachment(s)
    • 23
    • 1,189
    FlameRetired
    11-29-2015, 02:50 PM Go to last post

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

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

  16. 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

  17. [SOLVED] Golf Handicap / Scoring System

    Started by Golf_Tragic‎, 08-04-2020 09:05 AM
    4 Attachment(s)
    • 23
    • 725
    AliGW
    08-13-2020, 08:02 AM Go to last post

  18. [SOLVED] Conditional formatting formula for multiple conditions matching

    Started by ninja_beth‎, 08-05-2020 05:11 PM
    conditional formatting 15 Attachment(s)
    • 23
    • 1,130
    ninja_beth
    10-06-2020, 04:49 PM Go to last post

  19. [SOLVED] Sort a column by last name

    Started by thedunna‎, 11-27-2020 02:39 PM
    7 Attachment(s)
    • 23
    • 646
    kvsrinivasamurthy
    11-29-2020, 11:19 PM 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
    • 731
    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
    • 370
    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
    • 480
    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
    • 711
    HansDouwe
    08-19-2022, 10:58 AM Go to last post

  24. Extract Data from 12 different sheets into one single column without VBA and PowerQuerry

    Started by greatinfoteam‎, 11-10-2022 08:27 AM
    automatically data fill, combine data, extract data from cell, transpose data, unique values 8 Attachment(s)
    • 23
    • 581
    kvsrinivasamurthy
    11-23-2022, 05:53 AM Go to last post

  25. [SOLVED] If name change then change the number

    Started by HaroonSid‎, 12-29-2022 04:00 AM
    8 Attachment(s)
    • 23
    • 410
    HansDouwe
    12-30-2022, 09:44 AM Go to last post

  26. Return 10 largest values using VBA

    Started by Martinbif‎, 06-28-2013 06:46 PM
    5 Attachment(s)
    • 23
    • 1,441
    Martinbif
    06-30-2013, 11:57 AM Go to last post

  27. SUMPRODUCT help

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

  28. [SOLVED] Replacing commas with carriage return

    Started by Bob Phillips‎, 09-06-2005 02:05 AM
    • 23
    • 941
    Hardip
    09-06-2005, 08:05 PM Go to last post

  29. [SOLVED] Formula to determine shift

    Started by Biff‎, 09-06-2005 03:05 AM
    • 23
    • 1,563
    Liz
    09-06-2005, 07:05 PM 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,136
    NBVC
    08-20-2008, 10:35 AM Go to last post

  31. Find lowest value from multiple sheets

    Started by Amrit‎, 07-13-2009 05:12 PM
    5 Attachment(s)
    • 23
    • 11,259
    Amrit
    07-16-2009, 06:11 PM Go to last post

  32. Conditional convert to lowercase

    Started by greek‎, 11-03-2009 08:01 AM
    • 23
    • 1,942
    NBVC
    11-03-2009, 10:30 PM Go to last post

  33. Sum if field contains?

    Started by Jefree‎, 02-01-2010 06:58 PM
    2 Attachment(s)
    • 23
    • 2,613
    Jefree
    02-02-2010, 02:21 PM Go to last post

  34. Max value

    Started by kpratico‎, 03-22-2010 02:11 PM
    8 Attachment(s)
    • 23
    • 1,310
    NBVC
    03-25-2010, 11:06 AM Go to last post

  35. [SOLVED] Help with COUNTIFS formula containing ORs

    Started by ConnieIrene‎, 02-09-2013 02:51 PM
    3 Attachment(s)
    • 23
    • 2,466
    ConnieIrene
    02-09-2013, 10:54 PM Go to last post

  36. Exclamation [SOLVED] Function in Conditional Formatting Not Working

    Started by quack618‎, 05-31-2013 05:39 PM
    2 Attachment(s)
    • 23
    • 7,972
    dredwolf
    06-03-2013, 02:03 AM Go to last post

  37. Trouble extracting and keeping numbers from an alphanumeric string

    Started by hammer32‎, 06-08-2013 06:17 AM
    1 Attachment(s)
    • 23
    • 1,293
    samsla
    06-08-2013, 02:31 PM Go to last post

  38. [SOLVED] How to avoid formula circular references and hiding and locking the formula

    Started by Venkata Krishna‎, 06-21-2013 02:52 AM
    3 Attachment(s)
    • 23
    • 4,343
    TMS
    06-21-2013, 08:17 AM Go to last post

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

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

  40. 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

  41. Automatically transfer text from one cell to another cell

    Started by handhglassworks‎, 04-25-2014 08:50 AM
    • 23
    • 5,510
    ChemistB
    05-16-2014, 03:56 PM Go to last post

  42. [SOLVED] Find Value in Array and return value in cell to right

    Started by Ashtangi‎, 05-05-2014 01:43 AM
    3 Attachment(s)
    • 23
    • 1,230
    hemesh
    05-05-2014, 05:21 PM Go to last post

  43. Post [SOLVED] Sum of hours needed

    Started by vjharry‎, 05-29-2014 11:58 AM
    hours, hours distribution, sum, sum of multiple columns 2 Attachment(s)
    • 23
    • 1,574
    FDibbins
    05-29-2014, 11:59 PM Go to last post

  44. [SOLVED] SumProduct with different sized arrays

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

  45. [SOLVED] counting unique dates

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

  46. Lightbulb Exclude Specific Colored Rows in a SUMIF Function

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

  47. Automatic Generate Numbers based on already assigned letters

    Started by sunil31‎, 11-28-2015 08:08 AM
    1 Attachment(s)
    • 23
    • 1,301
    sunil31
    11-28-2015, 11:44 PM Go to last post

  48. [SOLVED] Formula to auto fill in the location

    Started by jackson_hollon‎, 12-27-2015 03:53 PM
    2 Attachment(s)
    • 23
    • 2,139
    FDibbins
    12-27-2015, 08:19 PM Go to last post

  49. Help recognising bank holidays for colleague shifts

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

  50. SUMIF over multiple columns

    Started by psmith4497‎, 06-17-2005 11:44 AM
    • 23
    • 2,965
    bj
    09-06-2005, 10:05 AM Go to last post
+ Post New Thread
Page 62 of 5619 FirstFirst ... 62 ...

Forum Information and Options

Users Browsing this Forum

There are currently 69 users browsing this forum. (7 members & 62 guests)

  1. esaelias,
  2. jaredino,
  3. jurgen230776,
  4. k.tanton,
  5. lordpvl,
  6. Phuocam,
  7. priyansh77

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