Hi, each week I add a new row to a table, I add the date and a value. I am trying to find out the most recent date that I had entered the same value. I can do it Excel using a combination of index, small & row but cannot workout how to do it in Numbers as there is no support for arrays, is there.
I can count the number of occurrences of the new number, I can then subtract 1 to workout that I need the nth occurrence of the same value in the column. Once I’ve identified the row of the nth occurrence I could then use index to find the corresponding date. I’ve considered adding a hidden column to do some of the working out but have been unable to make this work.
Any help appreciated
I need to know the last date the same value had a occurred in a sequential table of dates and numbers
Device: Mac Running Catalina