Search:

Type: Posts; User: fburg; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    24
    Views
    534

    Vincenzo - you can play this 2 ways. If you...

    Vincenzo - you can play this 2 ways.

    If you want to look like the hero all the time, don't tell her about the Lounge and you're set for life.

    If you don't want to bother with us (old) foggies,...
  2. Replies
    24
    Views
    534

    Hi Maud, The explanation was for Vincenzo's...

    Hi Maud,

    The explanation was for Vincenzo's benefit to explain INDEX/MATCH. Anytime I use this combination, I have to think at least twice. It doesn't fall trippingly off the tongue for me.

    No...
  3. Replies
    24
    Views
    534

    Hey Maud - I think that's what I did. I knew I...

    Hey Maud - I think that's what I did. I knew I saw this somewhere!

    As far as having ranking values from 1 to 100, that won't matter to the solution I posted.

    As far as having a variable number...
  4. Replies
    24
    Views
    534

    Hi Vincenzo Attached is a small workbook that...

    Hi Vincenzo

    Attached is a small workbook that does what you want without any macros.

    RG: another saying (probably not Chinese nor Microsoft) - "to macro, or not to macro - that is the...
  5. Thanks RG. I tend to copy/paste the column...

    Thanks RG.

    I tend to copy/paste the column headings from the DB to the Criteria Range. I either do that or use references for the Extract Range.

    I think my problem was the blank and duplicate...
  6. Hi RG, I think what you did would work. For...

    Hi RG,

    I think what you did would work. For some reason, I also had it working with my current layout when I tried Tom's suggestion; the layout included some blank columns and some duplicate...
  7. Tom - forgot to mention in my previous post: I'm...

    Tom - forgot to mention in my previous post: I'm running Excel 2003 (Version 11). Is version 10 the first version with Advanced Filtering?
  8. Hi Tom, Thanks for the suggestion. We just got...

    Hi Tom,

    Thanks for the suggestion. We just got back from a few weeks of vacation and have been slowly catching up with all that happened while we were gone.

    One of the problems I've always had...
  9. Replies
    9
    Views
    192

    why would I be in col A? Fred

    why would I be in col A?

    Fred
  10. Thread: invoice numbers

    by fburg
    Replies
    11
    Views
    221

    Aha! I didn't quite get what you had meant in...

    Aha!

    I didn't quite get what you had meant in post #4 about the merge record #s. And yes, she wants the invoice #s to start with 100. I've done some field math in the past, so I know this can be...
  11. Thread: invoice numbers

    by fburg
    Replies
    11
    Views
    221

    Thanks Paul. I had to put the Receipt #s in...

    Thanks Paul.

    I had to put the Receipt #s in the workbook bcs it seemed like there was no way to generate them in Word w/o VBA and for a directory, as first asked. So for now, it looks like I'll...
  12. Thread: invoice numbers

    by fburg
    Replies
    11
    Views
    221

    Hi Paul, I've been doing some work on what I...

    Hi Paul,

    I've been doing some work on what I need and am attaching it.

    My approach, in the absence of VBA on the MAC for Office 2008, is to have a row for each receipt to be generated. You can...
  13. Replies
    13
    Views
    726

    Hi Maud, While I don't know if the thread I...

    Hi Maud,

    While I don't know if the thread I was looking for had some of your code, I'll give it a try when I have a little more time (leaving on vacation tomorrow). I'd prefer a formula approach...
  14. Replies
    13
    Views
    726

    Hi Gumintwork, Thanks for the suggestion but...

    Hi Gumintwork,

    Thanks for the suggestion but that doesn't do what I'm looking for. I entered your formula in B1 and used A1 as you have. When A1=5, then B1="Yes". But when A1 is changed to...
  15. Thread: invoice numbers

    by fburg
    Replies
    11
    Views
    221

    Sorry Paul. When I said I thought that...

    Sorry Paul.

    When I said


    I thought that saying in a Word forum that this was a "directory" implied a mail-merge - so my bad.

    As to your last paragraph, there would be 7 monthly merges...
  16. Thread: invoice numbers

    by fburg
    Replies
    11
    Views
    221

    Hi Paul, I'm confused about what you're...

    Hi Paul,

    I'm confused about what you're suggesting.



    I do understand that if I start a table and number the row using Word's numbering feature that adding a new row to the table results in a...
  17. Thread: invoice numbers

    by fburg
    Replies
    11
    Views
    221

    invoice numbers

    Hi All,

    I've seen numerous posts, articles on using sequential numbers for things like invoices - some go back to the beginning of the century.

    However, my needs are slightly different:
    - the...
  18. Replies
    13
    Views
    726

    Thanks Rory. After I posted my question, I...

    Thanks Rory.

    After I posted my question, I thought about it. Clearly, a cell can have a formula and a value, which is what's usually displayed (I do rarely use CTRL+` to display formulas). But...
  19. Replies
    13
    Views
    726

    Rory, I'm curious about the iterative...

    Rory,

    I'm curious about the iterative solution.

    Using your example of =IF(A1>0,A1,B1) as the formula in B1:
    - B1 has a formula in it as you gave
    - the value of B1, for example, is the word...
  20. Replies
    13
    Views
    726

    RG, Rory, Thanks much. This works fine in...

    RG, Rory,

    Thanks much.

    This works fine in my little test. Let me try it in my gradebook.

    Fred
  21. Replies
    13
    Views
    726

    Thanks RG. Seems simple but I'm not getting...

    Thanks RG.

    Seems simple but I'm not getting it. What I'm getting is what I'd expect of the IF test. If I start with A1 empty and put your IF test in B1, I get nothing in B1 (ok). If I now put...
  22. Replies
    13
    Views
    726

    IF test: leave cell as is

    I vaguely remember a post asking whether it was possible to do an IF test, give a value/expression if the test was true, but leave the cell as it was if the test was false.

    I can't seem to find...
  23. capture data from other sheets: which approach is better?

    Happy New Year to all!

    I am attaching 2 screen shots of part of a sheet in my gradebook workbook. The purpose of this sheet is to capture various types of grades (tests, quizzes, etc) only for...
  24. Actually, your question about col D prompted me...

    Actually, your question about col D prompted me to think of something else (but no she wouldn't have deleted all of col D).

    The drop down depends on a few other cells:
    - col C, which is hidden,...
  25. Hi Rory, Delete key: nope, it's marked...

    Hi Rory,

    Delete key: nope, it's marked "Delete". It's in the upper right corner, just like on the main part of a Windows keyboard (where there are both "Delete" and "Backspace". It just works like...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4