Page 1 of 23 1 2 3 11 ... Last
Threads 1 to 50 of 1144

# Forum: Tips and Tutorials

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

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

• Posts: 9

#### Last Post:

by

12-18-2019, 02:36 PM

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

• Posts: 32

#### Last Post:

by

11-19-2020, 02:56 PM

3. ## Excel Tips

• Posts: 392

#### Last Post:

01-27-2023, 10:56 AM

1. ### Sticky: Restoring a Corrupted File

• 3
• 39,188
06-21-2012, 12:55 PM
2. ### Sticky: Nine Quick Tips to Improve VBA Performance

• 3
• 6,567
05-24-2022, 03:11 AM
1. ### [SOLVED] Consolidate and Merge Data on a Separate Sheet

• 0
• 654
01-01-1970, 12:00 AM
2. ### Let Excel talk/Speak Programmatically

• 0
• 1,679
01-21-2005, 07:45 AM
3. ### [SOLVED] Separating strings into substrings.

• 1
• 10,749
05-11-2005, 08:17 AM
4. ### Calculating the average of every Nth value.

• 0
• 1,646
05-11-2005, 08:28 AM
5. ### Retrieving a value from a range according to position

• 0
• 1,432
05-31-2005, 09:20 AM
6. ### IF-AND-OR statements.

• 0
• 1,534
05-31-2005, 09:23 AM
7. ### Case sensitive lookups.

• 0
• 1,786
06-03-2005, 12:25 PM
8. ### Counting values meeting multiple criteria

• 0
• 1,520
06-12-2005, 03:06 AM
9. ### Checking The Frequency of Multiple Values In A Range

• 0
• 1,702
07-04-2005, 02:33 AM
10. ### Counting The Number of Players According To Their Score In A Particular Quarter

• 1
• 1,578
07-07-2005, 04:00 PM
11. ### Calculating Retail Price And Sales Tax Using The Round Function

• 0
• 4,955
07-10-2005, 01:25 AM
12. ### Separtaing A String Into Substrings.

• 0
• 1,606
07-10-2005, 01:27 AM
13. ### Avoiding Errors When Subtracting Times

• 0
• 2,131
07-24-2005, 01:48 AM
14. ### Calculating The Week Number Corresponding With A Specific Date

• 0
• 1,785
07-24-2005, 01:49 AM
15. ### Calculating Absolute Difference Between Two Time Values

• 3
• 5,901
08-10-2005, 01:43 AM
16. ### Looking Up A Value In A Name Range

• 1
• 1,594
08-15-2005, 10:07 AM
17. ### Restricting Cell Entries to Text Only

• 0
• 1,534
08-23-2005, 03:26 AM
18. ### Restricting the Number of Characters Entered into a Cell

• 0
• 1,467
08-23-2005, 03:27 AM
19. ### Combining Text and a Formatted Date into a Single Entity

• 0
• 1,340
08-23-2005, 03:33 AM
20. ### [SOLVED] Combining Numbers that Have Leading Zeros

• 1
• 1,766
08-23-2005, 03:34 AM
21. ### Combining the Contents of Every N Number of Cells into One Value

• 1
• 1,590
08-23-2005, 03:35 AM
22. ### [SOLVED] Encoding a Sequence of Letters

• 2
• 1,618
08-23-2005, 03:35 AM
23. ### Combining Text and Numerically Calculated Results into One Output String

• 0
• 1,435
08-23-2005, 03:36 AM
24. ### Formulas Erroneously Appearing as Text

• 0
• 1,322
08-23-2005, 03:37 AM
25. ### Checking Whether Cells in a Range are Blank, and Counting the Blank Cells

• 0
• 1,667
08-23-2005, 03:43 AM
26. ### Removing Hidden Apostrophes from Imported Numbers

• 0
• 1,904
08-23-2005, 03:48 AM
27. ### [SOLVED] Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters

• 2
• 2,068
08-23-2005, 03:49 AM
28. ### Converting Numbers with Trailing Minus Signs to Normal Negative Numbers

• 0
• 2,093
08-23-2005, 03:59 AM
29. ### Replacing Substrings with Numbers from Adjacent Cells

• 0
• 1,013
08-23-2005, 04:00 AM
30. ### Performing Numeric Operations on Substrings

• 0
• 1,064
08-23-2005, 04:01 AM
31. ### Searching a String for a Matching Word from another String

• 0
• 1,197
08-23-2005, 04:01 AM
32. ### Find the Alphabetically Lowest Letter in a List

• 0
• 1,839
08-23-2005, 04:02 AM
33. ### Finding the Relative Position of Numbers within a String

• 0
• 1,514
08-23-2005, 04:05 AM
34. ### Searching a String for a Specific Substring

• 0
• 2,669
08-23-2005, 04:05 AM
35. ### Determining Long Distance Phone Calls, Based on the Number Dialed

• 0
• 1,137
08-23-2005, 04:06 AM
36. ### Rearranging a String in Alphabetic Order

• 0
• 1,310
08-23-2005, 04:07 AM
37. ### Retrieving the Cell Address of the Largest Value in a Range

• 1
• 1,245
08-23-2005, 04:20 AM
38. ### Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up

• 0
• 1,164
08-23-2005, 04:21 AM
39. ### Retrieving the Row Number that Corresponds with a Matched Value in a Look Up

• 0
• 1,265
08-23-2005, 04:21 AM
40. ### [SOLVED] Entering Dates Quickly

• 5
• 1,549
08-23-2005, 11:39 AM
41. ### [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week

• 1
• 1,803
08-23-2005, 11:42 AM
42. ### Calculating a Required Date According to Two Criteria

• 0
• 1,264
08-23-2005, 11:49 AM
43. ### [SOLVED] Eliminating Negative Values from Date Subtractions

• 1
• 1,140
08-23-2005, 11:51 AM
44. ### Avoiding Negative Values when Calculating the Number of Days between Two Dates

• 0
• 1,237
08-23-2005, 11:52 AM
45. ### Avoiding False Results when Counting Dates Matching Specified Criteria

• 0
• 1,095
08-23-2005, 11:53 AM
46. ### Calculating the Week Number Corresponding with a Specific Date

• 2
• 1,193
08-23-2005, 11:54 AM
47. ### Finding the Number of Days in a Given Month

• 0
• 1,028
08-23-2005, 11:55 AM
48. ### Finding the Serial Number of the Last Day of the Month

• 0
• 1,064
08-23-2005, 11:56 AM
49. ### Adding a Specified Number of Months to a Date

• 0
• 995
08-23-2005, 11:57 AM
50. ### Converting a Date into a String, Indicating the Quarter Number and Year

• 0
• 861
08-23-2005, 11:59 AM

Page 1 of 23 1 2 3 11 ... Last

#### Forum Information and Options

##### Users Browsing this Forum

There are currently 1 users browsing this forum. (0 members & 1 guests)

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.

Note: when sorting by date, 'descending order' will show the newest results first.