Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DQR
  • Order by date
  1. DQR

    Changing the default folder in Excel

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

    Changing the default folder in Excel

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

    Transposing an array of formulae in Excel

    Perfect - it worked like a dream. Many thanks!
  4. DQR

    Transposing an array of formulae in Excel

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

    Unique Item N in an Excel List

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

    Unique Item N in an Excel 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...
  7. DQR

    Excel Default File Location

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

    Excel Text Import Wizard in XP

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

    Excel Default File Location

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

    Excel Default File Location

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

    Excel Text Import Wizard in XP

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

    Labels on Excel X-Y Graphs

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

    Labels on Excel X-Y Graphs

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

    Labels on Excel X-Y Graphs

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

    Labels on Excel X-Y Graphs

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

    Labels on Excel X-Y Graphs

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

    Missing Value Code

    ...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 online help, though I don't doubt that it's there somewhere: my apologies for having to...
  18. DQR

    "Search & Replace" Shock

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

    Convert Formula into Text

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

    "Search & Replace" Shock

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

Part and Inventory Search

Back
Top