• 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...

  • 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

J

JAlandhar 201718

Member
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)
 

Attachments

  • Copy.xlsm
    51.6 KB · Views: 8
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
 
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:
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'?
 
vletm said:
JAlandhar 201718
(When you'll open the sheet, you will get to know about my query)
Did You mean this?
View attachment 54315
... 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'?
Click to expand...
Please ignore that error.
 
Marc L said:
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 …
​
Click to expand...
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
 
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!
 
vletm said:
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!
Click to expand...
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
 
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
 

Attachments

  • query.xlsx
    40.6 KB · Views: 1
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:
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. :(
 
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.
 
As a native English speaker, I have no clue what you are asking for here:

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'?"
Click to expand...

This needs clarification.
 
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?
 
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. ;)
 
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 ;)
 
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
 
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
​
 
pecoflyer said:
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
Click to expand...

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.
 
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.
​
 
You must log in or register to reply here.
Back
Top