Respected,
The display is the answer that I need to get from formula.(means just one numeral with plus or minus sign Meaning is just added to give somewhat of description.
Zohar![]()
Please Login or Register to view this content.
Respected,
The display is the answer that I need to get from formula.(means just one numeral with plus or minus sign Meaning is just added to give somewhat of description.
Zohar![]()
Please Login or Register to view this content.
Last edited by JBeaucaire; 05-02-2017 at 11:57 PM.
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
Leave c2 empty.
In c3 write formula:
Formula:
Please Login or Register to view this content.
and copy it down.
Note that in C9 you will get 4, beacuse B9 (-0,8) is fourth decreasing value in a row
Best Regards,
Kaper
Respected KAPER,
THANK YOU VERY VERY VERY MUCH
Zohar Batterywala
Respected,
Originally the completed field is having the RAW data from other instrumentation of daily readings of level.
the format is (+x.x(+x.x#+x.x)) And + shows that the reading is above Zero. If it is below zero , it is "-"(-x.x(-x.x#-x.x)).
when that formula was inserted in the data that is feeded in the sheet . output is not consistent.
Am attaching the completed sheet with the data on which I had applied the solution.
Zohar Batterywala
Respected,
Originally the completed field is having the RAW data from other instrumentation of daily readings of level.
the format is (+x.x(+x.x#+x.x)) And + shows that the reading is above Zero. If it is below zero , it is "-"(-x.x(-x.x#-x.x)).
when that formula was inserted in the data that is feeded in the sheet . output is not consistent.
Am attaching the completed sheet with the data on which I had applied the solution.
Am posting again as I cant find the attachment.
Zohar Batterywala
As you can see, your column F is left-aligned. It is a clear message from Excel, that you got texts there.
While my formula expects numbers as input.
So in F2 (and copy down) write not just Left function, but:
Formula:
Please Login or Register to view this content.
Notice that column F is right-aligned now, as there are numbers, not texts, which just look like a number.
Best,
Respected Sir Kaper,
yes , worked.
Thank you VERY MUCH
Zohar Batterywala
Respected Sir Kaper,
Has changed the formula in all that to make its work with you suggested solution(value(LEFT)). (column E,F,G)
Need some way to make it such that if some data has not +sign in front of positive number, then also the function will execute.(column H,I,J)
I think there will be no issue with negative numbers(-)
Zohar Batterywala
Do not focus on leftmost 4 characters. Instead, look for the position od percent sign, like J2:
Formula:
Please Login or Register to view this content.
By the way, it reminds me the famous GIGO rule - If you do not show representative input, do not expect proper output![]()
Respected Sir Kaper,
you are right in your say that I did not mentioned correct input but as the data on which I am working is somewhat sensitive, so I am not allowed to share exact data.
Sorry for that
Zohar Batterywala
Respected Sir ,
I have applied this formula to other cells but it is not getting the the desired output.
I am sure that I am not of your (expert) level so am not able to tweak the formula accordingly.
Please tweak the formula and the best to the original value is in E , so I need proper output in Column F
If I understand correctly then the following formula will populate column F with the values to the left of the open parentheses mark in the cells in column E:Let us know if you have any questions.Formula:
Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Respected JeteMc,
Yes it is orking.
I was not well , so didnt log in for two days
Zohar Batterywala
Glad that the formula works and that you are now feeling better. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
Respected JeteMc,
Last Help need in solving this issue.
I had applied the formula and it is working in columnD(D22,D25,D28...) ,
Now as there is space constraint, so has to merge it with column E(E22,E25, E28,......,
All other is working but its not working when the result is +ve (eg E28)
Increasing/decreasing count can be at fromt or back so I can call it in another cell using LEFT, or RIGHT
The functionality is needed in column E,F,G,H,L & O
Zohar Batterywala
Respected JeteMC.
The output in D28 is as per the formulas given by you on saturday after doing needed modifications and that is correct=VALUE(LEFT(E2,FIND("(",E2)-1))
and its correct as E21= -1.49 , E24= 0.29 & E72= 0.72 , so its increasing , so the output 2 is correct and that should be same in first digit in E28 but it shows 0
Zohar Batterywala
The formula in E28 begins: =IF(AND(LEFT(E25,2)<>"",LEFT(E25,2)>0,E27>D24),LEFT(E25,2)+1...
LEFT(E25,2) is -1 and -1+1=0
It would seem that if the values in column D are correct as is the case with D28, then it seems the formula in E28 could read: =IF(AND(LEFT(E25,2)<>"",LEFT(E25,2)>0,E27>D24),D28...
Let us know if you have any questions.
Respected JeteMC,
Please mention the completed formula as it is not easy for me to find error if it occurs.
It is okay for me to change the cell references.
But please construct atleast one formula AND I can create other based on that
Zohar Batterywala
Try the following in E28:Let us know if you have any questions.Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks