|re: "I would like to see the latest DONE, F1 should be blank if no DONE's have been entered..."|
This brute force Nested IF formula will give you the values you want, assuming the user has followed the process:
This more elegant formula should also give you the results you want, but again assuming the user has followed the process.
re: "But if user were to key in A1 & B1 with DONE than he skip C1 and key in D1 with DONE..."
Dealing with users that skip cells can be difficult to handle via a formula.
If it were me, I would use Data Validation that would not allow the user to enter DONE into a cell unless the previous cell already contained DONE.
In other words, don't let them enter DONE on B1 unless A1 already contains DONE. Then don't let them enter DONE in C1 unless B1 contains DONE, etc.
If you do that, then the formulas above will always be accurate.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.