Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Copy cell contents to new cells automaticly

  1. #11
    New Member
    Join Date
    May 2002
    Location
    Germany
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Aladin,

    the correct name is DATA0001 (Data1), DATA0002 (Data2), DATA0021 (Data3) and DATA0031 (Data4).

    This means, the input may look like this:

    ___A______B________C______
    1__Name__Check____Problem
    2__Hugo__Data0001___5
    3__Hugo__Data0002___8
    4__Hugo__Data0031___4
    5__John__Data0001___0
    6__John__Data0002___4
    7__John__Data0021___2
    8__John__Data0031___10
    9__Bill__Data0002___68
    10_Bill__Data0021___7
    11_Bill__Data0031___34

    You see, the DATA0021 for Hugo and DATA0001 for Bill is missing. The maximum is three mising DATA00xx, one is at least there for every name.


    The value for DATA0001 needs to be in the overview sheet in the column named DATA0001, and so on with the other columns.

    Each missing DATA00xx has the value 0 per default.

    Again, thanks for your help.
    Stephan



    [ This Message was edited by: enne on 2002-05-11 09:21 ]

  2. #12
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    the correct name is DATA0001 (Data1), DATA0002 (Data2), DATA0021 (Data3) and DATA0031 (Data4).

    This means, the input may look like this:

    ___A______B________C______
    1__Name__Check____Problem
    2__Hugo__Data0001___5
    3__Hugo__Data0002___8
    4__Hugo__Data0031___4
    5__John__Data0001___0
    6__John__Data0002___4
    7__John__Data0021___2
    8__John__Data0031___10
    9__Bill__Data0002___68
    10_Bill__Data0021___7
    11_Bill__Data0031___34

    You see, the DATA0021 for Hugo and DATA0001 for Bill is missing. The maximum is three mising DATA00xx, one is at least there for every name.


    The value for DATA0001 needs to be in the overview sheet in the column named DATA0001, and so on with the other columns.

    Each missing DATA00xx has the value 0 per default.


    How are we supposed to infer which Data-value(s), the 1st, 2nd, 3rd, or 4th or a bunch of these values are missing?

    If there is some regularity from which we can infer which individual Data-value is missing, we could perhaps tweak the formulas to cope with missing values.

    Is it possible, for example, to leave the cell in B empty, if the Data-value is missing or enter something like -99999 for a missing value.

    Aladin

  3. #13
    New Member
    Join Date
    May 2002
    Location
    Germany
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Aladin,

    the only think I can do is to insert the missing lines on the input sheet.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •