Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Other Useful Regular Excel Formulas

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Excel Tips & Tricks Start

1.  Nth particular weekday in each month of a given year

By selecting a year and a weekday number, you can dynamically get a list of dates on which the weekday falls by week/month for the year. Regular formulas were used to demonstrate this technique.

2.  Get random month names

You may want to fill a range with random month names. Select the range and enter the following formula into the first cell
and press the Ctrl/Enter key combination:

Or better yet, name the formula (Insert/Define/Define) and enter the name into your range.

3.  How do you know whether your list is unique?

Do you want to check whether your list is unique?

4.  Do you need a formula to sum all the numbers above from a particular cell?

The range may include blank cells or text values. You will find this formula handy. You may insert or delete rows anywhere above the cell.

5.  A formula returning month names (Jan through Dec).

You need to enter 12 month names into a range in a column or a row.

You may think that you have to write a macro for something like this.

However, our simple formula gets the job done.

6.  A formula returning random dates (mm/dd/yyyy) between two dates.

7.  A formula returning random month names.

8.  A formula returning random alphabets (A-Z).

More Excel Tips & Tricks

Excel Tips & Tricks Start. > Find Your Excel VBA Procedure Quickly From Your Workbook Window & Alternatives to Excel Array Formulas & Sumproduct & Other Useful Regular Excel Formulas & Advanced Filter & Other Tips

Excel Tips & Tricks  $19.95 | Secure Payment Options | Instant Buy/Download | 30 Day Money Back Guarantee Developers Site | More Tutorials

Special! Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00.
ALL purchases totaling over $150.00 gets you BOTH!  Purchase(s) MUST be made via this site.

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft