Dec 16 2021 09:24 PM
Dec 20 2021 09:54 AM
Hi @Haseeb2021,
If you don't have Transaction_ID for each records then the best solution I can propose you to enter the date & time together, that will create unique entry for each transaction and lookup the value with date & time.
Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.