plasteredric
02-24-2018, 10:27 AM
Im trying to compare values between two cells, based on the values of other cells.
The attached workbook explains it better.
The formula i have in the expected results column works so long as the data is in order, however this isn't always the case, and the formula would have to check that the time is the same for both rows being compared and also find the row containing the next Rank in the sequence.
I'm not sure if a formula would do this or if it can be done using some vba code that I can integrate into my existing code.
Thanks
21691
The attached workbook explains it better.
The formula i have in the expected results column works so long as the data is in order, however this isn't always the case, and the formula would have to check that the time is the same for both rows being compared and also find the row containing the next Rank in the sequence.
I'm not sure if a formula would do this or if it can be done using some vba code that I can integrate into my existing code.
Thanks
21691