Search results for query: *

Everyone - thank you: that's great. That CopyPath utility does exactly what I want, and I can see a lot of other uses for that as well. Patrick's solution is fine also; I realise I just wasn't thinking outside the box, as the expression goes. Toby - you're right: I don't really need it, do I...

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

Perfect - it worked like a dream. Many thanks!

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

BlueDragon2, TLady and Geoff, many thanks for your replies and your time. This note is just to summarise both the problem and to my progress with it since the original posting: I think it's now solved. BlueDragon2 - I actually want to be able to select the Nth ordered entry from the list...

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

Coming to think of it, it may be that the best I can manage is to use the File | Open dialog to find the file I want, and then call up a function that will return the full path of my current location at that time. I'd then be able to copy that path into Notepad as you suggested. It wouldn't...

As an additional piece of information, we've discovered that files stored on the PC's local drive ARE accessible using the text wizard. Only the ones stored on the network aren't. So I'm wrong about the text import wizard. However, those same files on the network are perfectly accessible by...

The names of the subfolders are often changed during the course of the project by the people who created them: we have maybe half a dozen people working on as many projects simultaneously, and the structure of the subfolders in any one project routinely changes to reflect developments in the...

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

Ah well - at least I'm not missing an obvious trick. Many thanks for your time on this one. Have a good weekend, DQR

I see that the labels I put on top of the table in my original posting have been "moved" because the message was written in Courier, but posted in Arial. The X and Y headings are actually positioned above the two columns of numbers: my apologies if this has caused any confusion.

If I include the column of labels in the source data, the chart the wizard generates is not an X-Y scatterplot in which Y is plotted against X. Instead, it's a chart of both the X and Y values against the numbers 1, 2 and 3. I've also tried your suggestion of redefining the source data after...

Thank you, but I'm afraid that isn't quite what I'm trying to do: the labelling tab only gives me access to the X values or the Y values as labels. "Show Value" gives me the Y values of the graph, whereas "Show Label" gives me the X values. I want a set of text labels...

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

Ahh, if only there were the time and the money! We're a small company, and everybody learns these things on the hoof (and I can't believe we're alone in that regard). That is also of course the reason that forums like this one are so phenomenally useful to us. For my part, I tend to forget...

Cheers Skip - I'll try it out. I'm not very familiar with VBA programming, so forgive me if this is a silly question: once it's written, can this function be called in the same way you might call one of the standard built-in functions, e.g. you type "=xlAddress(A2)" into cell A1 if...

Hmmm - I anticipated an immediate response to this, and I was right. To clarify, it's not the functionality of the search and replace function that concerns me, but the ease with which I feel an error in its use can be made, and the difficulty of correcting that error after the event. [As...