Forum Discussion
FINDING TOTAL NUMBER OF DAYS
I have actually submitted this problem to 2 other forums, but haven't had any luck solving it. If it is unsolvable, can someone please let me know. When I began working on this, I thought it was going to be easy...just a matter of a few IF formulas, but I couldn't figure it out. I am trying to learn Excel and I took this on as a learning exercise. Although I have learned quite a bit while researching the problem, I still haven't solved it. I thought I had come close using Arrays, but my laptop crashed and I lost my formula, along with 10 pages of other formulas that did not work. I keep track of each formula I try and the results. I have explained what I am attempting to accomplish in the file 12-01-. I am looking for ANY ideas how to figure it out. Thanks in advance.
P.S. I am using Excel 2019.
On the basis of illustration by you above and what I've realized, trying to solve the issue, check the attached file and let me know whether is working or not!!
13 Replies
I've examined both the sheets and came to the conclusion that 12-01 is summary of MAS, if so there is no match between source data (MAS) and the summary (12-01),,, let me say Y,,, lowest for A is MAS is 116.74 & highest is 119.23 so unable to understand that how U got values in Row 2 of 12-01,,, and the date 12-1 in G2 is clueless !!
The exercise you are trying to accomplice are not properly described & reflects a complicated questions!!
So my suggestions are,,
Show us Few Source data and the Expected results then finding difference of days will become logically much easier ,, for example this is what "#1 - Find if A2 is in OMAS= or not. If not, then leave the cell blank. If it is, then:"
What I've realized that, you are trying to fine the lowest and highest of each symbol, also the difference of days between lowest and highest and possibly the difference between the lowest and highest,,, if so pleas reply this post.
Thanks for replying Rajesh-S. I think that may be my biggest problem...not doing a very good job of describing what I want. I just found out that OMAS- file was incorrect, so I corrected it and uploaded it in my original post, so if you downloaded my original file, please download the updated file. I will try to explain what I am trying to accomplish:
in cell K2 of 12-01- :
SYMBOL = A; H2 is less than I2, so if B2+1 (116.36 or higher) is found in Column D in OMAS-, which it is in cell D6 (116.44), I take the date in G6 and subtract G1 from 12-01-, thus 12/07 - 12/01 = 6 days, which goes in K2.
Does this make it any clearer? Please advise me of which part you are having difficulty understanding and I will try my best to explain it. Also be advised that the original OMAS file is over 287K and the 12-01 file is 676 rolls. I don't know if that will make any difference or not.On the basis of illustration by you above and what I've realized, trying to solve the issue, check the attached file and let me know whether is working or not!!
