Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    16
    Views
    1,525

    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...
  2. Replies
    16
    Views
    1,525

    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...
  3. Replies
    16
    Views
    1,525

    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...
  4. Replies
    16
    Views
    1,525

    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...
  5. Replies
    17
    Views
    1,577

    [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...
  6. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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?
  7. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  8. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    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...
  9. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  10. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  11. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  12. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  13. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  14. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  15. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  16. Thread: which is faster?

    by fburg
    Replies
    19
    Views
    575

    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...
  17. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    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...
  18. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    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...
  19. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    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...
  20. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    ah, the old "hidden helper" column/row trick!...

    ah, the old "hidden helper" column/row trick! Good one Maud!

    I already implemented Rory's approach but haven't finalized yet. I did notice a (further) slow-down of the sheet after doing that. So I...
  21. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    Exactly RG So I labor under the burden of...

    Exactly RG

    So I labor under the burden of creating spreadsheets for Excel 2008 on the MAC (but I do it on my computer). Amazing what it can't do (as Rory once replied to once of my past posts).
    ...
  22. Replies
    16
    Views
    743

    A rose by any other name would still be a -...

    A rose by any other name would still be a - genius.:D

    by Billy Shakespeare
  23. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    Hi Rory, forgot to mention - there will only...

    Hi Rory,

    forgot to mention - there will only be 1 match in this case. Names are selected from a drop-down validation list. Once the name is selected, the list is recomputed. Yes - this does...
  24. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    Zeddy - We're talking about a die-hard MAC user...

    Zeddy - We're talking about a die-hard MAC user here.

    She and I were once talking about what we'd do if we hit it big in the lottery. I told her that I'd buy her a "real" computer - one that was...
  25. Thread: find col and row

    by fburg
    Replies
    18
    Views
    804

    find col and row

    Hi All,

    I'd like to be able to find if a name, say in cell A1, is in a range of cells, say B1:H10. If it is, return the col and row of the match; could be done as 2 separate formulas - 1 for the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4