Search:

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

Page 1 of 14 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    143

    Thanks a bunch. I'm actually parsing through...

    Thanks a bunch.

    I'm actually parsing through a matrix that's written out as a vector. And I can replace the count() with a large integer, since what I'm counting up has to all fall within a...
  2. Replies
    5
    Views
    143

    Need confirmation ... I believe I have solved...

    Need confirmation ...

    I believe I have solved this problem by changing the count(A:A) bit to count(A2:A$786434) for an entry in row 2.

    Am I missing anything that anyone can see?
  3. Replies
    5
    Views
    143

    Promising (seems OK at the top). But ... it...

    Promising (seems OK at the top). But ... it returned a #REF! from row 262,600 downward.

    I think I know where the problem is, but I'm not sure how to address it.

    Because there are 786,435 rows...
  4. Replies
    5
    Views
    143

    Conditionally Void a Cumulative Sum

    I have a large data set (800K rows), so I'm looking for 1) any solution to my problem, but 2) an efficient one would be better.

    See the attached file ...

    I have columns A and B filled with...
  5. There's a lot to go with here, some of which...

    There's a lot to go with here, some of which works.

    1.


    This works well. There are two problems (worked around here for people who have this problem in the future).

    1) Using row() inside...
  6. Collapse range's entries by removing some values

    Suppose A1.A9 looks like this:

    1,2,=na(),4,=na(),6,7,8,9

    I am looking for a way, ideally with (plain) formulas in B1.B7 to get:

    1,2,4,6,7,8,9

    If I were coding this, it would be easy to...
  7. Replies
    0
    Views
    163

    Format/Strategies for HTML Output

    I output from a spreadsheet to HTML. I format my cells with a custom format (like ?0.0) so that the "ones digits" and "tens digtis" line up when I center the column. When Excel outputs this to HTML,...
  8. Replies
    4
    Views
    456

    Thanks. Yes, this seems to do what I need. Not...

    Thanks. Yes, this seems to do what I need. Not very convenient for sharing though ...
  9. Replies
    4
    Views
    456

    Transferability of User Added Buttons

    If I write a macro, and install a control for it in my spreadsheet, that control will show up and run the macro if I send the file to someone else.

    But, I'm having trouble doing the same thing...
  10. Replies
    11
    Views
    5,259

    Simple and Effective Solution with No Encryption

    I solved a similar problem on a machine where there were two of us using the same username (don't ask why ... family trust issues).

    Anyway, you can create a folder that has no name (actually, its...
  11. Thanks Steve. I am talking about 2 different...

    Thanks Steve.

    I am talking about 2 different ideas in my query: average and "average". This is why I keep using double quotes.

    I sometimes use averaging as an error trap (other formulas too)....
  12. P.S. Sorry if my "average" metaphor didn't work...

    P.S. Sorry if my "average" metaphor didn't work well.

    What I meant was that I want something that would operate on 2, ,2, ,2 and return the average as 2.0 and operate on 2, ,2, ,3 and return 2.3....
  13. This Is Very Close

    This is a good approach to my problem ...

    But it runs into trouble if I don't know what the text is going to be in a range.

    So I need a formula that will look at a range, determine that it...
  14. "Average" a Range of Strings (Like They Were Numbers)

    I want a formula using functions that I can put into a cell (I have much bigger ranges than in the examples below). If I had 3, ,4, ,5 in cells A1:A5, and I asked Excel to average them in B1, it...
  15. Replies
    5
    Views
    1,243

    Sorry for not being clearer ... My question is...

    Sorry for not being clearer ...

    My question is more academic ... is there a way to add an item to a file's context menu to pass it to a URL?
  16. Replies
    5
    Views
    1,243

    Pass a File to a URL

    I know how to add an entry to a context menu ...

    But ... is there a way to pass the file to a URL?

    I am thinking that it would convenient to add a context menu entry to, say *.exe files, that...
  17. Replies
    7
    Views
    1,471

    Weird. I just did this with Chrome, and for me...

    Weird. I just did this with Chrome, and for me the icon does not change.
  18. Replies
    7
    Views
    1,471

    Roderunner: That dialog box is for a shortcut,...

    Roderunner: That dialog box is for a shortcut, not for a file. Your suggestion does work for a shortcut, but not for the original file.Infinicore: Your suggestion does change the default program to...
  19. Replies
    10
    Views
    11,926

    I think I am good with BruceR's response: 1) it's...

    I think I am good with BruceR's response: 1) it's going to be a pain if I really need to do this, but 2) it can be done.

    I do like the example in BruceR's links. I hadn't thought of that...
  20. Replies
    10
    Views
    11,926

    No probs RetiredGeek ... we're all friends here.

    No probs RetiredGeek ... we're all friends here.
  21. Replies
    7
    Views
    1,471

    Oh ... I wouldn't worry about that. All it...

    Oh ... I wouldn't worry about that.

    All it shows is two copies of the same file, with identical details, in 2 folders, with different icons. You can see the orange Firefox icon on the left and the...
  22. Replies
    10
    Views
    11,926

    Thanks for all the suggestions. Yes, this is a...

    Thanks for all the suggestions.

    Yes, this is a problem with obvious workarounds.

    But ... I'd still like to get better control of how my machine is organized if someone has any other ideas.
  23. Replies
    10
    Views
    11,926

    Edit Items Pinned to the Start Menu

    I have items pinned to my start menu.

    I'm OK with right-clicking to unpin those.

    But, I'd be a lot happier if I knew where I could modify the location of those items on my own.

    For example,...
  24. Replies
    7
    Views
    1,471

    1 Filetype 2 Different Icons

    Not sure if this is a Windows 7 problem ... might be Office 2010.

    I had a docx file in Word. I saved it as "web page, filtered". It was given an HTM extension.

    In the folder where I saved it,...
  25. Replies
    2
    Views
    635

    Thank you. It is an Excel file, corrupted by an...

    Thank you. It is an Excel file, corrupted by an otherwise excellent student.

    Yes, it was plugged into a Mac. No, she doesn't think there was a dongle involved.

    Unless someone else has a...
Results 1 to 25 of 338
Page 1 of 14 1 2 3 4