+ Post New Thread
Page 3 of 24 FirstFirst 3 ...
Threads 101 to 150 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,108
    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,183
    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,358
    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,887
    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,323
    --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,905
    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,670
    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,099
    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,840
    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,453
    LionelNZ
    04-13-2024, 07:16 PM Go to last post

  1. Finding Every Third Number and Returning the Largest of Them

    Started by ExcelTip‎, 08-25-2005 02:56 AM
    • 0
    • 1,000
    ExcelTip
    08-25-2005, 02:56 AM Go to last post

  2. Retrieving the Nth Value in a Row / Column

    Started by ExcelTip‎, 08-25-2005 02:57 AM
    • 0
    • 1,372
    ExcelTip
    08-25-2005, 02:57 AM Go to last post

  3. Retrieving Every Nth Value in a Range

    Started by ExcelTip‎, 08-25-2005 02:58 AM
    • 0
    • 1,240
    ExcelTip
    08-25-2005, 02:58 AM Go to last post

  4. Retrieve the Distance between Any Two Cities from Distance Table

    Started by ExcelTip‎, 08-25-2005 02:58 AM
    • 0
    • 1,326
    ExcelTip
    08-25-2005, 02:58 AM Go to last post

  5. Retrieving Matching Values from Not

    Started by ExcelTip‎, 08-25-2005 02:59 AM
    • 0
    • 4,154
    ExcelTip
    08-25-2005, 02:59 AM Go to last post

  6. Retrieving an Item from a List that Meets Multiple Criteria

    Started by ExcelTip‎, 08-25-2005 02:59 AM
    • 0
    • 1,299
    ExcelTip
    08-25-2005, 02:59 AM Go to last post

  7. Retrieving an Item from a List that Meets Multiple Criteria

    Started by ExcelTip‎, 08-25-2005 03:00 AM
    • 0
    • 1,243
    ExcelTip
    08-25-2005, 03:00 AM Go to last post

  8. Retrieving Sale Price Based on Item and Color Criteria

    Started by ExcelTip‎, 08-25-2005 03:01 AM
    • 0
    • 1,019
    ExcelTip
    08-25-2005, 03:01 AM Go to last post

  9. Retrieving a Price from a List that Matches both Category and Item Criteria

    Started by ExcelTip‎, 08-25-2005 03:01 AM
    • 0
    • 1,250
    ExcelTip
    08-25-2005, 03:01 AM Go to last post

  10. [SOLVED] Retrieving the Entire Row of a Matched Value

    Started by marlea‎,  
    • 1
    • 15,483
    ExcelTip
    08-25-2005, 03:03 AM Go to last post

  11. Returning the Entire Contents of the Row Containing the Highest Math Grade

    Started by ExcelTip‎, 08-25-2005 03:03 AM
    • 0
    • 1,045
    ExcelTip
    08-25-2005, 03:03 AM Go to last post

  12. Retrieving a Price Value by Looking at Two Difference Data Tables

    Started by ExcelTip‎, 08-25-2005 03:04 AM
    • 0
    • 1,021
    ExcelTip
    08-25-2005, 03:04 AM Go to last post

  13. Retrieving the Column Header of the Next Non-Blank Cell in a Row

    Started by ExcelTip‎, 08-25-2005 03:05 AM
    • 0
    • 990
    ExcelTip
    08-25-2005, 03:05 AM Go to last post

  14. Finding the First Value in a Row and Retrieving the Header for That Column

    Started by ExcelTip‎, 08-25-2005 03:05 AM
    • 0
    • 1,018
    ExcelTip
    08-25-2005, 03:05 AM Go to last post

  15. Retrieving the Column Header that Corresponds with a Matched Value

    Started by ExcelTip‎, 08-25-2005 03:06 AM
    • 0
    • 2,150
    ExcelTip
    08-25-2005, 03:06 AM Go to last post

  16. Retrieving the Column Header of the Largest Value in a Row

    Started by ExcelTip‎, 08-25-2005 03:07 AM
    • 0
    • 977
    ExcelTip
    08-25-2005, 03:07 AM Go to last post

  17. Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range

    Started by ExcelTip‎, 08-25-2005 03:08 AM
    • 0
    • 936
    ExcelTip
    08-25-2005, 03:08 AM Go to last post

  18. Checking for the Presence of Specified Values within a Range

    Started by ExcelTip‎, 08-25-2005 03:35 AM
    • 0
    • 1,047
    ExcelTip
    08-25-2005, 03:35 AM Go to last post

  19. Ignoring Blank Cells when Performing Calculations

    Started by ExcelTip‎, 08-25-2005 03:40 AM
    • 0
    • 1,260
    ExcelTip
    08-25-2005, 03:40 AM Go to last post

  20. Avoiding the #VALUE! Error when Adding Cells that May Contain Blanks

    Started by ExcelTip‎, 08-25-2005 03:40 AM
    • 0
    • 576
    ExcelTip
    08-25-2005, 03:40 AM Go to last post

  21. Avoiding #DIV/0! Errors when Dividing by Zero

    Started by ExcelTip‎, 08-25-2005 03:41 AM
    • 0
    • 528
    ExcelTip
    08-25-2005, 03:41 AM Go to last post

  22. Ignoring #DIV/0! Errors when Performing Calculations

    Started by ExcelTip‎, 08-25-2005 03:42 AM
    • 0
    • 1,667
    ExcelTip
    08-25-2005, 03:42 AM Go to last post

  23. [SOLVED] Eliminating Errors Resulting from If Functions with Multiple Conditions

    Started by Stephanie‎,  
    • 1
    • 947
    ExcelTip
    08-25-2005, 03:43 AM Go to last post

  24. Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas

    Started by John‎,  
    • 1
    • 1,034
    ExcelTip
    08-25-2005, 03:43 AM Go to last post

  25. Avoiding Errors when Counting Date Values that Meet Specified Criteria

    Started by ExcelTip‎, 08-25-2005 03:44 AM
    • 0
    • 893
    ExcelTip
    08-25-2005, 03:44 AM Go to last post

  26. Avoiding Errors when Subtracting Times

    Started by ExcelTip‎, 08-25-2005 03:45 AM
    • 0
    • 797
    ExcelTip
    08-25-2005, 03:45 AM Go to last post

  27. Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found

    Started by ExcelTip‎, 08-25-2005 03:46 AM
    • 0
    • 1,021
    ExcelTip
    08-25-2005, 03:46 AM Go to last post

  28. Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors

    Started by ExcelTip‎, 08-25-2005 03:46 AM
    • 0
    • 480
    ExcelTip
    08-25-2005, 03:46 AM Go to last post

  29. Counting the Number of Values Below or Above Average

    Started by ExcelTip‎, 08-25-2005 05:42 AM
    • 0
    • 1,066
    ExcelTip
    08-25-2005, 05:42 AM Go to last post

  30. Counting Values that Appear Only Once in

    Started by ExcelTip‎, 08-25-2005 05:43 AM
    • 0
    • 909
    ExcelTip
    08-25-2005, 05:43 AM Go to last post

  31. Counting the Number of Times a Specified Substring Appears within a Range of Strings

    Started by ExcelTip‎, 08-25-2005 05:44 AM
    • 0
    • 1,264
    ExcelTip
    08-25-2005, 05:44 AM Go to last post

  32. Counting the Number of Cells Containing

    Started by ExcelTip‎, 08-25-2005 05:44 AM
    • 0
    • 961
    ExcelTip
    08-25-2005, 05:44 AM Go to last post

  33. Counting the Number of Cells Containing

    Started by ExcelTip‎, 08-25-2005 05:46 AM
    • 0
    • 979
    ExcelTip
    08-25-2005, 05:46 AM Go to last post

  34. Counting the Number of Times a Substring Appears Within a String

    Started by ExcelTip‎, 08-25-2005 05:48 AM
    • 0
    • 1,421
    ExcelTip
    08-25-2005, 05:48 AM Go to last post

  35. Counting the Number of Strings which Contain Numbers Meeting Criteria

    Started by ExcelTip‎, 08-25-2005 05:49 AM
    • 0
    • 1,098
    ExcelTip
    08-25-2005, 05:49 AM Go to last post

  36. Counting Date Values by Specified Date Criteria

    Started by ExcelTip‎, 08-25-2005 05:49 AM
    • 0
    • 1,135
    ExcelTip
    08-25-2005, 05:49 AM Go to last post

  37. Counting the Number of Dates with Matching Month Criteria

    Started by ExcelTip‎, 08-25-2005 05:50 AM
    • 0
    • 983
    ExcelTip
    08-25-2005, 05:50 AM Go to last post

  38. Counting Time Values in Terms of Hourly Increments

    Started by ExcelTip‎, 08-25-2005 05:51 AM
    • 0
    • 1,027
    ExcelTip
    08-25-2005, 05:51 AM Go to last post

  39. Counting the Number of Values Meeting Criteria, but Only for Every 3rd Cell in a Range

    Started by ExcelTip‎, 08-25-2005 05:52 AM
    • 0
    • 910
    ExcelTip
    08-25-2005, 05:52 AM Go to last post

  40. Counting the Number of Values from Multiple Worksheets that Match Criteria

    Started by ExcelTip‎, 08-25-2005 05:55 AM
    • 0
    • 1,210
    ExcelTip
    08-25-2005, 05:55 AM Go to last post

  41. Counting the Number of Unique Items Sold by Each Salesperson

    Started by ExcelTip‎, 08-25-2005 06:14 AM
    • 0
    • 1,083
    ExcelTip
    08-25-2005, 06:14 AM Go to last post

  42. Using Date & Time Criteria to Count Entries in a Combined Date & Time List

    Started by ExcelTip‎, 08-28-2005 10:35 AM
    • 0
    • 1,074
    ExcelTip
    08-28-2005, 10:35 AM Go to last post

  43. Counting the Number of Times Any of the Numbers in First List Appears within Second List

    Started by ExcelTip‎, 08-28-2005 10:37 AM
    • 0
    • 1,022
    ExcelTip
    08-28-2005, 10:37 AM Go to last post

  44. [SOLVED] Creating Progressively Incremented Counting Criteria

    Started by David J W‎,  
    • 1
    • 1,005
    ExcelTip
    08-28-2005, 10:38 AM Go to last post

  45. Counting the Values that Match Criteria in a Filtered List

    Started by ExcelTip‎, 08-28-2005 10:38 AM
    • 0
    • 1,123
    ExcelTip
    08-28-2005, 10:38 AM Go to last post

  46. Creating a Summary Table of a Student Questionnaire

    Started by ExcelTip‎, 08-28-2005 10:39 AM
    • 0
    • 1,469
    ExcelTip
    08-28-2005, 10:39 AM Go to last post

  47. Counting Unique \"X\" and \"O\" Occurrences in a Matrix

    Started by ExcelTip‎, 08-28-2005 10:40 AM
    • 0
    • 573
    ExcelTip
    08-28-2005, 10:40 AM Go to last post

  48. Creating a Counting Grid

    Started by ExcelTip‎, 08-28-2005 10:41 AM
    • 0
    • 1,023
    ExcelTip
    08-28-2005, 10:41 AM Go to last post

  49. Summing the Values of Cells Occurring at the Intersection of Ranges

    Started by ExcelTip‎, 08-28-2005 10:50 AM
    • 0
    • 937
    ExcelTip
    08-28-2005, 10:50 AM Go to last post

  50. Summing Values from Different Sheets for the Same Cell Address

    Started by ExcelTip‎, 08-28-2005 10:51 AM
    • 0
    • 2,019
    ExcelTip
    08-28-2005, 10:51 AM Go to last post
+ Post New Thread
Page 3 of 24 FirstFirst 3 ...

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