# Search:

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

Page 1 of 6 1

1. ## Thread: Sum column using NOT equal to criteria

by joeu2004
Replies
4
Views
101

### Re: Sum column using NOT equal to criteria

[.... deleted by me .... I like Jonmo1's formula better ]

by joeu2004
Replies
1
Views
100

### Re: Binary Data

I would advise against responding constructively.

There have been at least two other threads with similar questions, perhaps in the "other" forum. I regret that I contributed to one of those...
3. ## Thread: Standard Deviation Function

by joeu2004
Replies
6
Views
183

### Re: Standard Deviation Function

Well, that is correct. But I meant to put the caveat after the ISNUMBER expression.

The point is: if we put a comma after the value-if-true part, the missing value-if-false will be interpreted...
4. ## Thread: Standard Deviation Function

by joeu2004
Replies
6
Views
183

### Re: Standard Deviation Function

It is difficult to say what the problem is unless you post your formula. Ideally, upload an example Excel file to a file-sharing website and post the download URL here, so we can see the data that...
5. ## Thread: Standard Deviation Function

by joeu2004
Replies
6
Views
183

### Re: Standard Deviation Function

Caveat: AhoyNC used STDEV.S (aka STDEV). That is an approximation of the standard deviation of a larger population (set of numbers), based on the assumption that the selected numbers are a...
6. ## Thread: Calculate Growth Value When Drawing Down Funds

by joeu2004
Replies
4
Views
214

### Re: Calculate Growth Value When Drawing Down Funds

-----

With a fixed withdrawal amount, you can use NPER to calculate the number of years for the withdrawal phase, to wit (in...
7. ## Thread: Calculate Growth Value When Drawing Down Funds

by joeu2004
Replies
4
Views
214

### Re: Calculate Growth Value When Drawing Down Funds

It is unclear to me exactly what you want to calculate. Perhaps something like the following.

<tbody>

A
B
C
8. ## Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
389

### Re: Convertic scientific notation to text format

.... Unless you have a priori knowledge of the number of digits that precede the "E"?

If you know, describe the syntax of all text that Excel might interpret as a number, and I'm sure that someone...
9. ## Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
389

### Re: Convertic scientific notation to text format

For your example, I know. I was just describing the general problem in order to explain why opening CSV files directly is not a good idea if your intent is for part of it not to be interpreted by...
10. ## Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
389

### Re: Convertic scientific notation to text format

That is incorrect. As long as the data looks like 135087E67 in the cell when you save as CSV, Excel writes 135087E67 into the file. Open the file with Notepad to confirm.

The problem is: a CSV...
11. ## Thread: Convertic scientific notation to text format

by joeu2004
Replies
12
Views
389

### Re: Convertic scientific notation to text format

If all the data that should be text are the entire content of their respective columns, it is better to import the CSV file instead of opening it directly in Excel.

Otherwise, if any of your IDs...
12. ## Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
305

### Re: Excel formula (not VBA) to extract delimited string?

Not exactly. If you look at the IF support page, we see the same list, not mentioning Excel 97, let alone Excel 2003, to wit:

Do you really believe that means the IF function was introduced...
13. ## Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
305

### Re: Excel formula (not VBA) to extract delimited string?

That is incorrect!

First, when we save as "xls" in Excel 2010, the compatibility checker does not flag the use of SUBSTITUTE. In contrast, it does flag the use of COUNTIFS.

Second, I still...
14. ## Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
305

### Re: Excel formula (not VBA) to extract delimited string?

Thanks FormR and Peter. Rick's article is definitely a keeper. Just an observation.... I'm a big fan of explaining assumptions, for the benefit of the unsuspecting user. The TRIM/REPT paradigm...
15. ## Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
305

### Re: Excel formula (not VBA) to extract delimited string?

Thanks for the ideas, Fluff and DanteAmor.
16. ## Thread: Excel formula (not VBA) to extract delimited string?

by joeu2004
Replies
12
Views
305

### Excel formula (not VBA) to extract delimited string?

I have the abstract string "firstString/secondString/thirdString/fourthString" in C2.

I want to use a single Excel formula (not VBA; no helper cells) to extract "secondString". Any ideas?

Note...

by joeu2004
Replies
4
Views
135

### Re: Index Error

I have not studied the formula, but my first impression is: did you array-enter the formula by pressing ctrl+shift+Enter instead of just Enter?

I suspect that is necessary in order for the...
18. ## Thread: Future value formula

by joeu2004
Replies
4
Views
116

### Re: Future value formula

This is due to the difference between "simple" interest and "compound" interest.

Your SUM formula is calculating "simple" interest based on the initial balance (G5). In other words, you earn...
19. ## Thread: hiding only +ve numbers

by joeu2004
Replies
2
Views
72

### Re: hiding only +ve numbers

As you say, one Custom format is of the form postive;negative;zero.

So perhaps you want: ;-General;General

Change "General" to any specific format that you want. And omit the last ";General"...
20. ## Thread: numbers to text and text to numbers

by joeu2004
Replies
13
Views
210

### Re: numbers to text and text to numbers

I explained all this in response #2 , posted 20 minutes earlier.

First, you are not "converting" to text when you change the format to Text. Proof: ISNUMBER(A1) is TRUE after changing the format...
21. ## Thread: numbers to text and text to numbers

by joeu2004
Replies
13
Views
210

### Re: numbers to text and text to numbers

But simply changing a numeric format (General, Number, etc) to Text, as Leza is doing, does not "convert it to text".

And the appearance after changing the format to Text depends on how the number...
22. ## Thread: numbers to text and text to numbers

by joeu2004
Replies
13
Views
210

### Re: numbers to text and text to numbers

I don't know what Home > Number does in your version of Excel. In my version, you might be talking about the feature on the ribbon that selects the cell format. Note that it selects a format for...

by joeu2004
Replies
5
Views
149

### Re: Help with explaining this formula, Please

We don't know; you tell us(!). After 345 posts, I think that you should know how to ask a question about formula behavior by now, in order to get the quickest and most applicable response.

At a...
24. ## Thread: VLOOKUP Returns #NA when data is present

by joeu2004
Replies
14
Views
172

### Re: VLOOKUP Returns #NA when data is present

I do not see 220175 or any of the 3xxxxx product numbers (D2:D15) in A2:A139 of the "New Prices" worksheet.

I suspect that is true in many/most/all cases.

I do not see 714116 in both...
25. ## Thread: Dates Before 1900 Formula

by joeu2004
Replies
7
Views
202

### Re: Need Help With Dates Before 1900 Formula

Hmm, if you are using a Mac, I would think that the 1904 option is enabled already. Or did you receive the file from a Windows user?

Anyway, yes, the 1904 option is entirely appropriate to use on...
Results 1 to 25 of 150
Page 1 of 6 1