All Posts by n.ashutosh

2 Random numbers generator in Excel

Although Excel’s Data Analysis Toolpak can generate good random numbers, I had to create these various functions to meet my specific needs. First: Generating Unique Random Numbers This function was modified from ozgrid’s RandLotto function, which returns a string of numbers without duplicates. This function will return an array of unique random integers that are […]

Continue reading

2 Convert a number to its equivalent letter

If you want to convert a number to its equivalent letter, for e.g. 5 to E, you can use two approaches. 1. Insert this code in a Module and use this function ‘Author: Alan L. Lesmerises‘From: Function ColumnLetter(ColumnNumber As Integer) As String  If ColumnNumber > 26 Then     ‘ 1st character:  Subtract 1 to map the characters […]

Continue reading

Excel 12 will have lots of columns and rows…

Excel Watch: An Official Excel Blog: “Probably the most common question the Excel team gets from our customers is ‘when are you going to add more rows/more columns/more rows and more columns’… Well, the answer to the question is ‘in Excel 12.’ Specifically, the Excel 12 grid will be 1,048,576 rows by 16,384 columns. That’s […]

Continue reading

3 How to create XY scatter plot in MS Access

Creating scatter plots in Microsoft Access is a challenging problem. Follow these steps to create your own scatter plot: Under forms tab, click New On the New form window select Chart Wizard and Select the table, which has your data, hit OK On the next screen, add two fields for which you want to plot […]

Continue reading
1 14 15 16 17 18 22