I have the following table where we have the same ID and date. However, I want to create an array that changes the ID based on the ID and the date.
The formula I have tried is:
=IF(AND(DROP(TAKE(A:A,COUNTA(A:A)),1)=12345,DROP(TAKE(B:B,COUNTA(A:A)),1)<DATE(2024,1,1)),”54321″,DROP(TAKE(A:A,COUNTA(A:A)),1))
but record 3 is not giving correct answer
New contributor
andy leary is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.