+ 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: FAQ - Commercial Services

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

  2. Sticky Thread Sticky: Restoring a Corrupted File

    Started by mudraker‎, 03-12-2007 06:33 PM
    • 3
    • 41,110
    Dandy
    06-21-2012, 12:55 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
    • 3
    • 8,328
    --Plato--
    05-24-2022, 03:11 AM Go to last post

  4. 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,103
    johnnyL
    11-13-2023, 06:36 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)
    • 7
    • 10,896
    alansidman
    05-22-2021, 09:51 AM Go to last post

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

  7. 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,693
    6StringJazzer
    03-13-2023, 06:35 PM Go to last post

  8. 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,977
    sandy666
    12-15-2022, 05:14 AM Go to last post

  9. 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,869
    AliGW
    01-07-2024, 01:37 PM Go to last post

  10. 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,646
    LionelNZ
    04-13-2024, 07:16 PM Go to last post

  1. Calculating a Required Date According to Two Criteria

    Started by ExcelTip‎, 08-23-2005 11:49 AM
    • 0
    • 1,378
    ExcelTip
    08-23-2005, 11:49 AM Go to last post

  2. Rearranging a String in Alphabetic Order

    Started by ExcelTip‎, 08-23-2005 04:07 AM
    • 0
    • 1,442
    ExcelTip
    08-23-2005, 04:07 AM Go to last post

  3. Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up

    Started by ExcelTip‎, 08-23-2005 04:21 AM
    • 0
    • 1,258
    ExcelTip
    08-23-2005, 04:21 AM Go to last post

  4. Determining Long Distance Phone Calls, Based on the Number Dialed

    Started by ExcelTip‎, 08-23-2005 04:06 AM
    • 0
    • 1,252
    ExcelTip
    08-23-2005, 04:06 AM Go to last post

  5. Avoiding Negative Values when Calculating the Number of Days between Two Dates

    Started by ExcelTip‎, 08-23-2005 11:52 AM
    • 0
    • 1,419
    ExcelTip
    08-23-2005, 11:52 AM Go to last post

  6. Avoiding False Results when Counting Dates Matching Specified Criteria

    Started by ExcelTip‎, 08-23-2005 11:53 AM
    • 0
    • 1,210
    ExcelTip
    08-23-2005, 11:53 AM Go to last post

  7. Finding the Number of Days in a Given Month

    Started by ExcelTip‎, 08-23-2005 11:55 AM
    • 0
    • 1,135
    ExcelTip
    08-23-2005, 11:55 AM Go to last post

  8. Finding the Serial Number of the Last Day of the Month

    Started by ExcelTip‎, 08-23-2005 11:56 AM
    • 0
    • 1,156
    ExcelTip
    08-23-2005, 11:56 AM Go to last post

  9. Adding a Specified Number of Months to a Date

    Started by ExcelTip‎, 08-23-2005 11:57 AM
    • 0
    • 1,097
    ExcelTip
    08-23-2005, 11:57 AM Go to last post

  10. Converting a Date into a String, Indicating the Quarter Number and Year

    Started by ExcelTip‎, 08-23-2005 11:59 AM
    • 0
    • 961
    ExcelTip
    08-23-2005, 11:59 AM Go to last post

  11. Determining Which Quarter a Specified Date Corresponds With

    Started by ExcelTip‎, 08-23-2005 12:00 PM
    • 0
    • 1,198
    ExcelTip
    08-23-2005, 12:00 PM Go to last post

  12. Converting Older Dates to the Current Year

    Started by ExcelTip‎, 08-23-2005 12:00 PM
    • 0
    • 917
    ExcelTip
    08-23-2005, 12:00 PM Go to last post

  13. Entering Times Quickly

    Started by ExcelTip‎, 08-23-2005 12:03 PM
    • 0
    • 1,148
    ExcelTip
    08-23-2005, 12:03 PM Go to last post

  14. Adding a Number to a Formatted Time Value

    Started by ExcelTip‎, 08-23-2005 12:06 PM
    • 0
    • 1,134
    ExcelTip
    08-23-2005, 12:06 PM Go to last post

  15. Calculating Military Time Intervals

    Started by ExcelTip‎, 08-23-2005 12:11 PM
    • 0
    • 1,678
    ExcelTip
    08-23-2005, 12:11 PM Go to last post

  16. Converting Time Values from One Time Zone to Another

    Started by ExcelTip‎, 08-23-2005 12:12 PM
    • 0
    • 1,654
    ExcelTip
    08-23-2005, 12:12 PM Go to last post

  17. Creating a World Time Converter

    Started by ExcelTip‎, 08-23-2005 12:12 PM
    • 0
    • 5,159
    ExcelTip
    08-23-2005, 12:12 PM Go to last post

  18. Solver_setuo

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

  19. A Bit of XLM for SHEETS Limitations

    Started by hrlngrv‎, 12-24-2020 02:37 AM
    • 0
    • 797
    hrlngrv
    12-24-2020, 02:37 AM Go to last post

  20. CHOOSE vs IFS or SWITCH

    Started by hrlngrv‎, 01-12-2021 05:22 AM
    • 0
    • 1,075
    hrlngrv
    01-12-2021, 05:22 AM Go to last post

  21. Restricting Cell Entries to Text Only

    Started by ExcelTip‎, 08-23-2005 03:26 AM
    • 0
    • 1,645
    ExcelTip
    08-23-2005, 03:26 AM Go to last post

  22. PDF to Excel Data Conversion Software

    Started by ExcelTip‎, 05-10-2006 06:06 AM
    • 0
    • 8,550
    ExcelTip
    05-10-2006, 06:06 AM Go to last post

  23. Seperating Website Name or URL from Text

    Started by ExcelTip‎, 05-08-2006 03:24 AM
    • 0
    • 1,070
    ExcelTip
    05-08-2006, 03:24 AM Go to last post

  24. Let Excel talk/Speak Programmatically

    Started by ExcelTip‎, 01-21-2005 07:45 AM
    • 0
    • 1,831
    ExcelTip
    01-21-2005, 07:45 AM Go to last post

  25. Calculating the average of every Nth value.

    Started by ExcelTip‎, 05-11-2005 08:28 AM
    • 0
    • 1,791
    ExcelTip
    05-11-2005, 08:28 AM Go to last post

  26. Retrieving a value from a range according to position

    Started by ExcelTip‎, 05-31-2005 09:20 AM
    • 0
    • 1,566
    ExcelTip
    05-31-2005, 09:20 AM Go to last post

  27. IF-AND-OR statements.

    Started by ExcelTip‎, 05-31-2005 09:23 AM
    • 0
    • 1,669
    ExcelTip
    05-31-2005, 09:23 AM Go to last post

  28. Case sensitive lookups.

    Started by ExcelTip‎, 06-03-2005 12:25 PM
    • 0
    • 1,910
    ExcelTip
    06-03-2005, 12:25 PM Go to last post

  29. Counting values meeting multiple criteria

    Started by ExcelTip‎, 06-12-2005 03:06 AM
    • 0
    • 1,662
    ExcelTip
    06-12-2005, 03:06 AM Go to last post

  30. Checking The Frequency of Multiple Values In A Range

    Started by ExcelTip‎, 07-04-2005 02:33 AM
    • 0
    • 1,816
    ExcelTip
    07-04-2005, 02:33 AM Go to last post

  31. Calculating Retail Price And Sales Tax Using The Round Function

    Started by ExcelTip‎, 07-10-2005 01:25 AM
    • 0
    • 5,123
    ExcelTip
    07-10-2005, 01:25 AM Go to last post

  32. Separtaing A String Into Substrings.

    Started by ExcelTip‎, 07-10-2005 01:27 AM
    • 0
    • 1,741
    ExcelTip
    07-10-2005, 01:27 AM Go to last post

  33. Avoiding Errors When Subtracting Times

    Started by ExcelTip‎, 07-24-2005 01:48 AM
    • 0
    • 2,260
    ExcelTip
    07-24-2005, 01:48 AM Go to last post

  34. Calculating The Week Number Corresponding With A Specific Date

    Started by ExcelTip‎, 07-24-2005 01:49 AM
    • 0
    • 1,914
    ExcelTip
    07-24-2005, 01:49 AM Go to last post

  35. Retrieving the Last Value in a Dynamic List

    Started by ExcelTip‎, 08-25-2005 02:33 AM
    • 0
    • 3,358
    ExcelTip
    08-25-2005, 02:33 AM Go to last post

  36. Automatic Report formatting using option buttons

    Started by ExcelTip‎, 05-27-2006 01:07 AM
    • 0
    • 991
    ExcelTip
    05-27-2006, 01:07 AM Go to last post

  37. Restricting the Number of Characters Entered into a Cell

    Started by ExcelTip‎, 08-23-2005 03:27 AM
    • 0
    • 1,593
    ExcelTip
    08-23-2005, 03:27 AM Go to last post

  38. Combining Text and a Formatted Date into a Single Entity

    Started by ExcelTip‎, 08-23-2005 03:33 AM
    • 0
    • 1,467
    ExcelTip
    08-23-2005, 03:33 AM Go to last post

  39. Combining Text and Numerically Calculated Results into One Output String

    Started by ExcelTip‎, 08-23-2005 03:36 AM
    • 0
    • 1,551
    ExcelTip
    08-23-2005, 03:36 AM Go to last post

  40. Formulas Erroneously Appearing as Text

    Started by ExcelTip‎, 08-23-2005 03:37 AM
    • 0
    • 1,463
    ExcelTip
    08-23-2005, 03:37 AM Go to last post

  41. Retrieving the Row Number that Corresponds with a Matched Value in a Look Up

    Started by ExcelTip‎, 08-23-2005 04:21 AM
    • 0
    • 1,355
    ExcelTip
    08-23-2005, 04:21 AM Go to last post

  42. Checking Whether Cells in a Range are Blank, and Counting the Blank Cells

    Started by ExcelTip‎, 08-23-2005 03:43 AM
    • 0
    • 1,799
    ExcelTip
    08-23-2005, 03:43 AM Go to last post

  43. Removing Hidden Apostrophes from Imported Numbers

    Started by ExcelTip‎, 08-23-2005 03:48 AM
    • 0
    • 2,024
    ExcelTip
    08-23-2005, 03:48 AM Go to last post

  44. Converting Numbers with Trailing Minus Signs to Normal Negative Numbers

    Started by ExcelTip‎, 08-23-2005 03:59 AM
    • 0
    • 2,253
    ExcelTip
    08-23-2005, 03:59 AM Go to last post

  45. Replacing Substrings with Numbers from Adjacent Cells

    Started by ExcelTip‎, 08-23-2005 04:00 AM
    • 0
    • 1,132
    ExcelTip
    08-23-2005, 04:00 AM Go to last post

  46. Performing Numeric Operations on Substrings

    Started by ExcelTip‎, 08-23-2005 04:01 AM
    • 0
    • 1,190
    ExcelTip
    08-23-2005, 04:01 AM Go to last post

  47. Searching a String for a Matching Word from another String

    Started by ExcelTip‎, 08-23-2005 04:01 AM
    • 0
    • 1,333
    ExcelTip
    08-23-2005, 04:01 AM Go to last post

  48. Find the Alphabetically Lowest Letter in a List

    Started by ExcelTip‎, 08-23-2005 04:02 AM
    • 0
    • 1,956
    ExcelTip
    08-23-2005, 04:02 AM Go to last post

  49. Finding the Relative Position of Numbers within a String

    Started by ExcelTip‎, 08-23-2005 04:05 AM
    • 0
    • 1,637
    ExcelTip
    08-23-2005, 04:05 AM Go to last post

  50. Searching a String for a Specific Substring

    Started by ExcelTip‎, 08-23-2005 04:05 AM
    • 0
    • 2,798
    ExcelTip
    08-23-2005, 04:05 AM Go to last post
+ Post New Thread
Page 1 of 24 1 ...

Forum Information and Options

Users Browsing this Forum

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