I want a formula added to Column F which returns True or False based on the following criteria. For each 'NAME', if the 'Release Time' of 'NAME' X is less than the 'Release Time' of 'NAME' Y and the 'Ship Time' of 'NAME' X is greater than the 'Ship Time' of 'NAME' Y, return True, else return False.
i see the name column B
What names am I comparing the dates to
can we have some examples
38157183 as NAME X
which one is NAME Y
or are you comparing every entry
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I want to compare every entry.
So then
that row is the MIN of all the release time and the Max of all the shiptime
for ROW 2 is 22/10/2015 8:32:55if the 'Release Time' of 'NAME' X is less than the 'Release Time' of 'NAME' Y
less than any of the other rows 3 to 12534
for it to be less then them all - it would need to be the Minimum of the list
and for shiptime the MAX
so you are looking for the row entry which is the minimum and the maximum from the list
Last edited by etaf; 03-02-2016 at 06:20 PM.
Hmm. I'm getting a little confused. Let me give an example to make sure we're clear. Look at ROWS 21 and 22. The Release Time for ROW 21 is less than the Release Time of ROW 22, and the ship time of ROW 22 is less than the ship time of ROW 21, therefore ROW 21 should return True. On the other hand, ROW 222 would return False, because there aren't any 'NAMES' with a greater 'Release Time' and a smaller 'Ship Time' than ROW 222.
so you are only comparing the row belowLook at ROWS 21 and 22. The Release Time for ROW 21 is less than the Release Time of ROW 22, and the ship time of ROW 22 is less than the ship time of ROW 21, therefore ROW 21 should return True.
so
row 2 compares for row 3 and puts result in row 2
row 3 compares row 4 and puts result in row 3
if so
=IF(AND(D2<D3,E2>E3),TRUE,FALSE)
I think we're getting closer now. If you were to sort column D ascending from oldest to newest release time, we would be comparing row 2 with rows 3 - 12534, and row 3 with rows 4 - 12534.
OK,
whats missingI think we're getting closer now.
can you use a few examples now and mark true false on the sample sheet and a comment why
may help understand what you mean
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks