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.
I'm not focused today. Really sorry about that cause the best solution mark should be accounted to you. How I can fix this issue? I'm new to tech forums in general.
Ilya_M Don't know how to fix it. Doesn't really matter. Have a good day!