Hi Vijayendra
Copy and paste the below formula in AJ6 cell
=IF(COUNT($G6:$R6),LOOKUP(10^10,$G6:$R6,$G$5:$R$5),"")
Drag the AJ6 formula to the remaining cells of AJ Column.
Refer the attachment file for details.
Hope that helps!
Let us know, in case of any further assistance.
<><><><><><><>
Dear All,
I have some data which includes amount data. I need the latest data’s date.
Request you to let me know what formula I can use it for the same.
Excel file is attached with example.
Regards,
Vijayendra
94491 67631
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
--
Join official facebook page of
