# Search:

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

Page 1 of 14 1

1. ## Thread: Conditionally Void a Cumulative Sum

by boobounder
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. ## Thread: Conditionally Void a Cumulative Sum

by boobounder
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. ## Thread: Conditionally Void a Cumulative Sum

by boobounder
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. ## Thread: Conditionally Void a Cumulative Sum

by boobounder
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. ## Thread: Collapse range's entries by removing some values

by boobounder
Replies
3
Views
582

### 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. ## Thread: Collapse range's entries by removing some values

by boobounder
Replies
3
Views
582

### 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. ## Thread: Format/Strategies for HTML Output

by boobounder
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,...

by boobounder
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 ...

by boobounder
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. ## Thread: Need to improve partition/drive security

by boobounder
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. ## Thread: "Average" a Range of Strings (Like They Were Numbers)

by boobounder
Replies
13
Views
1,038

### 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. ## Thread: "Average" a Range of Strings (Like They Were Numbers)

by boobounder
Replies
13
Views
1,038

### 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. ## Thread: "Average" a Range of Strings (Like They Were Numbers)

by boobounder
Replies
13
Views
1,038

### 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. ## Thread: "Average" a Range of Strings (Like They Were Numbers)

by boobounder
Replies
13
Views
1,038

### "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. ## Thread: Pass a File to a URL

by boobounder
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. ## Thread: Pass a File to a URL

by boobounder
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. ## Thread: 1 Filetype 2 Different Icons

by boobounder
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. ## Thread: 1 Filetype 2 Different Icons

by boobounder
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...

by boobounder
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...

by boobounder
Replies
10
Views
11,926

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

No probs RetiredGeek ... we're all friends here.
21. ## Thread: 1 Filetype 2 Different Icons

by boobounder
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...

by boobounder
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.

by boobounder
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. ## Thread: 1 Filetype 2 Different Icons

by boobounder
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,...

by boobounder
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