LinkBack URL
About LinkBacks
Respected Sir/Madam,
Has to extract a number that is middle of characters and symbols
+
one another
Zohar
Respected Sir/Madam,
Has to extract a number that is middle of characters and symbols
+
one another
Zohar
Last edited by AliGW; 01-27-2020 at 09:53 AM. Reason: Urgency statement removed from thread title and post.
Please note: all queries are treated the same here. please don't ask for or expect yours to be treated with urgency. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Respected Madam AliGW,
SORRY for that
but
after getting this formula , I have to make 7-8 formulas as per the data and repeat(paste) it in a 1000+ days data.
and the line manager is getting impatient. BTW I am from india and now here it is 8 pm.
Zohar
=--LEFT(SUBSTITUTE(MID(A3,FIND("║NF‰",A3)+LEN("║NF‰"),LEN(A3))," ",REPT(" ",LEN(A3))),LEN(A3))
LEN("║NF‰")could be replaced to number and LEN(A3) to number not less then light of source
Respected,
Thank you BMV,
The second one is surely very easy compared to this. PLEASE PLEASE look it.
---
Zohar
Respected BMV,
There is some problem in making it to calculate other combinations.
PLEASE help me.
Zohar
In G3
=TRIM(RIGHT(SUBSTITUTE(LEFT(SUBSTITUTE(A3,"%",REPT(" ",255)),255),"NF‰",REPT(" ",255)),255))
Copy down
In G12
=TRIM(RIGHT(SUBSTITUTE(A12,"║10DA",REPT(" ",255)),255))
Copy down
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Life's a spreadsheet, Excel!
Say thanks, Click *
Respected Sir Ace_XL
THANK YOU and also please solve the other problem that is on 24th row.
Zohar
Absolutely of no interest or consequence to us, I am afraid. The help you get here is given by volunteers in their own time and for free, so please don't treat it like a paid service. Thank you for your understanding.And the line manager is getting impatient.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Respected Madam AliGW,
That is not the Post I have posted Here.
I will post that URL and the Query both.
https://www.ozgrid.com/forum/index.p...32#post1229332
Zohar
Thank You for providing the link.
The five possible outcomes are displayed in cells K22:K26
The formula for cells E25:E29 is: =IF(AND(A25-C25>D25,C25-B25>D25),K$26,IF(C25-B25=0,K$22,IF(A25-C25=0,K$25,IF(A25-C25<C25-B25,K$24,K$23))))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Respected Sir JeteMc,
Really I am spellbound, you have really helped me very much .THANK YOU THANK YOU VERY VERY MUCH.
Can I replace outcomes in place of Static addressed $K$22, $k$23, $k$24, $k$25, $k$26??
And Can you please edit the formula where in WLN▲ WLN▼, the case triggers even when Last is near 0.001% of high or low
So the case will be
High Low
8441 8390.15 8390.15 16.78 WLN▼
8441 8390.15 8389.55 upto 8389.31 or 8390.98 as 0.83 is 0.001%
8416 8384.5 8416 16.83 WLN▲
8416 8384.5 8416.8 upto 8415.17 or 8416.83 as 0.83 is 0.001% (this figures are in two decimals(which is given in data source)
THANK YOU ONCE AGAIN
Zohar
If I understand correctly then I believer you can replace the formula in E25 with:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Respected Sir JeteMc,
I had tried to incorporate ranges in formula but due to some mistake(which I was not able to find) I am getting wrong results , so please help me.
For my work Incorporating range is important as there are about 13 places where this formula has to be inserted and non has extra cells for specifying range.
Zohar
Respected Sir JeteMc,
Thank you for extending your help.
I am very SORRY for not seeing your post before writing another post. AGAIN SORRY.
Have 2 more case where WLN▼ should be trigerred even if last above low by 0.001%-(originally fast gust at last movement may change the level)
WLN▲ should be trigerred even if last Below high by 0.001%
Has attached excel sheet indicating this
Let me attempt to state my understanding of how the formula should incorporate ranges:
1. If Last is not between the High and Low then OR
2. If Last is within 0.001% of High then WLN▲
3. If Last is within 0.001% of Low then WLN▼
4. If Last is closer to High than Low then LN▲
5. If Last is closer to Low then High then LN▼
If all of the above are correct then try the following in cells E12 and down:Formula:Please Login or Register to view this content.
If the above 5 statements are not all correct then please provide the correct information.
Let us know if you have any questions.
Respected Sir JeteMc,
I am very SORRY because the last file I uploaded was the non-complete version . So am uploading again. AGAIN SORRY.
Mistakes-one case is shown to show last value that is even lower than the low and that is not possible.
other case is shown to show last value that is even higher than the high and that is not possible.
Have 2 more case where WLN▼ should be trigerred even if last above low by 0.001%-(originally fast gust at last movement may change the level)
WLN▲ should be trigerred even if last Below high by 0.001%
has also posted on other forum
https://www.ozgrid.com/forum/index.p...09#post1229462
Zohar
If there is supposed to be an .xlsx file attached to post #18, I am not seeing it....the last file I uploaded was the non-complete version . So am uploading again.
Question: by 0.001% do you mean one-thousandths of one percent (0.00001)?
Question: What does "originally fast gust at last movement may change the level" mean and is it important to take into consideration in writing a formula?
Respected Sir JeteMc,
I was outstation and so was not able to answer since last 3 days. SORRY
Question: by 0.001% do you mean one-thousandths of one percent (0.00001)?
Answer yes -have tried on that type of scenario in excel
Question: What does "originally fast gust at last movement may change the level" mean and is it important to take into consideration in writing a formula?
Answer -sometimes(originally once in a fortnight-but that not important ) it happens that after noting down the last level and closing the gates , the water level is at brim of gates(as it is on WLN▲ or WLN▼ and due to fast movement of water in upper & lower reservoir that end level changes as some water spills back to main reservoir. so we have to consider that also,
I think the issue is solved at this time, Will need your help when something that I am not able to understand comes while applying this in the main file as that are low of dependents of this figure.
Zohar
Last edited by ZOHAR; 02-05-2020 at 12:36 AM.
Glad that the issue is resolved to your satisfaction. Please mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks