+ Post New Thread
Page 1011 of 5614 FirstFirst ... 1011 ...
Threads 50501 to 50550 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. [SOLVED] Take average of a range -- excluding top 1/3 and bottom 1/3 and zero values

    Started by saravnepali‎, 07-30-2020 02:29 AM
    2 Attachment(s)
    • 7
    • 477
    JeteMc
    08-01-2020, 06:29 PM Go to last post

  2. [SOLVED] Formula for Deleting Text based on Criteria

    Started by mlbdc2012‎, 01-31-2015 08:07 PM
    2 Attachment(s)
    • 7
    • 589
    GC Excel
    02-01-2015, 11:59 PM Go to last post

  3. Dynamic dependent drop menus

    Started by isasa74‎, 11-07-2016 07:05 AM
    • 7
    • 547
    isasa74
    12-12-2016, 11:28 AM Go to last post

  4. Fill cells with discharge dates

    Started by stephenedwardbennett‎, 12-02-2016 11:58 AM
    2 Attachment(s)
    • 7
    • 698
    Roland84
    12-08-2016, 09:13 AM Go to last post

  5. [SOLVED] How to concatenate the month and financial year field into one date?

    Started by The_Snook‎, 12-07-2016 12:27 PM
    • 7
    • 3,510
    The_Snook
    12-09-2016, 05:48 AM Go to last post

  6. [SOLVED] Dynamic reference in COUNTIF

    Started by GIS2013‎, 12-09-2016 07:49 AM
    2 Attachment(s)
    • 7
    • 928
    etaf
    12-09-2016, 09:10 AM Go to last post

  7. VLookup

    Started by 19marc87‎, 12-12-2016 10:56 AM
    1 Attachment(s)
    • 7
    • 410
    AliGW
    12-12-2016, 05:24 PM Go to last post

  8. [SOLVED] Partial Search to Extract values in a Table (column A2:C142) into column K2:L24

    Started by bjnockle‎, 08-02-2020 07:25 PM
    4 Attachment(s)
    • 7
    • 474
    GeoffW283
    08-10-2020, 03:45 PM Go to last post

  9. Question [SOLVED] Totals needed for scoring categories with thresholds

    Started by CJMSteve‎, 08-09-2020 11:55 PM
    2 Attachment(s)
    • 7
    • 222
    CJMSteve
    08-10-2020, 12:51 AM Go to last post

  10. [SOLVED] Error - You May Not Use References To Other Workbooks For Data Validation Criteria

    Started by zanshin777‎, 08-05-2020 01:47 PM
    2 Attachment(s)
    • 7
    • 3,440
    Fluff13
    08-06-2020, 08:18 AM Go to last post

  11. [SOLVED] How to split names in 3 cells

    Started by bkcffee‎, 05-20-2019 03:36 AM
    1 Attachment(s)
    • 7
    • 375
    Haluk
    08-09-2020, 06:45 AM Go to last post

  12. Search for multiple values in one table in another

    Started by Shauna5115‎, 07-29-2020 05:24 PM
    1 Attachment(s)
    • 7
    • 329
    AliGW
    08-07-2020, 02:51 AM Go to last post

  13. Conditional Formatting - Date Range

    Started by Brettk‎, 08-05-2020 03:58 PM
    2 Attachment(s)
    • 7
    • 337
    GeoffW283
    08-05-2020, 06:49 PM Go to last post

  14. [SOLVED] Help with a data validation formula

    Started by mwood6275‎, 01-29-2015 01:05 PM
    excel formula, excel formula syntax 1 Attachment(s)
    • 7
    • 1,758
    TMS
    02-01-2015, 01:58 AM Go to last post

  15. How To Sum Cells When Value Changes In Another Column From 0 to 1?

    Started by excel-help‎, 08-04-2020 12:26 PM
    2 Attachment(s)
    • 7
    • 291
    oeldere
    08-04-2020, 02:23 PM Go to last post

  16. [SOLVED] Formula to put date in proper format

    Started by arpanpanchal‎, 08-04-2020 12:54 AM
    2 Attachment(s)
    • 7
    • 360
    AliGW
    08-04-2020, 02:38 AM Go to last post

  17. Creating Monthly Accounting Schedule

    Started by tori.clemons5‎, 08-06-2020 09:57 AM
    3 Attachment(s)
    • 7
    • 378
    tori.clemons5
    08-12-2020, 10:39 AM Go to last post

  18. Counting for a Recent Ranking Value

    Started by fearindex87‎, 07-22-2020 10:37 AM
    2 Attachment(s)
    • 7
    • 258
    JeteMc
    07-30-2020, 11:04 AM Go to last post

  19. [SOLVED] Aging between two dates

    Started by bmunoz64‎, 07-27-2020 07:27 AM
    2 Attachment(s)
    • 7
    • 410
    bebo021999
    07-28-2020, 11:49 PM Go to last post

  20. 16 bit addition and subtraction

    Started by micro7311‎, 07-30-2020 06:41 PM
    3 Attachment(s)
    • 7
    • 2,322
    GeoffW283
    07-31-2020, 04:46 PM Go to last post

  21. [SOLVED] Array Formula with Conditions Not Working

    Started by Merf‎, 07-30-2020 10:34 PM
    array formula
    • 7
    • 652
    XLent
    07-31-2020, 10:10 AM Go to last post

  22. [SOLVED] Search by cell ( address.. Array all results not only 1.

    Started by Gochix2018‎, 07-31-2020 10:32 PM
    4 Attachment(s)
    • 7
    • 427
    Gochix2018
    08-01-2020, 01:45 PM Go to last post

  23. Index and Match on multiple similar tables

    Started by infinia‎, 08-06-2020 02:43 AM
    excel, index & match, index + match, index and match, index and match function 3 Attachment(s)
    • 7
    • 732
    Haseeb Avarakkan
    08-06-2020, 03:42 AM Go to last post

  24. _xlfn.single problem

    Started by NickyC‎, 08-11-2020 02:50 AM
    • 7
    • 4,150
    NickyC
    08-12-2020, 03:33 AM Go to last post

  25. [SOLVED] Remove duplication in possible combination of 3 digits

    Started by volka‎, 08-12-2020 07:51 AM
    combination of data, duplicate check, excel formula 2 Attachment(s)
    • 7
    • 529
    José Augusto
    08-12-2020, 11:24 AM Go to last post

  26. Grouping one column into categories

    Started by lalalalalola‎, 10-15-2013 06:43 AM
    • 7
    • 1,367
    XOR LX
    10-16-2013, 11:50 AM Go to last post

  27. Check my IF function

    Started by KH_GS‎, 04-03-2006 05:33 AM
    • 7
    • 1,029
    Bob Phillips
    04-06-2006, 04:30 AM Go to last post

  28. convert number to time

    Started by JR‎, 04-03-2006 01:10 PM
    • 7
    • 688
    Dave Peterson
    04-03-2006, 02:10 PM Go to last post

  29. Stumped: If a cell contains a formula, can you make text color automatically change?

    Started by qwopzxnm‎, 04-04-2006 11:40 AM
    • 7
    • 4,161
    Max
    04-04-2006, 11:20 PM Go to last post

  30. Formula Combination

    Started by Randy‎, 04-05-2006 07:35 PM
    • 7
    • 839
    JethroUK©
    04-05-2006, 08:00 PM Go to last post

  31. VLookup Question?

    Started by PH NEWS‎, 03-01-2006 10:30 AM
    • 7
    • 2,644
    Max
    03-02-2006, 08:15 AM Go to last post

  32. Aggregating data without a pivot?

    Started by adr150‎, 10-21-2008 01:52 PM
    aggregating, pivot table, vlookup
    • 7
    • 1,368
    arthurbr
    10-22-2008, 03:39 PM Go to last post

  33. Conditional formatting with formula referencing range in different cell

    Started by pethaa1791‎, 10-21-2008 02:51 PM
    1 Attachment(s)
    • 7
    • 1,474
    pethaa1791
    10-21-2008, 03:54 PM Go to last post

  34. formula to calc % variance of 2 negatives

    Started by KG14‎, 12-11-2012 05:06 AM
    1 Attachment(s)
    • 7
    • 1,311
    Kevin UK
    12-11-2012, 07:04 AM Go to last post

  35. How to find the strongest and weakest of 8 items , which are in pairs?

    Started by logesharun‎, 12-07-2012 03:53 AM
    1 Attachment(s)
    • 7
    • 1,378
    logesharun
    12-09-2012, 11:25 PM Go to last post

  36. [SOLVED] How to use an IF statement to evaluate two different cells with a number and a date

    Started by scsuflyboy‎, 12-10-2012 09:30 PM
    • 7
    • 601
    vlady
    12-10-2012, 11:11 PM Go to last post

  37. [SOLVED] If duplicate display (text) the 1st time, all other (text)

    Started by jtilley‎, 12-11-2012 01:00 AM
    1 Attachment(s)
    • 7
    • 606
    FDibbins
    12-11-2012, 01:33 AM Go to last post

  38. Comparing dates between 3 different cells

    Started by pcaffrey‎, 10-15-2013 03:17 AM
    1 Attachment(s)
    • 7
    • 623
    Ursul
    10-17-2013, 12:19 AM Go to last post

  39. [SOLVED] help needed to write a vlookup, match or combination of both formula

    Started by spittingfire‎, 01-31-2015 08:35 AM
    2 Attachment(s)
    • 7
    • 633
    Glenn Kennedy
    01-31-2015, 09:31 AM Go to last post

  40. Help please!

    Started by Juliano123‎, 10-15-2013 04:15 PM
    1 Attachment(s)
    • 7
    • 640
    FDibbins
    10-16-2013, 12:24 AM Go to last post

  41. Dynamic range column reference

    Started by tuna666‎, 10-16-2013 05:34 AM
    1 Attachment(s)
    • 7
    • 704
    XOR LX
    10-17-2013, 04:42 AM Go to last post

  42. [SOLVED] Looking for a formula - possibly V or H Lookup or MATCH?

    Started by Clare1234‎, 10-16-2013 06:34 AM
    2 Attachment(s)
    • 7
    • 1,071
    arlu1201
    10-17-2013, 06:53 AM Go to last post

  43. [SOLVED] Vlookup and match

    Started by potato_1986‎, 10-16-2013 06:37 AM
    2 Attachment(s)
    • 7
    • 483
    arlu1201
    10-17-2013, 06:36 AM Go to last post

  44. [SOLVED] Product List / Months Of Year - Vlookup assistance

    Started by Rosco88‎, 10-16-2013 07:32 AM
    1 Attachment(s)
    • 7
    • 480
    arlu1201
    10-17-2013, 06:23 AM Go to last post

  45. Lightbulb Get the top 5 values and associated names

    Started by dheeraj_matta‎, 10-17-2013 11:16 AM
    associate, duplicate, related cells, top 5, values 5 Attachment(s)
    • 7
    • 1,208
    dheeraj_matta
    10-17-2013, 01:02 PM Go to last post

  46. Vlookup result 01/00/1900

    Started by pleiadeez7‎, 10-17-2013 03:51 PM
    01/00/1900, vlookup
    • 7
    • 4,405
    Jonmo1
    10-17-2013, 04:49 PM Go to last post

  47. find last value for date in range

    Started by nielsb‎, 01-29-2015 04:53 PM
    1 Attachment(s)
    • 7
    • 870
    daddylonglegs
    01-29-2015, 08:00 PM Go to last post

  48. [SOLVED] Fortnightly Numbering from Date

    Started by Knawl‎, 01-22-2015 04:45 AM
    1 Attachment(s)
    • 7
    • 6,844
    samba_ravi
    01-27-2015, 07:55 AM Go to last post

  49. [SOLVED] Edit Links

    Started by English Rob‎, 01-27-2015 07:38 PM
    • 7
    • 846
    English Rob
    01-28-2015, 02:28 PM Go to last post

  50. nested fnctions

    Started by Heindrich‎, 04-06-2006 10:30 AM
    • 7
    • 832
    MattShoreson
    04-06-2006, 11:01 AM Go to last post
+ Post New Thread
Page 1011 of 5614 FirstFirst ... 1011 ...

Forum Information and Options

Users Browsing this Forum

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