+ Post New Thread
Page 1 of 24 1 ...
Threads 1 to 50 of 1168

Forum: Tips and Tutorials

Sub Forums: Books: Ultimate Excel Help; Get The Most Out Of Functions & Formulae

Sub-Forums Threads / Posts  Last Post

  1. F1 Get the Most out of Excel! The Ultimate Excel Tip Help Guide

    Forum Actions:

    Forum Statistics:

    • Threads: 3
    • Posts: 9

    Last Post:

  2. F1 Get the most out of Excel Formulas & Functions

    Forum Actions:

    Forum Statistics:

    • Threads: 9
    • Posts: 33

    Last Post:

  3. Excel Tips

    Forum Actions:

    Forum Statistics:

    • Threads: 80
    • Posts: 398

    Last Post:

  1. Sticky Thread Sticky: A Whole Bunch of Tips & Tutorials I've Learned

    Started by benishiryo‎, 03-05-2013 10:29 AM
    3 Attachment(s)
    • 171
    • 87,427
    LionelNZ
    04-13-2024, 07:16 PM Go to last post

  2. Sticky Thread Sticky: How to use VLOOKUP (via Formula How-Tool)

    Started by benishiryo‎, 03-14-2016 08:59 AM
    6 Attachment(s)
    • 28
    • 28,839
    AliGW
    01-07-2024, 01:37 PM Go to last post

  3. Cool Sticky Thread Sticky: How to create an editor for Power Query with Notepad++ (thanks Matt Masson)

    Started by sandy666‎, 05-10-2018 01:50 AM
    intellisense, m language, notepad++, power query, syntax highlighting 16 Attachment(s)
    • 23
    • 21,895
    sandy666
    12-15-2022, 05:14 AM Go to last post

  4. Sticky Thread Sticky: Posting an HTML table in a forum thread

    Started by JBeaucaire‎, 06-20-2015 08:07 PM
    1 Attachment(s)
    • 10
    • 71,667
    6StringJazzer
    03-13-2023, 06:35 PM Go to last post

  5. Sticky Thread Sticky: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Started by Doc.AElstein‎, 12-30-2017 04:43 PM
    3 Attachment(s)
    • 8
    • 28,356
    FDibbins
    01-01-2018, 04:01 AM Go to last post

  6. Sticky Thread Sticky: Some Excel VBA Tips & Tricks from my closet

    Started by johnnyL‎, 10-30-2023 02:35 AM
    1 Attachment(s)
    • 7
    • 1,099
    johnnyL
    11-13-2023, 06:36 PM Go to last post

  7. Sticky Thread Sticky: How to De-Sensitize Data

    Started by dflak‎, 03-26-2018 03:25 PM
    1 Attachment(s)
    • 7
    • 10,887
    alansidman
    05-22-2021, 09:51 AM Go to last post

  8. Sticky Thread Sticky: Nine Quick Tips to Improve VBA Performance

    Started by alansidman‎, 06-09-2019 05:00 PM
    • 3
    • 8,322
    --Plato--
    05-24-2022, 03:11 AM Go to last post

  9. Sticky Thread Sticky: Restoring a Corrupted File

    Started by mudraker‎, 03-12-2007 06:33 PM
    • 3
    • 41,107
    Dandy
    06-21-2012, 12:55 PM Go to last post

  10. Sticky Thread Sticky: FAQ - Commercial Services

    Started by arlu1201‎, 05-31-2013 08:50 AM
    1 Attachment(s)
    • 0
    • 13,182
    arlu1201
    05-31-2013, 08:50 AM Go to last post

  1. What's in Your Personal.xls?

    Started by shg‎, 06-15-2009 11:06 AM
    6 Attachment(s)
    • 53
    • 32,658
    MrShorty
    07-25-2014, 09:58 PM Go to last post

  2. UK Companies House API

    Started by Kyle123‎, 01-27-2016 01:27 PM
    2 Attachment(s)
    • 38
    • 20,483
    joeburg
    03-24-2020, 11:08 AM Go to last post

  3. [SOLVED] Creating a Timesheet

    Started by Jennifer‎,  
    • 33
    • 17,905
    philmcracken
    05-14-2007, 04:03 PM Go to last post

  4. ConcatAll UDF by TigerAvatar

    Started by tigeravatar‎, 09-13-2012 12:40 PM
    array, concatall, concatenate, multiple strings, tigeravatar 2 Attachment(s)
    • 33
    • 26,253
    FDibbins
    07-17-2017, 02:01 AM Go to last post

  5. Get Data from wireless networks available to me

    Started by johnnyL‎, 07-22-2023 09:53 PM
    2 Attachment(s)
    • 27
    • 1,478
    aurelien_vba
    12-23-2023, 07:44 AM Go to last post

  6. Thumbs up Replacing Small Function with xSmall....

    Started by Vikas_Gautam‎, 08-11-2014 11:20 PM
    non-zero small, small, xsmall 1 Attachment(s)
    • 27
    • 1,648
    Vikas_Gautam
    08-13-2014, 06:13 AM Go to last post

  7. Thumbs up NthMatch UDF as An Alternative to Array function...

    Started by Vikas_Gautam‎, 08-08-2014 12:03 AM
    8 Attachment(s)
    • 27
    • 2,406
    kvsrinivasamurthy
    01-13-2015, 11:47 PM Go to last post

  8. Getting Distances and DriveTimes

    Started by Kyle123‎, 01-09-2012 06:30 PM
    • 26
    • 147,871
    msexcelguy
    06-15-2018, 02:45 PM Go to last post

  9. [SOLVED] Calculating Hours Worked

    Started by fzyrdhatitude‎,  
    • 24
    • 42,742
    erwan
    03-19-2007, 02:46 AM Go to last post

  10. [SOLVED] Finding The Nth Greatest Value Meeting Criteria

    Started by Clara‎,  
    1 Attachment(s)
    • 23
    • 3,873
    Alan
    10-07-2005, 02:08 AM Go to last post

  11. Strange Attractor Gallery: An Exploration into circular references

    Started by Gregor y‎, 11-20-2015 06:25 PM
    35 Attachment(s)
    • 22
    • 11,996
    IonutC
    12-20-2016, 03:11 PM Go to last post

  12. One Sample Kolmogorov-Smirnov in Excel

    Started by gerardoissa‎, 09-20-2011 03:58 PM
    kolmogorov, kolmogorov smirnov, smirnov, statistical, statistics 3 Attachment(s)
    • 22
    • 44,254
    wigwig
    07-16-2013, 03:17 AM Go to last post

  13. Thumbs up [SOLVED] Convert a Numeric value to Words Without Vba

    Started by HaroonSid‎, 06-01-2014 03:24 AM
    2 Attachment(s)
    • 22
    • 45,726
    AliGW
    03-02-2022, 03:07 AM Go to last post

  14. Handy One Liners

    Started by Gregor y‎, 09-11-2012 02:49 PM
    1 Attachment(s)
    • 21
    • 4,412
    FDibbins
    10-30-2023, 11:57 PM Go to last post

  15. Adding comments to formulas

    Started by Tony Valko‎, 02-28-2014 10:16 PM
    • 20
    • 2,272
    icestationzbra
    03-10-2014, 05:07 PM Go to last post

  16. Data Validation when the list is on a different sheet

    Started by alansidman‎, 02-14-2014 07:44 PM
    1 Attachment(s)
    • 19
    • 1,882
    TMS
    02-18-2014, 08:01 PM Go to last post

  17. Finding the First Login and Last Logout Times of Employees

    Started by ExcelTip‎, 08-23-2005 12:29 PM
    4 Attachment(s)
    • 19
    • 16,029
    Florence27
    02-17-2018, 01:47 AM Go to last post

  18. AutoCorrect to generate frequently used formula

    Started by MrSpice‎, 02-26-2020 10:20 PM
    • 18
    • 1,825
    FlameRetired
    03-08-2020, 04:59 PM Go to last post

  19. VBA educational material

    Started by vba_php‎, 11-10-2020 02:48 PM
    5 Attachment(s)
    • 18
    • 4,145
    6StringJazzer
    10-22-2022, 10:16 AM Go to last post

  20. Identifying Numeric Values within a Range Formatted as Text

    Started by spchoube‎,  
    • 16
    • 4,190
    oldchippy
    01-17-2007, 11:59 AM Go to last post

  21. How to make your dashboard look natural

    Started by sovietchild‎, 07-15-2018 04:05 AM
    5 Attachment(s)
    • 15
    • 23,682
    sergey123
    02-13-2020, 12:06 PM Go to last post

  22. Nesting OR & AND Functions to Meet Multiple Criteria

    Started by Rhea‎,  
    • 14
    • 10,693
    emai
    05-23-2007, 10:39 PM Go to last post

  23. Embed YouTube video into an Excel spreadsheet

    Started by excelblogger‎, 07-30-2012 01:12 PM
    4 Attachment(s)
    • 14
    • 9,388
    abousetta
    09-06-2012, 03:41 PM Go to last post

  24. Creating a self updating Data Validation List

    Started by TMS‎, 09-10-2012 04:52 PM
    2 Attachment(s)
    • 14
    • 2,861
    TMS
    11-01-2012, 10:02 AM Go to last post

  25. Moved: Max Occurrences of text within a date range....

    Started by Vikas_Gautam‎, 08-20-2014 12:28 AM
    •  
    •  

  26. Retrieving the Value of the First Non-Blank Cell in a List

    Started by leveyc‎,  
    4 Attachment(s)
    • 14
    • 22,048
    oldchippy
    02-09-2007, 05:05 PM Go to last post

  27. Global vs Public

    Started by kadeo‎, 07-22-2015 05:10 AM
    • 13
    • 5,533
    xladept
    07-24-2015, 11:39 PM Go to last post

  28. COVID live update

    Started by KOKOSEK‎, 03-23-2020 12:05 PM
    3 Attachment(s)
    • 13
    • 3,446
    kennystone
    09-23-2020, 03:07 AM Go to last post

  29. Reversing Strings Based On Specific Characters.

    Started by Mike‎,  
    • 13
    • 2,064
    lradon
    01-18-2007, 02:44 PM Go to last post

  30. Colon (:) is an OPERATOR

    Started by hrlngrv‎, 01-25-2021 10:05 PM
    3 Attachment(s)
    • 13
    • 2,722
    hrlngrv
    04-05-2021, 10:55 PM Go to last post

  31. Webscraping worksheet functions part 1

    Started by cyiangou‎, 08-16-2015 11:46 PM
    2 Attachment(s)
    • 13
    • 1,467
    Kyle123
    08-17-2015, 11:33 AM Go to last post

  32. Lookup a Value and Return Multiple Results

    Started by tigeravatar‎, 08-15-2013 08:59 PM
    criteria, how to, lookup, mutliple results, tutorial 1 Attachment(s)
    • 13
    • 16,015
    Tony Valko
    04-08-2016, 04:44 PM Go to last post

  33. TIP Don't merge if you don't have to.

    Started by brynbaker‎, 10-23-2012 06:32 AM
    1 Attachment(s)
    • 13
    • 3,215
    TMS
    11-03-2012, 06:17 PM Go to last post

  34. MaxIf without using an array formula

    Started by tigeravatar‎, 03-02-2012 07:29 PM
    2 Attachment(s)
    • 13
    • 39,457
    JeteMc
    11-08-2019, 08:52 PM Go to last post

  35. Finding the frequency of a string in other string(s)

    Started by JBeaucaire‎, 12-08-2009 01:48 AM
    • 13
    • 4,158
    pike
    01-05-2010, 05:57 AM Go to last post

  36. Tips on How To Get Quick & Good Answers

    Started by benishiryo‎, 07-17-2013 01:46 AM
    4 Attachment(s)
    • 13
    • 4,813
    arlu1201
    07-22-2013, 06:51 AM Go to last post

  37. Post Countifs to be working the same as sumifs function

    Started by saif Khalid‎, 03-29-2021 02:30 AM
    • 12
    • 2,449
    saif Khalid
    04-06-2021, 04:40 AM Go to last post

  38. [SOLVED] Simple macros to send Whatsapp messages from a Excel sheet

    Started by JuanAmor‎, 11-12-2020 12:06 PM
    whatsapp 1 Attachment(s)
    • 12
    • 16,672
    AliGW
    02-28-2022, 09:16 AM Go to last post

  39. Another Freebie Shape Map of the UK

    Started by squiggler47‎, 12-17-2010 06:23 AM
    4 Attachment(s)
    • 12
    • 15,995
    AndyLitch
    12-05-2013, 02:13 PM Go to last post

  40. List worksheet names using a formula

    Started by Tony Valko‎, 06-10-2013 11:03 AM
    • 12
    • 45,607
    FDibbins
    06-13-2019, 11:19 PM Go to last post

  41. mixing Excel with code editors (IDEs)

    Started by vba_php‎, 08-08-2020 05:50 AM
    3 Attachment(s)
    • 12
    • 2,235
    vba_php
    08-20-2020, 10:13 AM Go to last post

  42. Question How to solve an excel problem?

    Started by FDibbins‎, 03-06-2014 08:15 PM
    • 12
    • 1,898
    xladept
    03-07-2014, 12:48 AM Go to last post

  43. [SOLVED] Creating a list of unique values.

    Started by littleIdiot‎,  
    • 11
    • 83,421
    Alan
    08-28-2005, 05:23 PM Go to last post

  44. Freestyle

    Started by KOKOSEK‎, 06-11-2019 07:56 AM
    • 11
    • 1,497
    KOKOSEK
    06-11-2019, 11:58 AM Go to last post

  45. Formula indicating duplicate values in a range

    Started by Victoria‎,  
    • 11
    • 2,838
    oldchippy
    02-09-2007, 06:53 PM Go to last post

  46. Excel VBA Interception and Implicit Intersection and VLookUp

    Started by Doc.AElstein‎, 02-03-2017 06:58 PM
    2 Attachment(s)
    • 11
    • 12,517
    Doc.AElstein
    03-14-2017, 08:42 PM Go to last post

  47. VBA Range.Insert Method ( Excel OOP Syntax Error )

    Started by JackSheet_1‎, 04-24-2016 09:03 PM
    • 11
    • 2,451
    JackSheet_1
    04-25-2016, 10:38 AM Go to last post

  48. VBA Column Letter from Column Number. Explained.

    Started by Doc.AElstein‎, 10-12-2015 08:01 PM
    • 11
    • 8,239
    Doc.AElstein
    10-25-2015, 06:07 PM Go to last post

  49. How to Know Leap Year?

    Started by IMA_Saihat‎, 04-05-2015 10:44 AM
    2 Attachment(s)
    • 11
    • 2,109
    joeu2004
    04-05-2015, 03:17 PM Go to last post

  50. Thumbs up Amazing Use of COUNTIFS ...

    Started by Vikas_Gautam‎, 08-12-2014 10:44 PM
    countifs, speed up array 2 Attachment(s)
    • 11
    • 1,437
    sktneer
    08-14-2014, 02:33 AM Go to last post
+ Post New Thread
Page 1 of 24 1 ...

Forum Information and Options

Users Browsing this Forum

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