Hello all,
I have 2 tables 2022 and 2023 each set up with the same columns
The Date column contains duplicates, this formula gives me the total unique days
{=SUM(1/COUNTIF(PRODN[Production Date],PRODN[Production Date]))}
How do I do the reverse, for let's say the 83rd Production day in 2023 (from the the 2023 table it is 23-Apr-2023), how do I get the date of the 83rd day in the 2022 table. Not using the 83rd calendar day because if no work is done on certain days, those days won't count towards the actual work days. I want to get the 83rd date from the array.
Edit: Attached Workbook
TEST.xlsx
Bookmarks