Search:

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

Page 1 of 14 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    23
    Views
    800

    I haven't forgotten about this ... just swamped...

    I haven't forgotten about this ... just swamped with a different project.
  2. Replies
    23
    Views
    800

    Oh gosh ... I missed a big problem. This...

    Oh gosh ... I missed a big problem.

    This spreadsheet is used for grades. It gets wider through the semester. The named ranges I have pre-defined expand as I add grades to their interiors, always...
  3. Replies
    23
    Views
    800

    This is a big help, and I'm learning a lot. ...

    This is a big help, and I'm learning a lot.

    Here are some of the issue I've come up with.

    1) The code fails badly if there's a blank cell in the middle of column B. The general plan is to have...
  4. Replies
    23
    Views
    800

    1) The current exportHTML macro exports 2 named...

    1) The current exportHTML macro exports 2 named ranges from each sheet as individual HTML files, so 6 worksheets in my workbook yields 12 files on my desktop.

    2) Your SortPart macro runs, but I'm...
  5. Replies
    23
    Views
    800

    Fair enough. But I don't know how to do that....

    Fair enough. But I don't know how to do that. Thus the thread.
  6. Replies
    23
    Views
    800

    Reply to Maudibe: This isn't quite right. I don't...

    Reply to Maudibe: This isn't quite right. I don't want to permanently delete the information in those cells. All I want to do is export an HTML file in which those values are blanked.

    Reply to...
  7. Replies
    23
    Views
    800

    Try this. It's an xlsm based on the xlmt.

    Try this. It's an xlsm based on the xlmt.
  8. Replies
    23
    Views
    800

    I've attached another file. It's an xltm from...

    I've attached another file. It's an xltm from Excel 2013.
  9. Replies
    23
    Views
    800

    I only included a stub spreadsheet because the...

    I only included a stub spreadsheet because the real one is large. I figure the solution I need doesn't need all that detail.

    I am not wedded to this suggestion, but I think this is what I would do...
  10. Replies
    23
    Views
    800

    Modifying a macro

    I have two Excel macros that I often run consecutively. I need to filter the results in the second one.

    The first does a sort over a named range:


    Application.Goto Reference:="Sort_Block_1"
    ...
  11. Replies
    5
    Views
    161

    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...
  12. Replies
    5
    Views
    161

    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?
  13. Replies
    5
    Views
    161

    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...
  14. Replies
    5
    Views
    161

    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...
  15. 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...
  16. 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...
  17. Replies
    0
    Views
    174

    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,...
  18. Replies
    4
    Views
    476

    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 ...
  19. Replies
    4
    Views
    476

    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...
  20. Replies
    11
    Views
    5,331

    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...
  21. 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)....
  22. 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....
  23. 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...
  24. "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...
  25. Replies
    5
    Views
    1,267

    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?
Results 1 to 25 of 348
Page 1 of 14 1 2 3 4