+ 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: 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

  2. Sticky Thread Sticky: FAQ - Commercial Services

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

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

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

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

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

  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)
    • 23
    • 21,958
    sandy666
    12-15-2022, 05:14 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,683
    6StringJazzer
    03-13-2023, 06:35 PM Go to last post

  8. 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,102
    johnnyL
    11-13-2023, 06:36 PM 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,854
    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,599
    LionelNZ
    04-13-2024, 07:16 PM Go to last post

  1. [SOLVED] Consolidate and Merge Data on a Separate Sheet

    Started by ‎, 07-23-2014 04:08 PM
    • 0
    • 858
    01-01-1970, 12:00 AM Go to last post

  2. Let Excel talk/Speak Programmatically

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

  3. [SOLVED] Separating strings into substrings.

    Started by ‎,  
    • 1
    • 10,986
    ExcelTip
    05-11-2005, 08:17 AM Go to last post

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

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

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

  7. Case sensitive lookups.

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

  8. Counting values meeting multiple criteria

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

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

  10. Counting The Number of Players According To Their Score In A Particular Quarter

    Started by ExcelTip‎, 07-04-2005 02:40 AM
    • 1
    • 1,708
    Dennis Taylor
    07-07-2005, 04:00 PM Go to last post

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

  12. Separtaing A String Into Substrings.

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

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

  14. Calculating The Week Number Corresponding With A Specific Date

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

  15. [SOLVED] Calculating Absolute Difference Between Two Time Values

    Started by markxus‎,  
    • 3
    • 6,158
    ExcelTip
    08-10-2005, 01:43 AM Go to last post

  16. Looking Up A Value In A Name Range

    Started by ExcelTip‎, 07-24-2005 01:50 AM
    • 1
    • 1,715
    canesbr
    08-15-2005, 10:07 AM Go to last post

  17. Restricting Cell Entries to Text Only

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

  18. Restricting the Number of Characters Entered into a Cell

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

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

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

  20. [SOLVED] Combining Numbers that Have Leading Zeros

    Started by Ravee Mathi Sundar‎,  
    • 1
    • 1,904
    ExcelTip
    08-23-2005, 03:34 AM Go to last post

  21. [SOLVED] Combining the Contents of Every N Number of Cells into One Value

    Started by Rajesh Aggarwal‎,  
    • 1
    • 1,712
    ExcelTip
    08-23-2005, 03:35 AM Go to last post

  22. Encoding a Sequence of Letters

    Started by SRINIVASAN‎,  
    • 2
    • 1,712
    ExcelTip
    08-23-2005, 03:35 AM Go to last post

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

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

  24. Formulas Erroneously Appearing as Text

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

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

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

  26. Removing Hidden Apostrophes from Imported Numbers

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

  27. Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters

    Started by VAIBHAV‎,  
    • 2
    • 2,257
    ExcelTip
    08-23-2005, 03:49 AM Go to last post

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

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

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

  30. Performing Numeric Operations on Substrings

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

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

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

  32. Find the Alphabetically Lowest Letter in a List

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

  33. Finding the Relative Position of Numbers within a String

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

  34. Searching a String for a Specific Substring

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

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

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

  37. Retrieving the Cell Address of the Largest Value in a Range

    Started by nishantkhimesra‎,  
    • 1
    • 1,367
    ExcelTip
    08-23-2005, 04:20 AM Go to last post

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

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

  40. [SOLVED] Entering Dates Quickly

    Started by shawna‎,  
    • 5
    • 1,725
    ExcelTip
    08-23-2005, 11:39 AM Go to last post

  41. Calculating a Date Based on Year, Week Number and Day of the Week

    Started by amy‎,  
    • 1
    • 2,051
    ExcelTip
    08-23-2005, 11:42 AM Go to last post

  42. Calculating a Required Date According to Two Criteria

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

  43. [SOLVED] Eliminating Negative Values from Date Subtractions

    Started by Mhz‎,  
    • 1
    • 1,271
    ExcelTip
    08-23-2005, 11:51 AM Go to last post

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

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

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

  46. Calculating the Week Number Corresponding with a Specific Date

    Started by Mindy‎,  
    • 2
    • 1,316
    ExcelTip
    08-23-2005, 11:54 AM Go to last post

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

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

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

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

  50. 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
+ 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