Forum Discussion
Excel formula to find the range of rows containing a value in a specific column.
That's great to know you found the solution, thank you for the update.
The limitation of it is that it works only on sorted data. More universal one like here
could be
=INDEX($C$2:$C$10, MATCH(AGGREGATE(14,6,1/($E$2:$E$10=E2)*$D$2:$D$10,1),$D$2:$D$10,0))Here AGGREGATE() finds the latest date for the ID, MATCH() returns position of such row and INDEX() returns Title for that row.
@Sergei Baklan I'd love suggestions on the row range, I think I figured out the simpler approach I performed last time. I think I used a simple IF statement that looks at the logic test comparing the current User ID to the prior (row) User ID. If not the same, then that row is the most recent record and so I pull the Title from that row's Title cell.
That's great to know you found the solution, thank you for the update.
The limitation of it is that it works only on sorted data. More universal one like here
could be
=INDEX($C$2:$C$10, MATCH(AGGREGATE(14,6,1/($E$2:$E$10=E2)*$D$2:$D$10,1),$D$2:$D$10,0))Here AGGREGATE() finds the latest date for the ID, MATCH() returns position of such row and INDEX() returns Title for that row.
AIMScto , you are welcome