Hello everybody,

I have a table looking like this:

1 Block1 Proc1 Done
2 Block1 Proc2 Done
3 Block1 Proc3
4 Block1 Proc4
5 Block2 Proc1 Done
6 Block2 Proc2
7 Block2 Proc3 Done
8 Block2 Proc4 Done
9 Block2 Proc5
10 Block2 Proc6
11 Block3 Proc1 Done
... ... ... ...


I want to automatically find what was the last process (highest number) marked as done for each block. In this case, that would be Proc2 for Block1 and Proc4 for Block2. Note that the fourth column might contain blank spaces.
How could I do that within a function or using VBA? Any idea?



Thanks