Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.26 seconds.

  1. Replies
    23
    Views
    704

    Sea it your way? Absolutely, even with a sea...

    Sea it your way? Absolutely, even with a sea between us!

    As the chairman of the board said: he did it his way.

    Fred
  2. Hi RG, Zeddy Thanks for the response. So...

    Hi RG, Zeddy

    Thanks for the response.

    So now I know the difference between sheet 1 and 2 (I had already copied the file to my bag of tricks so I just wanted to know how to use it).

    I did see...
  3. Hi RG, This seems very useful. But I'm a bit...

    Hi RG,

    This seems very useful. But I'm a bit confused by what's displayed.

    First, there's sheet1 vs sheet2. Is sheet1 now obsolete?

    On sheet2, some #s at the end of the list are indented...
  4. This is for my friend who has a MAC. She uses AOL...

    This is for my friend who has a MAC. She uses AOL email. I wasn't sure if, when I posted this late at night, whether this "box feature" would carry over to hers. So, Maud, VBA is out of the question....
  5. Box/Gridlines from Excel when pasting into email/Word

    Hi All,

    This may be a Windows or other question but since I'm starting with Excel, I thought I'd post this here.

    I have some cells, say A1:A15, that I'd like to paste into an e-mail. The cells...
  6. Replies
    12
    Views
    1,502

    [SOLVED] There was also a thread here within about the...

    There was also a thread here within about the last month (can't find it now) where someone pointed to a MS download that does fuzzy matching. I downloaded this but haven't installed it yet. From my...
  7. Replies
    16
    Views
    1,579

    Oops - so busy: didn't even notice that I pretty...

    Oops - so busy: didn't even notice that I pretty much said this in my last post!

    Finally a chance to read thru the comments.

    Thanks to all who commented.

    The work around being?
    - unchecking...
  8. Replies
    16
    Views
    1,579

    Sorry guys that I haven't been able to look at...

    Sorry guys that I haven't been able to look at the posts until now since I've been busy grading papers.

    And there's the thing I forgot to mention - this is for my die-hard MAC person. Really...
  9. Replies
    16
    Views
    1,579

    Thanks guys but I'm not sure I appreciate the...

    Thanks guys but I'm not sure I appreciate the difference. I checked the length of S4 when there was nothing in there (just LEN(S4) in a separate cell) and got 0.

    Would ISBLANK even work when the...
  10. Replies
    16
    Views
    1,579

    custom validation formula

    Hi All,

    I'm trying to create a custom validation formula (Excel 2003). It seems like it should be easy but "easy" isn't working.

    I have a cell S4 where, via dropdown box, I can set a reason for...
  11. Replies
    17
    Views
    1,716

    [SOLVED] let's say that col B has some indication that the...

    let's say that col B has some indication that the item has been sold - like the word "sold".

    let's also say that row 1 is a header row.

    let's use col C for the new item number.

    Then put...
  12. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    So, I take it that Excel 2011 doesn't give you...

    So, I take it that Excel 2011 doesn't give you the same feeling about having 2007 at work?
  13. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    Aha. I understand now. Wouldn't it be nice if...

    Aha. I understand now.

    Wouldn't it be nice if there was a list of incompatibilities between the 2 OS's for Excel (or any other Office pgm). Of course, this would be version dependent. But you're...
  14. Thread: find col and row

    by fburg
    Replies
    18
    Views
    847

    Yes, using Maud's helper column, there were...

    Yes, using Maud's helper column, there were FALSE's if A1 did not appear in that row. What I thought I was accomplishing was, for row 9, doing an array multiplication of {FALSE,FALSE,....,TRUE} by...
  15. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    May give that a try. Right now if the column does...

    May give that a try. Right now if the column does not have a "Y" in it, it has nothing. So I'd be looking to see, for example, if the helper column has "YRory" above the current row.

    But why not...
  16. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    Hi Zeddy, You lost me. If MAC Excel 2011...

    Hi Zeddy,

    You lost me.

    If MAC Excel 2011 has VBA and it has "the same environment as the Windows VBE...", why would she need a Windows OS set up on the MAC? Couldn't I just take the file from...
  17. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    Hi Martin, Not a bad idea - it's like program...

    Hi Martin,

    Not a bad idea - it's like program code (the version with the formulas) and, as you said, an executable (the version with the values). Will have to think on this.

    While I don't...
  18. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    Hi Zeddy, Not a bad idea. Is Windows VBA the...

    Hi Zeddy,

    Not a bad idea. Is Windows VBA the same as MAC VBA?

    Then I'll be back on here asking how to do x in VBA, since I'm not great w/ it. But it would be a good experience and certainly...
  19. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    Hi Rory, Since I'm still doing my main work on...

    Hi Rory,

    Since I'm still doing my main work on Excel 2003, it doesn't have COUNTIFS. I do actually have Excel 2010 loaded on my computer (and just got 2013 but not loaded yet), so it's a...
  20. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    Hi Zeddy, I've done something like what you...

    Hi Zeddy,

    I've done something like what you suggested - save a formula in a first row of a column w/o the equal sign and add a comment to explain what I did in case I need to restore the formula...
  21. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    Hi Martin, Sorry, I did not mention explicitly...

    Hi Martin,

    Sorry, I did not mention explicitly - can't use VBA. That other thread to which I referred (no way for you to know) that this was for a friend running Excel 2008 on a MAC. You should...
  22. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    613

    which is faster?

    Hi All,

    Per another thread, I have a spreadsheet where recalc time is of concern - already seeing the "Calc'g x%" msg on the taskbar when updates are made.

    Right now, I have a working...
  23. Thread: find col and row

    by fburg
    Replies
    18
    Views
    847

    Hey Guys, I just realized that there seems to...

    Hey Guys,

    I just realized that there seems to be a fundamental difference between Rory's original "SUMPRODUCT" solution and Maud's "MATCH" formula (even with my small mods). I can adapt Rory's...
  24. Thread: find col and row

    by fburg
    Replies
    18
    Views
    847

    Hi Rory, Not sure I'm following. First, my...

    Hi Rory,

    Not sure I'm following.

    First, my post #12 was aimed at getting the row of the match. I think I also suggested that "column location would follow by extension." In Maud's original, the...
  25. Thread: find col and row

    by fburg
    Replies
    18
    Views
    847

    Maud, Rory I did a little playing around with...

    Maud, Rory

    I did a little playing around with Maud's solution. I certainly will not claim any originality in my approach.

    Don't know if it would work any faster but all the MATCH's in Maud's...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4