Search results for query: *

I am working with a fairly complicated directory/folder structure which has many levels, and need to change the default folder frequently in both Word and Excel. Changing the default file location in Word is easy and fast: all I have to do is call up Tools | Options and modify the path, which I...

I have a large block of formulae in an Excel worksheet, and I need to create a transpose of that block in another worksheet. That is, the formulae need to be the same as in the original block, but the formula in the ith row and jth column of sheet X now needs to appear in the jth row and the...

Is there an Excel function which will return the Nth unique item in a list please? For example, if I have the names Albert, Bessie, Carrie, Albert, Carrie, Carrie & Davina in cells A1:A7 respectively, I want FX(A1:A7,1) to return the value Albert, FX(A1:A7,2) to return the value Bessie and...

I change the default file location setting a lot in Excel, to hop from project to project many times a day. To do this I have to re-type the full file path of the current project, which is routinely four or five sub-folders long. With some of my co-workers setting up folder names that are very...

We've just taken delivery of a batch of new Windows XP PCs. Excel 2000 is installed on all of them, but we're apparently unable to import ASCII text files into any of them. Instead, we're getting the following message: "The file cannot be accessed. The file may be read-only, or you may...

Is there a way to create an X-Y scatterplot in Excel which has a label assigned to each point in the graph, other than by manually changing every single one? The graph wizard gives you the options of labelling the points with either the X values or the Y values, but I want to assign a set of...

How do I tell SAS to read a character other than a period as a missing value when reading from as ASCII file please? The character I want to interpret as a missing value is an asterisk, so the data looks like this: 1 43 6 23 2 31 3 * 3 * 3 7 etc I can't find this in the manuals or the...

I've just come across something that I feel is both stupid and dangerous in Excel, and I'm wondering just how many people know about it. To illustrate the problem, type a 1 into cell A1, and type the formula =1+A1 into cell A2, so A1 contains 1, and A2 now contains 2. Now conduct a search and...

Does there exist an Excel function which will transform a formula into a text string? For example, if cell B2 contains the formula =B3+1, and I want a text version of this in cell A1, then I want to write '=XXX(B2)' into cell A1, where XXX is the name of this hypothetical function, and this...

I have a vast data set containing numbers for the most part, but with a few cells somewhere in the middle of it containing formulae which generate numbers. I therefore can't distinguish the numbers from the calculated cells just by looking at the worksheet. Is there a way I can use the...

This has to be the silliest query posted today, and I apologise in advance for it, but I can't work out the correct syntax. How do I suspend running of a VB program until a character has been received from the keyboard?

I'm running VB5 under Windows NT. I've got a FileListBox which allows me to select one of the files with a given extension from within a directory that I've specified. What it's actually showing are the correct files, but expressed as short filenames, i.e. the names as they would have appeared...

I want to save the list of files generated by a search using Windows Explorer, together with their full paths, directly to an ASCII file (which I then want to access from another application). I can't see an easy way to do this. Can anyone tell me how it can be done, or if it can't via...