Forum Discussion
Solved
How to assign a value to a next duplicate (sorted by dates) cell.
I can set a cell value for the first of two/three duplicate entries but cannot find a way to assign a cell value for the next duplicate entry. Any help is greatly appreciated.
Hello there!
What an elegant "old-school" 🙂 solution! Thank you so much for your time! I had a feeling that it could be solved using just IF condition. It's a more programming approach to me.
Yes, you're absolutely right - I've made a mistake in the formula (legend section). My bad :-).
For entries G12-G14 and G25-G27 the table has three date entries (some days a team has more than just one task activity). As well as there some time entries discrepancies that I have to fix.
Once again thank you.
Cheers.
Thank you very much, Abiola. Unfortunately, these examples were not that helpful. I also tried some of the solutions described there.