+ Post New Thread
Page 1 of 23 1 2 3 11 ... Last
Threads 1 to 50 of 1132

# 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

• Threads: 3
• Posts: 9

#### Last Post:

by

12-18-2019, 02:36 PM

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

• Threads: 9
• Posts: 32

#### Last Post:

by

11-19-2020, 02:56 PM

3. ## Excel Tips

(1 Viewing)

#### Forum Statistics:

• Threads: 76
• Posts: 373

#### Last Post:

by

Today, 06:33 AM

1. ### Sticky: Restoring a Corrupted File

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

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

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

• 0
• 1,611
01-21-2005, 07:45 AM
3. ### Separating strings into substrings.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• 1
• 1,512
08-23-2005, 03:35 AM
22. ### Encoding a Sequence of Letters

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ Post New Thread
Page 1 of 23 1 2 3 11 ... Last

#### Forum Information and Options

##### Users Browsing this Forum

There are currently 2 users browsing this forum. (1 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 no unread posts
Hot thread with unread posts
Hot thread with no unread posts
Thread is closed
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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1