+ Post New Thread
Page 1 of 22 1 2 3 11 ... LastLast
Threads 1 to 50 of 1068

Forum: Tips and Tutorials

Sub Forums: Books: Financial 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: 8
    • Posts: 28

    Last Post:

  3. Excel Tips

    Forum Actions:

    Forum Statistics:

    • Threads: 71
    • Posts: 342

    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)
    • 173
    • 72,955
    Teakole
    11-11-2019, 07:00 AM 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
    5 Attachment(s)
    • 24
    • 19,290
    FDibbins
    06-25-2019, 11:54 PM Go to last post

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

    Started by alansidman‎, 06-09-2019 05:00 PM
    • 1
    • 2,289
    TMS
    06-09-2019, 05:18 PM 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)
    • 7
    • 62,668
    shg
    12-01-2018, 01:19 PM Go to last post

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

    Started by dflak‎, 03-26-2018 03:25 PM
    1 Attachment(s)
    • 5
    • 4,167
    FDibbins
    07-13-2018, 10:22 PM Go to last post

  6. 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)
    • 21
    • 8,776
    sandy666
    06-01-2018, 01:39 PM Go to last post

  7. 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
    • 11,149
    FDibbins
    01-01-2018, 04:01 AM Go to last post

  8. Sticky Thread Sticky: Restoring a Corrupted File

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

  1. mixing Excel with code editors (IDEs)

    Started by vba_php‎, Today 05:50 AM
    • 2
    • 69
    vba_php
    Today, 08:01 PM Go to last post

  2. Solver setup for list cutting

    Started by Alf‎, 03-10-2020 03:50 PM
    2 Attachment(s)
    • 7
    • 589
    AliGW
    08-06-2020, 05:24 AM Go to last post

  3. Excel simulation of a Stack, Queue and Tree data structure

    Started by ahafeel‎, 08-02-2020 02:10 PM
    2 Attachment(s)
    • 0
    • 234
    ahafeel
    08-02-2020, 02:10 PM Go to last post

  4. Create Duplicate Rows of Data Quickly with Power Query

    Started by alansidman‎, 07-29-2020 08:10 AM
    • 1
    • 151
    AliGW
    07-29-2020, 08:14 AM Go to last post

  5. Moved: How to Add a "Like" Feature in Excel

    Started by civakalyan‎, 07-22-2020 01:18 PM
    •  
    •  

  6. Thumbs up Convert a Numeric value to Words Without Vba

    Started by HaroonSid‎, 06-01-2014 03:24 AM
    2 Attachment(s)
    • 20
    • 19,480
    ashakantasharma
    07-22-2020, 01:12 PM Go to last post

  7. Make a sub-list from a main list based on wildcards

    Started by dflak‎, 07-09-2020 02:43 PM
    • 1
    • 519
    LJMetzger
    07-17-2020, 12:07 PM Go to last post

  8. VBA code to clear the Windows clipboard (better than application.cutcopymode = false)

    Started by Cells.Select‎, 07-08-2020 07:29 PM
    • 2
    • 166
    alansidman
    07-09-2020, 03:32 AM Go to last post

  9. COVID live update

    Started by KOKOSEK‎, 03-23-2020 12:05 PM
    3 Attachment(s)
    • 12
    • 873
    DannyPhilips
    07-09-2020, 02:20 AM Go to last post

  10. VBA solution to validate email address syntax

    Started by 6StringJazzer‎, 06-22-2020 06:28 PM
    1 Attachment(s)
    • 2
    • 872
    6StringJazzer
    06-23-2020, 08:17 AM Go to last post

  11. How to set up a spreadsheet to use the Newton-Raphson method to find roots

    Started by MrShorty‎, 10-30-2015 01:15 PM
    9 Attachment(s)
    • 9
    • 24,038
    MrShorty
    06-10-2020, 11:35 AM Go to last post

  12. [SOLVED] Write Alphabets by auto by drag and drop

    Started by sandeepmaurya‎, 06-08-2020 03:17 AM
    • 3
    • 201
    Vraag en antwoord
    06-08-2020, 02:46 PM Go to last post

  13. VBA to Export and Re-Import Conditional Formatting Rules

    Started by Junior1‎, 11-19-2018 04:38 PM
    conditional formatting, macro, multiple workbooks, vba 2 Attachment(s)
    • 6
    • 2,310
    Balbox
    05-31-2020, 09:57 AM Go to last post

  14. How to Put Text Into the Measures in a Pivot Table

    Started by alansidman‎, 05-15-2020 05:07 PM
    • 0
    • 844
    alansidman
    05-15-2020, 05:07 PM Go to last post

  15. [SOLVED] How to copy and paste formulas from one workbook to another

    Started by Giulio Severini‎, 04-18-2020 10:07 AM
    • 0
    • 697
    Giulio Severini
    04-18-2020, 10:07 AM Go to last post

  16. Filterable listbox

    Started by Kyle123‎, 12-14-2018 11:00 AM
    1 Attachment(s)
    • 1
    • 1,167
    szektor
    03-27-2020, 09:22 AM Go to last post

  17. UK Companies House API

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

  18. Office 365-Unique Formula

    Started by davesexcel‎, 03-21-2020 08:49 AM
    1 Attachment(s)
    • 0
    • 188
    davesexcel
    03-21-2020, 08:49 AM Go to last post

  19. Mailing a Selected Range in the Body and Attachments From Excel

    Started by dflak‎, 03-13-2020 03:53 PM
    1 Attachment(s)
    • 0
    • 369
    dflak
    03-13-2020, 03:53 PM Go to last post

  20. How to break down an amount of money to banknotes and coins

    Started by Giulio Severini‎, 03-10-2020 08:28 AM
    1 Attachment(s)
    • 4
    • 353
    Giulio Severini
    03-11-2020, 03:03 AM Go to last post

  21. Solver_setuo

    Started by Alf‎, 03-09-2020 04:25 PM
    1 Attachment(s)
    • 0
    • 759
    Alf
    03-09-2020, 04:25 PM Go to last post

  22. AutoCorrect to generate frequently used formula

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

  23. Sheldon TV why is 73 a cool number

    Started by MarvinP‎, 03-04-2020 05:40 PM
    3 Attachment(s)
    • 2
    • 307
    MarvinP
    03-04-2020, 11:58 PM Go to last post

  24. Remove Front Apostrophe (Text & Numbers)

    Started by CobraLAD‎, 05-04-2018 03:21 PM
    • 2
    • 621
    CobraLAD
    03-01-2020, 01:01 PM Go to last post

  25. Determining Whether a Worked Shift Was Morning, Afternoon or Night

    Started by ExcelTip‎, 08-23-2005 12:35 PM
    • 6
    • 6,050
    AliGW
    02-26-2020, 08:49 AM Go to last post

  26. Moved: recognize and split the hours worked into day and night as some shifts over lap

    Started by Melissae‎, 02-24-2020 09:58 AM
    •  
    •  

  27. How to make your dashboard look natural

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

  28. Display chart on userform

    Started by KOKOSEK‎, 01-29-2020 07:32 AM
    3 Attachment(s)
    • 0
    • 291
    KOKOSEK
    01-29-2020, 07:32 AM Go to last post

  29. Reducing Excel Macro-Enabled File Size - Hack discovered

    Started by superlative‎, 01-10-2020 11:45 AM
    • 4
    • 384
    scottiex
    01-16-2020, 11:40 PM Go to last post

  30. Excel Hide - Unhide Columns With Userform

    Started by kadr‎, 01-10-2020 07:02 PM
    excel, vba & excel 2 Attachment(s)
    • 0
    • 451
    kadr
    01-10-2020, 07:02 PM Go to last post

  31. Time Card System

    Started by dflak‎, 12-30-2019 12:55 PM
    1 Attachment(s)
    • 3
    • 563
    MydnyteSyn
    01-06-2020, 11:01 AM Go to last post

  32. Conversion of dates from Hijri Calendar (1317-1473) to Gregorian calendar (1900-2050)

    Started by IMA_Saihat‎, 11-02-2015 08:15 AM
    1 Attachment(s)
    • 5
    • 5,192
    Vindruen
    01-02-2020, 07:45 AM Go to last post

  33. Automatically send a email when date is matching

    Started by KOKOSEK‎, 01-02-2020 05:41 AM
    1 Attachment(s)
    • 0
    • 368
    KOKOSEK
    01-02-2020, 05:41 AM Go to last post

  34. [SOLVED] Error handling with Call Stack and Execution Trace

    Started by Warbe‎, 09-27-2019 06:41 PM
    error handling, excel, execution tracing, time tracking 6 Attachment(s)
    • 5
    • 770
    Andy Pope
    01-01-2020, 06:36 AM Go to last post

  35. [SOLVED] Existence checks collected in one module

    Started by Warbe‎, 08-26-2019 01:05 PM
    check, excel, existence, vba
    • 6
    • 925
    Warbe
    12-28-2019, 03:03 PM Go to last post

  36. Excel Sheet Management With Userform

    Started by kadr‎, 12-20-2019 02:01 PM
    combobox, excel userform, excel userforms, sheet delete 2 Attachment(s)
    • 3
    • 2,850
    Bob Phillips
    12-21-2019, 01:58 PM Go to last post

  37. Yearly Calendar Project

    Started by kadr‎, 12-19-2019 03:21 AM
    excel & vba, excel 2020 calendar, excel agenda template, excel yearly calendar 1 Attachment(s)
    • 0
    • 324
    kadr
    12-19-2019, 03:21 AM Go to last post

  38. Data Manipulation Examples

    Started by davesexcel‎, 01-02-2010 12:14 PM
    value between dates 5 Attachment(s)
    • 4
    • 7,905
    davesexcel
    12-15-2019, 09:30 AM Go to last post

  39. VBA Code for finding all external links in an Excel workbook

    Started by 6StringJazzer‎, 09-09-2015 11:07 AM
    • 6
    • 1,621
    ImranBhatti
    12-08-2019, 12:12 AM Go to last post

  40. SpinButton with Alphabet Letter

    Started by CobraLAD‎, 12-01-2019 08:26 AM
    1 Attachment(s)
    • 0
    • 434
    CobraLAD
    12-01-2019, 08:26 AM Go to last post

  41. MaxIf without using an array formula

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

  42. macro that generates random selection set from table

    Started by foxtrotter‎, 10-30-2019 05:01 PM
    • 0
    • 506
    foxtrotter
    10-30-2019, 05:01 PM Go to last post

  43. Help with Programming Assignment Help

    Started by MajaKazazic‎, 10-21-2019 02:18 AM
    c++, java, python programming
    • 0
    • 492
    MajaKazazic
    10-21-2019, 02:18 AM Go to last post

  44. [SOLVED] Help: HTML posting error but no HTML included

    Started by whahnelt‎, 10-17-2019 02:04 PM
    • 2
    • 307
    whahnelt
    10-17-2019, 02:37 PM Go to last post

  45. Excel function: nXLookup

    Started by Gregor y‎, 10-17-2014 09:34 PM
    hlookup, match, vlookup
    • 3
    • 1,914
    goloria
    10-12-2019, 06:52 PM Go to last post

  46. How to mark thread as SOLVED

    Started by JDLuke‎, 09-09-2019 05:25 AM
    2 Attachment(s)
    • 3
    • 601
    PaulM100
    09-09-2019, 07:14 AM Go to last post

  47. Conversion Functions (DecToBin, HexToDec, etc.) That Can Take Very Large Arguments

    Started by Rick Rothstein‎, 08-22-2019 06:54 PM
    • 0
    • 403
    Rick Rothstein
    08-22-2019, 06:54 PM Go to last post

  48. Synchronize module between Workbooks

    Started by Warbe‎, 08-17-2019 04:22 PM
    code module, synchronization, transfer, workbook
    • 1
    • 398
    quick87
    08-21-2019, 04:04 AM Go to last post

  49. Handy: Strip out the contents of the rightmost parenthesis

    Started by Speshul‎, 02-27-2017 02:54 PM
    • 4
    • 706
    Rick Rothstein
    08-19-2019, 10:52 PM Go to last post

  50. How to quote a person that quote someone else?

    Started by testbobtt‎, 08-18-2019 10:45 PM
    • 8
    • 407
    FDibbins
    08-19-2019, 09:36 PM Go to last post
+ Post New Thread
Page 1 of 22 1 2 3 11 ... LastLast

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