+ Post New Thread
Page 23 of 23 First ... 13 21 22 23
Threads 1101 to 1144 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: Nine Quick Tips to Improve VBA Performance

• 3
• 6,567
05-24-2022, 03:11 AM
2. ### Sticky: Restoring a Corrupted File

• 3
• 39,188
06-21-2012, 12:55 PM
1. ### Avoiding Negative Values when Calculating the Number of Days between Two Dates

• 0
• 1,237
08-23-2005, 11:52 AM
2. ### [SOLVED] Eliminating Negative Values from Date Subtractions

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

• 0
• 1,264
08-23-2005, 11:49 AM
4. ### [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week

• 1
• 1,803
08-23-2005, 11:42 AM
5. ### [SOLVED] Entering Dates Quickly

• 5
• 1,549
08-23-2005, 11:39 AM
6. ### Retrieving the Row Number that Corresponds with a Matched Value in a Look Up

• 0
• 1,265
08-23-2005, 04:21 AM
7. ### Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up

• 0
• 1,164
08-23-2005, 04:21 AM
8. ### Retrieving the Cell Address of the Largest Value in a Range

• 1
• 1,245
08-23-2005, 04:20 AM
9. ### Rearranging a String in Alphabetic Order

• 0
• 1,310
08-23-2005, 04:07 AM
10. ### Determining Long Distance Phone Calls, Based on the Number Dialed

• 0
• 1,137
08-23-2005, 04:06 AM
11. ### Searching a String for a Specific Substring

• 0
• 2,669
08-23-2005, 04:05 AM
12. ### Finding the Relative Position of Numbers within a String

• 0
• 1,514
08-23-2005, 04:05 AM
13. ### Find the Alphabetically Lowest Letter in a List

• 0
• 1,839
08-23-2005, 04:02 AM
14. ### Searching a String for a Matching Word from another String

• 0
• 1,197
08-23-2005, 04:01 AM
15. ### Performing Numeric Operations on Substrings

• 0
• 1,064
08-23-2005, 04:01 AM
16. ### Replacing Substrings with Numbers from Adjacent Cells

• 0
• 1,013
08-23-2005, 04:00 AM
17. ### Converting Numbers with Trailing Minus Signs to Normal Negative Numbers

• 0
• 2,094
08-23-2005, 03:59 AM
18. ### [SOLVED] Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters

• 2
• 2,068
08-23-2005, 03:49 AM
19. ### Removing Hidden Apostrophes from Imported Numbers

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

• 0
• 1,667
08-23-2005, 03:43 AM
21. ### Formulas Erroneously Appearing as Text

• 0
• 1,322
08-23-2005, 03:37 AM
22. ### Combining Text and Numerically Calculated Results into One Output String

• 0
• 1,435
08-23-2005, 03:36 AM
23. ### [SOLVED] Encoding a Sequence of Letters

• 2
• 1,618
08-23-2005, 03:35 AM
24. ### Combining the Contents of Every N Number of Cells into One Value

• 1
• 1,590
08-23-2005, 03:35 AM
25. ### [SOLVED] Combining Numbers that Have Leading Zeros

• 1
• 1,766
08-23-2005, 03:34 AM
26. ### Combining Text and a Formatted Date into a Single Entity

• 0
• 1,340
08-23-2005, 03:33 AM
27. ### Restricting the Number of Characters Entered into a Cell

• 0
• 1,467
08-23-2005, 03:27 AM
28. ### Restricting Cell Entries to Text Only

• 0
• 1,534
08-23-2005, 03:26 AM
29. ### Looking Up A Value In A Name Range

• 1
• 1,594
08-15-2005, 10:07 AM
30. ### Calculating Absolute Difference Between Two Time Values

• 3
• 5,901
08-10-2005, 01:43 AM
31. ### Calculating The Week Number Corresponding With A Specific Date

• 0
• 1,785
07-24-2005, 01:49 AM
32. ### Avoiding Errors When Subtracting Times

• 0
• 2,131
07-24-2005, 01:48 AM
33. ### Separtaing A String Into Substrings.

• 0
• 1,606
07-10-2005, 01:27 AM
34. ### Calculating Retail Price And Sales Tax Using The Round Function

• 0
• 4,955
07-10-2005, 01:25 AM
35. ### Counting The Number of Players According To Their Score In A Particular Quarter

• 1
• 1,578
07-07-2005, 04:00 PM
36. ### Checking The Frequency of Multiple Values In A Range

• 0
• 1,702
07-04-2005, 02:33 AM
37. ### Counting values meeting multiple criteria

• 0
• 1,520
06-12-2005, 03:06 AM
38. ### Case sensitive lookups.

• 0
• 1,786
06-03-2005, 12:25 PM
39. ### IF-AND-OR statements.

• 0
• 1,534
05-31-2005, 09:23 AM
40. ### Retrieving a value from a range according to position

• 0
• 1,432
05-31-2005, 09:20 AM
41. ### Calculating the average of every Nth value.

• 0
• 1,646
05-11-2005, 08:28 AM
42. ### [SOLVED] Separating strings into substrings.

• 1
• 10,749
05-11-2005, 08:17 AM
43. ### Let Excel talk/Speak Programmatically

• 0
• 1,679
01-21-2005, 07:45 AM
44. ### [SOLVED] Consolidate and Merge Data on a Separate Sheet

• 0
• 654
01-01-1970, 12:00 AM

+ Post New Thread
Page 23 of 23 First ... 13 21 22 23

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

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

#### Icon Legend

Contains no unread posts