Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.15 seconds.

  1. Replies
    4
    Views
    101

    Re: Sum column using NOT equal to criteria

    [.... deleted by me .... I like Jonmo1's formula better ]
  2. Thread: Binary Data

    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. 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. 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. 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. Re: Calculate Growth Value When Drawing Down Funds

    You're welcome. Given your changes, the following might be helpful.

    -----

    With a fixed withdrawal amount, you can use NPER to calculate the number of years for the withdrawal phase, to wit (in...
  7. 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. 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. 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. 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. 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. 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. 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. 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. Re: Excel formula (not VBA) to extract delimited string?

    Thanks for the ideas, Fluff and DanteAmor.
  16. 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...
  17. Thread: Index Error

    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. 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. 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. 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. 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. 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...
  23. 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. 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. 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 2 3 4