Pavan Kumar Sistla
Member
Hello Everyone,
Could you please help me in retrieving the unique lookup value based on repetitive value as part of Index & Match. Attached is the excel for reference. Based on frequency which has repetitive values, unique vehicle no. has to be retrieved instead of the same lookup value (which comes as 1st value by default).
Thank You and Regards,
Pavan.
Could you please help me in retrieving the unique lookup value based on repetitive value as part of Index & Match. Attached is the excel for reference. Based on frequency which has repetitive values, unique vehicle no. has to be retrieved instead of the same lookup value (which comes as 1st value by default).
Thank You and Regards,
Pavan.