1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

month & year as result

Discussion in 'Ask an Excel Question' started by JAlandhar 201718, Aug 8, 2018.

  1. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    57
    This is the new thread I'm opening again, as I'm always told to post in your old thread, and I'll get reply in that thread only.

    I posted my query on Saturday (04th of this month), but no view or reply yet.

    So kindly tell me is there any other rules regarding ???

    Please help me for the required file..

    1) PART - 1 , THE NARRATION COLUMN SHOULD BE DEFINED FROM THE
    TABLE FROM SHEET "D2K16", AS
    VOU NO - 170034, WITH AMOUNT 200 , THE NARRATION SHOULD BE FROM "MONTH R FOLLOWED BY YEAR" AS "APRIL 2016", THE 4 MUST SHOW THE MONTH OF YEAR.

    2) THE LAST DATE AS ON 31/03/17 SHOW 0 AMOUNT, IF THE AMOUNT IS 0 IN THIS COLUMN IT MUST TAKE THE AMOUNT FROM [D2K16!H2:H25] AS FOR EXAMPLE IT SHOWS 4212, SO THE AMOUNT MUST CHANGED FROM 0 TO 4212

    *THE DATE MUST BE IN SEQUENCE AS VIEWED*

    3) CAN THE NARRATION OR NARR1 EDITABLE, AS I JUST NEED ONE "DIVIDENT" IF IT CONTAIN DIVIDENT IN THE LINE


    (When you'll open the sheet, you will get to know about my query)

    Attached Files:

  2. pecoflyer

    pecoflyer Active Member

    Messages:
    197
    As we are all friends here, there is no need to shout ( uppercase = shouting)
    If you don't get answers, perhaps your explanation is not clear ?
    Also keep in mind that this a a free forum manned by volunteers. Finding someone to help you with a question should work, but for an entire project or multiple questions in the same post it will be more difficult.
    Anyway, good luck with your query
  3. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    57
    Sir, I'm not shouting to anyone, sorry for that

    as I was in a hurry, and my software works in capital letters only, so as i switched my screen and typed as it was.. sorry for that
    Last edited by a moderator: Aug 8, 2018
  4. vletm

    vletm Excel Ninja

    Messages:
    3,877
    JAlandhar 201718
    (When you'll open the sheet, you will get to know about my query)
    Did You mean this?
    Screen Shot 2018-08-08 at 11.50.50.png
    ... next there needs PassWord for Project ... hmm?

    'following things i need'
    Have You follow that Yourself?
    If You have, then You would add those steps someway that other would too.
    You would use same terms in both eg where is 'month r followed by year'?

    .xlms-file, why there are those (same) formulas?

    So ... what would be those 'following things You need'?
  5. Marc L

    Marc L Excel Ninja

    Messages:
    4,221
    No, still unclear !
    As here it's the Excel formula forum, in case it's a VBA concern
    you create this thread in the wrong section …
  6. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    57
    Please ignore that error.
  7. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    57
    Sir, as the main file is of big size, like of 15 mb, I cannot upload that..coz of privacy issue, so I created a copy of that file, where i need alteration.

    Ignore the error and let me know if you need to know any thing else
  8. vletm

    vletm Excel Ninja

    Messages:
    3,877
    JAlandhar 201718
    I wrote six times '?' ( = questions )
    I got one line answer ... hmm ...
    Which error or what would I ignore?
    Alteration .. yes ..
    I would clear those formulas away
    ... What else would You accept?
    Without clear answers ... yes!
  9. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    57
    sorry for everything sir,

    Please clear those formulas and help me for the query I wanted to get solved, It will not be repeated again
  10. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    57
    I'm uploading the file again, Please help me for the following queries below

    1. automatically Month should be defined from the number as 4 = april, 5 = may

    2. if the coulmn value is 0, it must pick value from the other column

    3 can some words can be picked from the line, as if the line contain divident word, the result musst be divident in return


    Thankyou everyone, and sorry if there is any other mistake

    Attached Files:

  11. vletm

    vletm Excel Ninja

    Messages:
    3,877
    JAlandhar 201718
    Did You read my #4 Reply?
    especially after 'following things i need'

    I can delete those formulas,
    but should someone else that You figure
    what after that?
  12. JAlandhar 201718

    JAlandhar 201718 Member

    Messages:
    57
    Sir, I changed that file from .xlsm to .xls, and Can I message you personally, as I didn't get the line

    "'following things i need'
    Have You follow that Yourself?
    If You have, then You would add those steps someway that other would too.
    You would use same terms in both eg where is 'month r followed by year'?"


    All I want is to keep the previous formulas as it is, and update it with new formulas and new queries
    Last edited by a moderator: Aug 9, 2018
  13. vletm

    vletm Excel Ninja

    Messages:
    3,877
    JAlandhar 201718
    Of course, You can.
    ... my reply and my possible action will still stay same.
  14. AliGW

    AliGW Active Member

    Messages:
    246
    Vletm - with respect, your requests are no clearer than the OP's questions. Some of them make very little sense at all. Given that neither of you speaks English natively (at least, so it would appear), I would think a bit more tolerance and willingness to rephrase might be in order, on both sides. At the moment, this is a complete stalemate. Not a pretty sight. :(
  15. vletm

    vletm Excel Ninja

    Messages:
    3,877
    AliGW - thanks -
    Any feedback is always welcome.
    Which my requests are no clearer?

    For me, questions needs answers, which would help 'OP'; not necessary me.

    Did You read his 'following things i need'?
    Can You follow those?

    It would be better sometimes give - not only want.
    It would be better have plan/rule first - not only change those.
  16. AliGW

    AliGW Active Member

    Messages:
    246
    As a native English speaker, I have no clue what you are asking for here:

    This needs clarification.
  17. vletm

    vletm Excel Ninja

    Messages:
    3,877
    AliGW - okay
    Look that 'following things i need'.
    I need to know
    - where are those 'terms' in that sheet
    = add eg textbox with number to see place
    - and next step would have next number and place and so on...
    This would be for me like a path, from begin to end.

    Term 'month r followed by year'
    ... Where is used that term in sheets?
    ... I know month and year, but what would be those in sheet?
    ... Have You found it?
    eg If use term "VOUNO".
    That is possible find eg D2K16!G1 and T2K16!B5.
    = same text should use in both (sheet and 'following things i need'.

    Any better?
  18. AliGW

    AliGW Active Member

    Messages:
    246
    I think that's better - let's see if the OP is any clearer in his understanding now.

    I am a teacher by trade: I know how explicit you have to be with people whose knowledge and understanding are less than your own. It is very easy to assume that they should know something that you think obvious, when in fact it isn't at all to them. :)

    I think you could take a little more time to express yourself clearly and to be understanding of another's lack of competence.

    Having said this, I fully understand your frustration with the OP: as a moderator on other forums, I would be tearing my hair out with the duplicate posts here. ;)
  19. Marc L

    Marc L Excel Ninja

    Messages:
    4,221


    As Time is on helpers side …​
  20. vletm

    vletm Excel Ninja

    Messages:
    3,877
    AliGW
    I've been a teacher too
    - everyday could learn something new too.
    I am a teacher by trade: I know how explicit you have to be with people whose knowledge and understanding are less than your own.
    I won't start to compare someone with me!

    Frustration ... not me! Why should I be?

    As I wrote, I ask questions which would help OP - not me.
    If skipped question then OP maybe haven't had plan... idea - who knows?

    Did You read his 'following things i need'? Yes/No?
    Can You follow those? Yes/No?
    Ps. I'm not worry about my hair ... anymore ;)
  21. AliGW

    AliGW Active Member

    Messages:
    246
    We are all learning all the time - look at my signature line! ;)
  22. pecoflyer

    pecoflyer Active Member

    Messages:
    197
    I don't know how to translate these verses by the French poet Boileau:
    " Ce qui se conçoit bien, s'énonce clairement
    Et les mots pour le dire nous viennent aisément" :DD
  23. Marc L

    Marc L Excel Ninja

    Messages:
    4,221
    I use this sentence from Nicolas Boisleau on a local forum too …

    Following the same idea from the great Albert :
    « If you can’t explain it simply, you don’t understand it well enough … »
    Albert Einstein
  24. AliGW

    AliGW Active Member

    Messages:
    246
    Very roughly:

    "He who understands can explain clearly,
    And the words he uses to do so come easily to us (that is, we understand the words he uses)."

    As I say, very roughly translated, more to convey the meaning that the exact words.
  25. Marc L

    Marc L Excel Ninja

    Messages:
    4,221
    As the literal translation of Nicolas Boisleau thought is

    « What is well conceived, is clearly stated.
    And the words to say it come easily … »

    Why I found a link with the great Albert.

Share This Page